How to read a xlsx file like a SQL dataset

Aspose.Cells Product Family
1

I need to read and loop through a xlsx file like it was a data set returned from a SQL equerry, or , be able to put the xlsx file into a Table in my database so I can loop through it.

2

Hi,

Thanks for your posting and using Aspose.Cells.

Yes, you can export your data into data table from your excel file. Please see the following article that explains how to export data from your worksheets into data table, arrays etc.

( Export Data from Worksheet in .NET|Documentation )