Paste the data from datatable

Aspose.Cells Product Family
1

Hi Team,

Can you please send me the code which copies the datatable data to excel sheet.

Regards,
Bharat.v

2

Hi,

Thanks for your posting and using Aspose.Cells for .NET

Please download and use the latest version:
Aspose.Cells
for .NET v7.2.2.1


Yes, you can copy the datatable data to excel sheet.

Please see the following article for your complete reference.
Importing Data to Worksheets

Please see the following code.

C#


//Instantiating a “Products” DataTable object

DataTable dataTable = new DataTable(“Products”);


//Adding columns to the DataTable object

dataTable.Columns.Add(“Product ID”, typeof(Int32));

dataTable.Columns.Add(“Product Name”, typeof(string));

dataTable.Columns.Add(“Units In Stock”, typeof(Int32));


//Creating an empty row in the DataTable object

DataRow dr = dataTable.NewRow();


//Adding data to the row

dr[0] = 1;

dr[1] = “Aniseed Syrup”;

dr[2] = 15;


//Adding filled row to the DataTable object

dataTable.Rows.Add(dr);


//Creating another empty row in the DataTable object

dr = dataTable.NewRow();


//Adding data to the row

dr[0] = 2;

dr[1] = “Boston Crab Meat”;

dr[2] = 123;



//Adding filled row to the DataTable object

dataTable.Rows.Add(dr);


//Importing the contents of DataTable to the worksheet starting from “A1” cell,

//where true specifies that the column names of the DataTable would be added to

//the worksheet as a header row

worksheet.Cells.ImportDataTable(dataTable, true, “A1”);