아래코드는 Excel 파일을 열어서 원하는 Cell 위치의 값을 가져와서 뿌려주는 샘플 코드입니다.

static void OpenExcelApp(Args _args)
{
    SysExcelApplication ExcelApp;
    str cellValue;
    ;

    ExcelApp = SysExcelApplication::construct();
    ExcelApp.workbooks().open('C:\\text.xls');

    cellValue = ExcelApp.activeSheet().cells().item(1,1).value().toString();

    info(strFmt("Value of cell A1 = %1", cellValue);
}

static void akaRolesAndTasks(Args _args)
{
    // !# August.28.13.rvanbran:
    SecurityTask            securityTask            ;
    SecurityRole            securityRole            ;
    SecurityUserRole        securityUserRole        ;
    SecurityRoleTaskGrant   securityRoleTaskGrant   ;
    UserInfo                userInfo                ;
    ;

    info( "User|Role|Task");
    while select securityUserRole
            join securityRole           where securityRole.RecId                    == securityUserRole.SecurityRole
            join securityRoleTaskGrant  where securityRoleTaskGrant.SecurityRole    == securityRole.RecId
            join securityTask           where securityRoleTaskGrant.SecurityTask    == securityTask.RecId
            join userInfo               where userInfo.id                           == securityUserRole.User
                                           && userInfo.enable                       == NoYes::Yes
    {
        info( strFmt("%1 |%2 | %3" , securityUserRole.User, SysLabel::labelId2String2(securityRole.Name), SysLabel::labelId2String(securityTask.Name)));
    }
    info( "done");
}

static void createForm(Args _args)
{
    Args args;
    Form form;
    FormRun formRun;
    FormBuildDesign formBuildDesign;
    FormBuildDataSource formBuildDataSource;
    FormBuildGridControl formBuildGridControl;
    FormBuildStringControl formBuildStringControl;
    FormBuildStringControl formBuildStringControl2;
    FormBuildTabControl formBuildTabControl;
    FormBuildTabPageControl formBuildTabPageControl;
    FormBuildTabPageControl formBuildTabPageControl2;
    FormStringControl formStringControl;
    FormGridControl formGridControl;
    DictTable dictTable;
    int idx;
    int idx2;
    int idx3;
    ;

    // Create the form header.
    form = new Form();

// Add a data source to the form. ID 77 refers to the CustTable.
 dictTable = new DictTable(tablenum(CustTable));
 formBuildDataSource = form.addDataSource(dictTable.name());
 formBuildDataSource.table(dictTable.id());

// Create the form design.
 formBuildDesign = form.addDesign("Design");
 formBuildDesign.caption("myForm");

// Add tabbed page controls, a grid control, and string controls.
 formBuildTabControl =
 formBuildDesign.addControl(FormControlType::Tab, "Overview");

formBuildTabPageControl =
 formBuildTabControl.addControl(FormControlType::TabPage, "Overview");
 formBuildTabPageControl.caption("Overview");

formBuildTabPageControl2 =
 formBuildTabControl.addControl(FormControlType::TabPage,"Details");
 formBuildTabPageControl2.caption("Details");

formBuildGridControl =
 formBuildTabPageControl.addControl(FormControlType::Grid,"Table Grid");
 formBuildStringControl =
 formBuildTabPageControl2.addControl(FormControlType::String,"Table String");
 formBuildStringControl2 =
 formBuildTabPageControl2.addControl(FormControlType::String,"Table String");

// Add data fields to controls.
formBuildGridControl.addDataField
(formBuildDataSource.id(),dictTable.fieldName2Id("AccountNum"));
formBuildGridControl.addDataField
(formBuildDataSource.id(),dictTable.fieldName2Id("Phone"));
formBuildGridControl.addDataField
(formBuildDataSource.id(),dictTable.fieldName2Id("Name"));
formBuildGridControl.addDataField
(formBuildDataSource.id(),dictTable.fieldName2Id("Address"));
formBuildStringControl.dataSource(formBuildDataSource.id());
formBuildStringControl.dataField(2);
formBuildStringControl2.dataSource(formBuildDataSource.id());
formBuildStringControl2.dataField(3);

    args = new Args();
    args.object(form);

    // Create the run-time form.
    formRun = classfactory.formRunClass(args);

    formRun.run();
    formRun.detach();

}