search

ycphs / openxlsx

openxlsx - a fast way to read and write complex xslx files
https://ycphs.github.io/openxlsx/
Other
220 stars 73 forks source link

read.xlsx can not read numbers-stored-as-text #427

Closed kirklucy closed 2 months ago

kirklucy commented 1 year ago

the excel file is storing numbers-stored-as-text, when I use read.xlsx it reads the numbers as a character "xml:space=\"preserve\">37.4". the number displayed in excel is 37.4

This is a issue only for openxlsx, other packages are able to read these number

github-actions[bot] commented 2 months ago

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

github-actions[bot] commented 2 months ago

This issue was closed because it has been stalled for 7 days with no activity.