Can we able to read actual value instead of display value from excel.

Certified Senior Developer

Hi everyone,

I’m using to readexcelsheetpaging plugin to read the Excel sheet, one column having decimal values, the displayed value is rounded (around 2 decimal places), which differs from the actual raw value stored in the cell.
 

What I see:

  • Excel cell shows: 9.79
  • Underlying value in the cell: 9.7881336
  • readexcelsheetpaging returns: 9.79 (display)

Is there a way to read the actual value of a cell?

  Discussion posts and replies are publicly visible

Parents Reply Children