在WalkISurvey中,菜单【工具】->【walkscriptor】,打开walkscript脚本编辑器,可以使用对excel文件(excel2003及以前的版本)操作的文件对象。- double PI = 3.14159265;
- void main()
- {
- string xls = "F:\\example.xls";
- wkFile file;
- file.excelOpen(xls);
- if (file.handle()==0)
- {
- message("cannot read " + xls);
- return;
- }
- string val;
- //读取第一个表格的第2行第1列单元格的值
- file.excelGetCell(val, 1, 0);
- trace("%s\n", val);
- //读取第一个表格的第4行第1列单元格的值
- file.excelGetCell(val, 3, 0);
- trace("%s\n", val);
- //读取第一个表格的第5行第1列单元格的值
- file.excelGetCell(val, 4, 0);
- trace("%s\n", val);
- //读取第一个表格的第5行第2列单元格的值
- file.excelGetCell(val, 4, 1);
- trace("%s\n", val);
- for (int i = 0; i < 41; ++i)
- {
- file.excelGetCell(val, 8, i);
- trace("%s\t", val);
- }
- trace("\n");
- string newVal = "哈哈哈myNewstringVal";
- file.excelSetCell(newVal, 8, 0);
- file.excelSetCell(9999, 8, 6);
- file.excelSetCell(12.34567890,9,0);
- //Set format string "0.00"
- file.excelSetCellFormatString(9, 0, "0.00");
- //execlSetCellFont(int row, int col, string fontName="Arial", int fontOption=0, int fontHeight=200, int FontWeight=400, int FontEscapementType=0, int FontUnderlineType=0, int sheetIndex = 0);
- file.excelSetCell(456.0, 10, 1);
- //set cell font
- file.excelSetCellFont(10,1,"黑体", 0, 300, 400);
- file.excelSetCell("Text", 11, 2);
- //set cell rotation
- file.excelSetCellInfo(11, 2, 2, 45);
- file.excelSetCell(987.654321, 12, 3);
- //set cell alignment: EXCEL_HALIGN_SEL_CENTRED
- file.excelSetCellInfo(12, 3, 1, 0x06);
- file.excelSetCell("沃,3G", 13, 4);
- //set cell font: option - EXCEL_FONT_SHADOWED; fontheight - 500; fontweight - EXCEL_FW_THIN;
- // fontescapement - EXCEL_ESCAPEMENT_SUBSCRIPT; fontunderlinetype - EXCEL_UNDERLINE_DOUBLE_ACCOUNTING
- // fontColorIndex - EGA_BLUE = 4
- file.excelSetCellFont(13,4,"宋体", 0x20, 500, 100, 2, 0x22, 4);
- //set cell rotation
- file.excelSetCellInfo(13,4,2, 120);
- file.excelSetCell(time(), 14,5);
- file.excelSetCellFont(14,5,"Arial", 1, 200, 900,0,0,2);
- file.excelSetCellFormatString(14,5,"M/D/YY");
- file.excelSetCell(100*(PI%0.001), 15, 6);
- file.excelSetCellFormatString(15,6,"%0");
- xls = "F:\\a1.xls";
- file.excelSaveAs(xls);
- file.excelClose();
- wkView view;
- view.shell(xls);
- }
复制代码 |