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.aspxThank you very much for your help.
Regards