Free Support Forum - aspose.com

How to change the initial cell position

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

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

Please check http://www.aspose.com/Products/Aspose.Cells/Api/Aspose.Cells.Cells.ExportDataTable.html and

http://www.aspose.com/Products/Aspose.Cells/Api/Aspose.Cells.Cells.ExportDataTableAsString.html.

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