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


1 Reply

GM Geetha M Syncfusion Team January 23, 2009 09:58 AM UTC

Hi Maxime,

Thank you for your interest in Syncfusion products.

Currently Essential XlsIO does not provide support to Structured References.

Regards,
Geetha


Loader.
Up arrow icon