How to Import excel data into data table from filepath using aspose.cells?

[Govindon]

I want to import excel data(from filepath) into data table using aspose.cells(only sheet 1 to get into datatable). Sheet should be imported from filepath.

Can you pls say how to do for this.

Thanks in advance.

[Amjad_Sahi]

Hi,

Thanks for your query.

Well, you may try Data exporting options provided by Aspose.Cells to export the data to a DataTable or Arrays (see the document for your reference:

https://docs.aspose.com/display/cellsnet/Export+Data+from+Worksheet). For example, you may try ExportDataTable() method to fill a DataTable. Aspose.Cells can help you to load your template file and do the manipulation in the template file and then exporting your desired data set (of the worksheet) to fill a data table or arrays.

See the sample code below for your reference:

e.g

Sample code:

DataTable dt = new DataTable();

Workbook wb = new Workbook(“e:\test2\Book1.xlsx”);

//Export all the data of the first worksheet to fill the datatable.

dt = wb.Worksheets[0].Cells.ExportDataTable(0, 0, wb.Worksheets[0].Cells.MaxDataRow + 1, wb.Worksheets[0].Cells.MaxDataColumn + 1);

…

Hope, this helps a bit.

Thank you.