How to change the initial cell position

Aspose.Cells Product Family
1

Hi

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?

Thanks

2

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

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);