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?
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:
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!
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.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.