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

Free Support Forum - aspose.com

Excel 2016-2019 have embedded history. How to ensure reading only current data?

I have been using apache POI to read Excel 2012 workbooks. I upgraded to Excel 2019, and POI now reads old data values - values that cannot even be found by searching the whole workbook. My inference is that POI is finding XML tags inside the historical data, not just the current(latest) value for the cell.
My question is, does Aspose.cells give me control over that? Please be as specific as possible.
Thanks!
Jon

@jonfarmer,

Thanks for your query.

Yes, Aspose.Cells can read the current (latest) or calculated values in the worksheet cells. See the documents for your reference:
https://docs.aspose.com/display/cellsjava/Add+and+Retrieve+Data#AddandRetrieveData-RetrievingDatafromCells
https://docs.aspose.com/display/cellsjava/Ways+to+Calculate+Formulas

Are those values based on some formulas or other elements/objects? Please try using the ways (to retrieve data) mentioned (with examples) in the above documents/articles? If you still find any issue, kindly do elaborate by providing a sample Excel file, sample code and some screenshots to demonstrate the problem, we will check it soon.