We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Error opening excel containig INDEX function with a Table as an array

when using INDEX function with a Table as the array, by default excel searches in "#data", Aspose expects "#data" to be specified.

aspose error when using:

=INDEX(table_a[],

aspose ok when using:

=INDEX(table_a[#data],

both are equivalent in excel

attached an image of the error message plus an excel file

Hi alon,

Please share the code snippet with us which you are using, in order to analyze the issue.

Thanks,

Hi,


Simply try to open the file using aspose and you will get the exception.

try this:

MemoryStream ms = new MemoryStream(File.ReadAllBytes(sFilePath));

Workbook workbook = new Workbook();

workbook.Open(ms, FileFormatType.Excel2007Xlsx);

Hi,

Please try the attached latest version v5.1.4.3. I have used the following code with your file, it works fine.

MemoryStream ms = new MemoryStream(File.ReadAllBytes(“e:\test\EX+EXCEL.xlsx”));

Workbook workbook = new Workbook(ms);


Thank you.