Free Support Forum -

How to change the initial cell position


I'm new to aspose and was wondering, When I export a spreadsheet (I only have a Excel licence) it positions the dataset not in the first cell of the spreadsheet How can I control this?


If you want to export data from a spreadsheet, you can use ExportDataTable or ExportDataTableAsString method.

Please check and

The first two parameters specified the start cell position.

For example, if you want to export data from B2 and you want to export 10 rows and 10 columns of data:

DataTable dt = cells.ExportDataTable(1,1, 10, 10);