Hi All ,
I am reaching out to address a critical issue that we are currently facing while utilizing the export method within your software library.
Our team has been using the export functionality to export sizable data sets, and we recently encountered a significant challenge when attempting to export a data set comprising 900,000 records. Unfortunately, during the export process we encountered an error that prevented the successful completion of the operation.
The error message we received is as follows :
Specified Path Does not Exists.
To help you better understand the situation, we have included some relevant details below:
Attaching Sample code screenshot:
-- Creating Record
-- Exporting (900,000 record) by using ultraGridExcelexport
-- getting Specified Path Does not Exists Error.
Thanks and Regards,
Susmitha
Hello Susmitha,
I have been investigating into the behavior you are seeing, but unfortunately, I cannot see your screenshots because they are too small and zooming in just makes them too blurry to read. I believe I can provide some information on why this error happens, though.
I have been doing some research on why this error can happen, and it appears that this can happen if you export to a .xls file and exceed the maximum row count of that file extension. The .xls file type supports a maximum of 65,536 rows, which your 900,000 rows vastly exceed. You need to export to a .xlsx file extension if you are not doing so already.
Please let me know if you have any other questions or concerns on this matter.
Hi All,
I am Exporting record into .xlsx file extension only using workbookFormat.Excel2007.
To help you better understand the situation, I have included some relevant details and I am Reattaching the screenshot in pdf format.
CreatingTestrecord.pdfExportMethod.pdfErrorMessage.pdf
Thanks and regards,