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:
aspose ok when using:
both are equivalent in excel
attached an image of the error message plus an excel file