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

Aspose.Cells Product Family
1

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

2

Hi alon,

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

Thanks,

3

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);

4

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.