I’m trying to test how long it takes Aspose.Excel to import a record set of this dimension: 464 rows and 41 columns ( 19024 records in total). But when I try to set the max number of rows and columns of the data table to be 1000, I get an “out of range” error. This is the line of code I used: Excel1.Worksheets.Cells.ImportDataTable(_dataTable, true, 0, 0,1000,1000, true); Even when I changed the numbers to be 100 columns and 500 rows, it doesn’t work.
Did you set an upper limit for the number of rows and columns allowed for a datable import? We really need this method to be able to handle huge datasets. Can you please give me feedback ASAP on this issue? Thank you.
Here’s the error I got:
Server Error in ‘/ExcelTest’ Application.
Specified argument was out of the range of valid values. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Source File: c:\inetpub\wwwroot\exceltest\code\aspose_excel.cs Line: 43