Multiple tables on single sheet

Aspose.Cells Product Family
1

Hi,

I want to import data from my excel file, my sheet 0 in that excel file contains three tables but they dont have group names. Still I want to import my data in a DataSet in three tables in it like ds.Tables[0], ds.Tables[1] and ds.Tables[2]. Please tell me how can I achieve it using Aspose.Cells?

Thanks,

Saleem

2

Hi Saleem,


Please see the topics for various options on how to import/export data to/from variety of data sources for your reference:

Export data from Excel sheet:
http://www.aspose.com/docs/display/cellsnet/Exporting+Data+from+Worksheets


Import data to Excel sheet:
http://www.aspose.com/docs/display/cellsnet/Importing+Data+to+Worksheets

Thank you.