Hi,
I am using XlsIo v10.103.0.44. I am trying to open Excel 2010 (.xlsx) file containing more than 65K rows and 6 sheets.
when I try to open using;
//Step 1 : Instantiate the spreadsheet creation engine.
ExcelEngine excelEngine = new ExcelEngine(); //Step 2 : Instantiate the excel application object. IApplication application = excelEngine.Excel; IWorkbook workbook = null;workbook = application.Workbooks.Open(
"myExcelFile.xlsx", ExcelOpenType.Automatic);//other code....
It throws Overflow exception at 'Workbooks.Open' as; "Value was either too large or too small for an Int32."
Kindly suggest to resolve the issue.
Can I not use XlsIO v10.1 for opening Excel 2010 (.xlsx) file?
Thanks in advance.
-Bijal
Hi Bijal,
Thank you for using Syncfusion products.
We regret for the inconvenience caused. Could you please send us a sample Excel(.xlsx) document which reproduces the above reported exception with XlsIO so that we are able to proceed further and we will provide a solution at the earliest for the same.
Please let me know if you require any further clarifications.
Regards,
Sridhar.S
Thanks Sridhar.
Attaching my excel template file (.xlsx), I am trying to open using syncfusion version 10.103.0.44.
any sample code, which is opening attached .xlsx file using C#.NET would be very helpful.
Thanks in advance.
-Bijal
Can some one respond to the query I've posted/
unable to open .xlsx file using syncfusion v10.103. attached xlsx template for reference.
Hi Bijal,
Thank you so much for the update.
We are able to reproduce the exception “stack over flow
exception while opening the excel file” with XlsIO. Please open a new
direct-trac incident with a simple issue reproducing excel file and stack trace of an error for further follow
up on this issue.
Direct-Trac Link:
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents
Please let me know if you require any further clarifications.
Thanks,
Sridhar.S
Could you kindly share sample code top open same .xlsx file thru C#.Net ?
Does Syncfusion v10.103 not supporting to work with .xlsx file?
Thanks
-Bijal