>>HI
>>
>>I'm using aspose.cells to export some data to excel.
>>
>>The site uses excel2003 so I need to cater for more than 65000 rows being in the datatable.
>>
>>The datatable is created by a stored procedure.
>>
>>Any thoughts on my best option.
>>
>>Is there any way I can access parts of the datatable ?
>>
>>the Import is statement is
>>
>> myWorksheet.Cells.ImportDataTable(dtData, True, "A1")
>
>You mean you want to be sure of not attempting to import more the 65K rows ?
>I've not used aspose but it looks as if there are overloads to ImportDataTable() that lets you specify the number of rows. e.g:
>
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/aspose.cells.cells.importdatatable_overload_8.htmlThanks Viv
how come you seem to see theses things and I don't :-)