导出参考博客

导出参考博客2

前言

当需要导出指定的数据到Excel中的需求时可以自己开发一个，当然也可以使用系统的导入导出框架，但是缺陷是系统的导入导出框架只可以导出指定的Entity中的数据，灵活性不够

---

一、创建一个Exprot Class

//根据不同情况下进行判断，如果是Excel文件已经存在就打开
//如果不存在则创建
static void Job25(Args _args)
{
    SysExcelApplication     application;
    SysExcelWorkbooks       workbooks;
    SysExcelWorkbook        workbook;
    SysExcelWorksheets      worksheets;
    SysExcelWorksheet       worksheet;
    SysExcelCells           cells;
    int                     row =4;
    FileName                filename;
    CustTable               custtable;
    ;
    
    filename = 'C:\\Temp\\TestExcel001.xlsx';
    //initialize 
    application = SysExcelApplication::construct();
    //is display alerts info
    application.displayAlerts(false);
    workbooks = application.workbooks();
    if(WinApi::fileExists(fileName))
    {
        workbooks.open(filename);
    }
    else
    {
        workbooks.add();
    }
    workbook = workbooks.item(1);
    worksheets = workbook.worksheets();
    worksheet = worksheets.itemFromNum(1);
    cells = worksheet.cells();
    //add cell value
    cells.item(4,1).value('test1');
    cells.item(4,2).value('test2');
    cells.item(4,3).value('test3');
    
    //for add vcalue
    while select custtable
    {
        if(row >= 100)
        {
            break;
        }
        else
        {
            row++;
            cells.item(row,1).value(custtable.AccountNum);
            cells.item(row,2).value(custtable.dataAreaId);
            cells.item(row,3).value(custtable.AccountStatement);
            
        }
    }
    
    //save file
    workbook.saveAs(filename);
    // close file
    application.quit();
    info('inport succeed');
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61

二、创建一个Batch