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");