转载自http://www.oschina.net/code/snippet_98126_9942
代码片段(2)
[代码] [C/C++]代码
01 | /* |
02 | ExcelEngine excel(QObject::tr("c:\\Test.xls")); //创建 |
03 | excel.Open(); //打开 |
04 | |
05 | int num = 0; |
06 | for (int i=1; i<=10; i++) |
07 | { |
08 | for (int j=1; j<=10; j++) |
09 | { |
10 | excel.SetCellData(i,j,++num); //修改指定单元数据 |
11 | } |
12 | } |
13 |
14 | QVarient data = excel.GetCellData(1,1); //访问指定单元格数据 |
15 | excel.GetCellData(2,2); |
16 | excel.GetCellData(3,3); |
17 | excel.Save(); //保存 |
18 | excel.Close(); |
19 | */ |
20 |
21 | //导入数据到tablewidget中 |
22 | /* |
23 | ExcelEngine excel(QObject::tr("c:\\Import.xls")); |
24 | excel.Open(); |
25 | excel.ReadDataToTable(ui->tableWidget); //导入到widget中 |
26 | excel.Close(); |
27 | */ |
28 |
29 | //把tablewidget中的数据导出到excel中 |
30 | /* |
31 | ExcelEngine excel(QObject::tr("c:\\Export.xls")); |
32 | excel.Open(); |
33 | excel.SaveDataFrTable(ui->tableWidget); //导出报表 |
34 | excel.Close(); |
35 | */ |