Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Scientific counting display issues #733

Open
zoushucai opened this issue Jun 9, 2023 · 0 comments
Open

Scientific counting display issues #733

zoushucai opened this issue Jun 9, 2023 · 0 comments

Comments

@zoushucai
Copy link

When reading xlsx, there are large numbers in the xlsx file. They are read into the xlsx file as text and recognized as scientific counting strings. How can they be displayed as numeric strings

library(readxl)
f2 ='my.xlsx'
df3 <- readxl::read_excel(f2, col_types = "text",range =cell_rows(1:10) )
df3$Profit
df3$ProfitAvailable

Results of operation, (Due to the large size of the file, it was not uploaded. I copied a small copy of the data from the large dataset and found no problem. Why is the problem with the large data)

> df3$Profit
[1] "本期利润"       "没有单位"       NA               "1.7292461089E8" NA               NA              
[7] "1.3258165203E8" NA               NA              
> df3$ProfitAvailable
[1] "期末可供分配利润" "没有单位"         NA                 "8.758692123E7"    NA                
[6] NA                 "-2.2999730509E8"  NA                 NA        
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant