Converting Excel Data to DataTables and DataSets

Hello,

I was wondering if you could tell me does aspose cells have the ability to control how the data is stored in memory such as if I wanted to take the information from an excel sheet and store it as either a dataset or a datatable?

Thanks

Hi,


Thanks for your query.

Yes, Aspose.Cells provides some exporting data options where you can export data (from worksheets) to DataTable and arrays etc., see the document for your complete reference:
http://www.aspose.com/docs/display/cellsnet/Exporting+Data+from+Worksheets


Great Thank you for your help. After looking at the documentation I can see I can export to data tables but can I also export to data sets? I can not find anywhere in your documentation if thats possible. I appreciate all of your help!

Hi,


Well, DataSet is just a container rather a cover type object that contains DataTables in it, so it won’t be very difficult (you may use your own .NET code to create DataSet(s) and then add tables to it. And, Aspose.Cells does not have any method to directly export to DataSet object, it has overloaded methods to export to DataTable only.

Thank you.