Aspose.Cells是一款完全采用API来操作Excel文件的.NET、Java控件,通过该控件开发人员可以创建、编辑、转换Excel文件,可以实现几乎所有Excel软件可以实现的功能,当使用Excel电子数据表格时更多的时候是数据上的操作,
Aspose.Cells不仅可以帮助开发人员导出数据到数据库,还可以从数据表导入数据到工作表里,下面的代码讲述了如何为工作表中的某一行导入多个数据表,具体如下:
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets["sheet1"];
DataTable table1 = new DataTable();
DataRow table1Row = table1.NewRow();
table1.Columns.Add();
table1.Columns.Add();
table1.Columns.Add();
table1Row[0] = "Test";
table1Row[1] = "Test";
table1Row[2] = "Test";
table1.Rows.Add(table1Row);
table1Row = table1.NewRow();
table1Row[0] = "Test";
table1Row[1] = "Test";
table1Row[2] = "Test";
table1.Rows.Add(table1Row);
table1Row = table1.NewRow();
table1Row[0] = "Test";
table1Row[1] = "Test";
table1Row[2] = "Test";
table1.Rows.Add(table1Row);
DataTable table2 = new DataTable();
DataRow table2Row = table2.NewRow();
table2.Columns.Add();
table2.Columns.Add();
table2.Columns.Add();
table2Row[0] = "Test";
table2Row[1] = "Test";
table2Row[2] = "Test";
table2.Rows.Add(table2Row);
table2Row = table2.NewRow();
table2Row[0] = "Test";
table2Row[1] = "Test";
table2Row[2] = "Test";
table2.Rows.Add(table2Row);
table2Row = table2.NewRow();
table2Row[0] = "Test";
table2Row[1] = "Test";
table2Row[2] = "Test";
table2.Rows.Add(table2Row);
worksheet.Cells.ImportDataTable(table1, false, 0, 0);
worksheet.Cells.ImportDataTable(table2, false, 0, 5, false);
workbook.Save("D:/test.xls");