Free Support Forum - aspose.com

Read actual cell values and not display values


hi,

please let me know how to read actual values from cell (which is visible after clicking on cell)and not displayed value. let me know the settings for the same for xls and also for csv files.

Hi,

I think you may use Cell.getStringValue()/getValue() method(s).

Thank you.

No getStringValue/getValue won’t work. Both gives value as displayed and not actual value.

Hi,

Please attached your template file and paste your sample code to show the issue, we will check it soon.

Thank you.