使用Aspose.Cells創建和讀取Excel文件,供大家參考,具體內容如下
1. 創建Excel
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();產生的Excel文件:
2.讀取Excel
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();
運行讀取的結果:
以上就是本文的全部內容,希望對大家的學習有所幫助,也希望大家多多支持VEVB武林網。
|
新聞熱點
疑難解答