[转]WalkScript中对excel文件的操作

alert

在WalkISurvey中，菜单【工具】->【walkscriptor】，打开walkscript脚本编辑器，可以使用对excel文件（excel2003及以前的版本）操作的文件对象。

1. double PI = 3.14159265;
   
2. 
   
3. void main()
   
4. {
   
5. string xls = "F:\\example.xls";
   
6. wkFile file;
   
7. file.excelOpen(xls);
   
8. if (file.handle()==0)
   
9. {
   
10. message("cannot read " + xls);
    
11. return;
    
12. }
    
13. 
    
14. string val;
    
15. //读取第一个表格的第2行第1列单元格的值
    
16. file.excelGetCell(val, 1, 0);
    
17. trace("%s\n", val);
    
18. //读取第一个表格的第4行第1列单元格的值
    
19. file.excelGetCell(val, 3, 0);
    
20. trace("%s\n", val);
    
21. //读取第一个表格的第5行第1列单元格的值
    
22. file.excelGetCell(val, 4, 0);
    
23. trace("%s\n", val);
    
24. //读取第一个表格的第5行第2列单元格的值
    
25. file.excelGetCell(val, 4, 1);
    
26. trace("%s\n", val);
    
27. for (int i = 0; i < 41; ++i)
    
28. {
    
29. file.excelGetCell(val, 8, i);
    
30. trace("%s\t", val);
    
31. }
    
32. trace("\n");
    
33. 
    
34. string newVal = "哈哈哈myNewstringVal";
    
35. file.excelSetCell(newVal, 8, 0);
    
36. file.excelSetCell(9999, 8, 6);
    
37. 
    
38. file.excelSetCell(12.34567890,9,0);
    
39. //Set format string "0.00"
    
40. file.excelSetCellFormatString(9, 0, "0.00");
    
41. 
    
42. //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);
    
43. file.excelSetCell(456.0, 10, 1);
    
44. //set cell font
    
45. file.excelSetCellFont(10,1,"黑体", 0, 300, 400);
    
46. 
    
47. file.excelSetCell("Text", 11, 2);
    
48. //set cell rotation
    
49. file.excelSetCellInfo(11, 2, 2, 45);
    
50. 
    
51. file.excelSetCell(987.654321, 12, 3);
    
52. //set cell alignment: EXCEL_HALIGN_SEL_CENTRED
    
53. file.excelSetCellInfo(12, 3, 1, 0x06);
    
54. 
    
55. file.excelSetCell("沃，3G", 13, 4);
    
56. //set cell font: option - EXCEL_FONT_SHADOWED; fontheight - 500; fontweight - EXCEL_FW_THIN;
    
57. // fontescapement - EXCEL_ESCAPEMENT_SUBSCRIPT; fontunderlinetype - EXCEL_UNDERLINE_DOUBLE_ACCOUNTING
    
58. // fontColorIndex - EGA_BLUE = 4
    
59. file.excelSetCellFont(13,4,"宋体", 0x20, 500, 100, 2, 0x22, 4);
    
60. //set cell rotation
    
61. file.excelSetCellInfo(13,4,2, 120);
    
62. 
    
63. file.excelSetCell(time(), 14,5);
    
64. file.excelSetCellFont(14,5,"Arial", 1, 200, 900,0,0,2);
    
65. file.excelSetCellFormatString(14,5,"M/D/YY");
    
66. 
    
67. file.excelSetCell(100*(PI%0.001), 15, 6);
    
68. file.excelSetCellFormatString(15,6,"%0");
    
69. 
    
70. xls = "F:\\a1.xls";
    
71. file.excelSaveAs(xls);
    
72. file.excelClose();
    
73. 
    
74. wkView view;
    
75. view.shell(xls);
    
76. }

复制代码

alert

这个是转载的 感觉不错 分享一下！

walkinfo

多谢提供！！！！

fueme

感谢楼主分享