ImportDataTable throws "Row index is out of range"

Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » ImportDataTable throws "Row index is out of range"

Last post 02-04-2009, 12:56 AM by nausherwan.aslam. 2 replies.


	Sort Posts: Previous Next

02-03-2009, 2:42 PM 163230

twh3375
Joined on 08-19-2008
Posts 4

ImportDataTable throws "Row index is out of range"

I'm using Aspose 4.1. I'm trying to make this call:

sheet.Cells.ImportDataTable(dt, true, 0, 0, 65536, 256, true, "m/d/yy", true);

where "dt" is a DataTable with 65536 rows. The fifth parameter, rowNumber, according to the documentation is the "Number of rows to be imported, no more than 65536."

When I call it, it throws the exception, "Row index is out of range". If I lower the value to 65535, same error. If I lower the value to 65534, same error. If I lower the value to 100, it works.

So, somewhere between 100 and 65534, it stops working. What is going on?

Filed under: 65536;DataTable;ImportDataTable;rowNumber

02-03-2009, 3:11 PM 163237 in reply to 163230

twh3375
Joined on 08-19-2008
Posts 4

Re: ImportDataTable throws "Row index is out of range"

FYI, 65333 works. But I want the max: 65336! Does this call have a known bug in it?

02-04-2009, 12:56 AM 163292 in reply to 163237

nausherwan.aslam
Joined on 09-14-2008
Posts 5,083

Re: ImportDataTable throws "Row index is out of range"

Attachment: Present (inaccessible)

Hi,

Thank you for considering Aspose.

Well, I have tested your issue and I am able to execute the following function fine with the latest fix of Aspose.Cells,

sheet.Cells.ImportDataTable(dataTable, true, 0, 0, 65535, 255, true, "m/d/yy", true);

Please try the attached latest version of Aspose.Cells, if you still face any problem, please share your template file and we will check it soon.

Thank You & Best Regards,

Nausherwan Aslam
Support Developer,
Aspose Sialkot Team
Contact Us