XlsIo Can''t Parse Formula

[Administrator]

Hi, I'm trying to open and read an Excel 2007 file (xlsm) to import it in a datatable, but the following code return the ArgumentExcpetion : Can't parse formula: Table2[Link to Order]

Here my code :


ExcelEngine excelEngine = new ExcelEngine();

IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2007;

IWorkbook workbook = application.Workbooks.Create();

workbook = application.Workbooks.Open(@"C:\myFile.xlsm", ExcelParseOptions.DoNotParseCharts);

...

The exception is thrown at this line.

The file is an Excel 2007 file with macro and using Structured References in formulas.

Is Structured References suported in XlsIo ?


Here a link to some information on structured references :
http://office.microsoft.com/en-us/excel/HA101556861033.aspx

Thank you very much for your help.

Regards

[Geetha M]

Hi Maxime,

Thank you for your interest in Syncfusion products.

Currently Essential XlsIO does not provide support to Structured References.

Regards,
Geetha