dhatim / fastexcel

Generate and read big Excel files quickly
Other
677 stars 122 forks source link

issue with read cell formatted #474

Open arfadrohru opened 3 weeks ago

arfadrohru commented 3 weeks ago

1 hallo, so i have xlsx file with cell value displayed 018481, but u can see real value is 18481 and fastexcel read 18481 not 018481 , how to get displayed value?

on poi i know we can get formatted value with DataFormatter formatter = new DataFormatter(); String cellValue = formatter.formatCellValue(cell);

2 i try to check fastexcel repo and i found that on Cell.java there was variabel with name dataFormatString (return null), can we use this? or any one can give me some reference for my case?