使用aspose.cells創(chuàng)建和讀取excel文件，供大家參考，具體內(nèi)容如下
1. 創(chuàng)建excel
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
aspose.cells.license li = new aspose.cells.license(); li.setlicense("aspose.cells.lic"); aspose.cells.workbook wk = new aspose.cells.workbook(); worksheet ws = wk.worksheets[0]; for (int i = 0; i < 9; i++) { for (int j = 0; j < 9; j++) { ws.cells.rows[i][j].value = (i + 1) + "*" + (j + 1) + "=" + (i + 1) * (j + 1); } } wk.save("d:\\zzz\\d.xls"); console.writeline("ok"); console.readkey();產(chǎn)生的excel文件: |
2.讀取excel
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
datatable dt = new datatable(); aspose.cells.license li = new aspose.cells.license(); li.setlicense("aspose.cells.lic"); aspose.cells.workbook wk = new aspose.cells.workbook("d:\\zzz\\d.xls"); worksheet ws = wk.worksheets[0]; dt = ws.cells.exportdatatable(0, 0, 9, 9); for (int k = 0; k < dt.rows.count; k++) { for (int h = 0; h < dt.columns.count; h++) { console.write(dt.rows[k][h].tostring() + " "); } console.writeline(); } console.writeline("ok"); console.readkey(); |
運行讀取的結(jié)果：
以上就是本文的全部內(nèi)容，希望對大家的學(xué)習(xí)有所幫助，也希望大家多多支持服務(wù)器之家。
原文鏈接：https://www.cnblogs.com/ChengWenHao/archive/2018/10/19/AsposeCellsExcel.html
