Cannot open a File

[Luis Horacio Botero]

When I tied to open de file c:\\Plantilla.xls I receive a Exception ArgumentException that say Index out of bounds.

Please I need resolve this problem

This is my code


ExcelEngine excelEngine = new ExcelEngine();
IWorkbook workbook = excelEngine.Excel.Workbooks.Open("c:\\Plantilla.xls");


I used this dll

syncfusion.compression.base.dll vr 6, 402, 0, 15
syncfusion.core.dll vr 6, 402, 0, 15
syncfusion.xlsio.base.dll vr 6, 402, 0, 15





Plantilla_7b84f71e.xls

[Geetha M]

Hi Luis,

I am afraid that I am not able to reproduce the problem with v7.3.0.20. Could you please consider upgrading to this version? You can get the download details from the forum thread linked below.

http://www.syncfusion.com/support/forums/general/88088/

Please try this and let me know if you have any questions.

Regards,
Geetha

[Luis Horacio Botero]

This is not a solution beacuse I dont have this version. I resolve my problem with de vr 6.4 putting this line in the code

IWorkbook workbook = excelEngine.Excel.Workbooks.Open(sRutaPlantilla, ExcelParseOptions.DoNotParseCharts);

[Bill Campbell]

Unfortunately I am having the same problem, however, adding "ExcelParseOptions.DoNotParseCharts" did not solve my problem:

I am trying to open an excel document using the following code and the last line is throwing an ArgumentOutOfRangeException:

string templatePath = @"c:\Templates\WBN property summary.xltx";
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;

IWorkbook workbook = application.Workbooks.Open(templatePath, ExcelOpenType.Automatic);

I have also tried the following with is throwing an ArgumentNullException:


string templatePath = @"c:\Templates\WBN property summary.xltx";
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;

IWorkbook workbook = application.Workbooks.Open(templatePath);

[Vijesh Narayanan]

Hi Luis,

Thank you for using Essential XlsIO.

I was unable to reproduce the issue on my side, So for analyzing this issue more closely, I would really appreciate if I could get a sample Excel template from you, generating the issue.

Still, I will strongly recommend you to upgrade to the latest version of Essential XlsIO, as lot of issues that existed in previous versions of Essential XlsIO has now been fixed.

You can get the download details from the forum thread linked below.

http://www.syncfusion.com/support/forums/general/88088/


Thank you for your patience.

Regards,
Vijesh

[David Culliton]

This issue does still exist in the current version of xlsio. I believe it is a function of how the spreadsheet was created. Not knowing how your spreadsheet was created, I can recreate this issue all day if I create an excel file from Monarch using its v3 engine. If I change to its v8 or 9 engine, the issue goes away.


A solution to handle all generated files would be nice. If you want the 2 spreadsheets - let me know where to send them.

[David Culliton]

My other comment is that if I open and resave the version 3 spreadsheet, it opens in xlsio without an issue.

[Geetha M]

Hi David,

Thank you for the details.

Could you please mail us the spreadsheets to [e-mail] with forum id as subject so that we can check and get back to you?

Regards,
Geetha