In this article, We learn how to conversion of data from Aspose.Cells.Worksheet to DataTable in C#. I will show how to do it, and just follow the steps clearly.

For more updates please do Subscribe via Email:

  • Conversion of data from excel where any location from different sources is you can use Aspose.Cells while using .Net technology.

Conversion any type of list of data into DataTable type is the easy ways.

// worksheet
Aspose.Cells.Worksheet worksheet = workbook.Worksheets[0];

// convertion of worksheet into datatable
System.Data.DataTable dataTable = worksheet.Cells.ExportDataTable(0, 0, worksheet.Cells.MaxDataRow + 1, worksheet.Cells.MaxDataColumn + 1, true);

Happy Learning..

Thank you for visiting my blog site. Hoping you learn more here. please feel free to comment and suggest if there is need to enhance and update. thank you.

Related Topics

Leave a Reply

Your email address will not be published. Required fields are marked *