XlsIo Can''t Parse Formula

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

Hi Maxime,

Thank you for your interest in Syncfusion products.

Currently Essential XlsIO does not provide support to Structured References.

Regards,
Geetha