You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
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
The text was updated successfully, but these errors were encountered:
When reading
xlsx
, there are large numbers in thexlsx
file. They are read into thexlsx
file as text and recognized as scientific counting strings. How can they be displayed asnumeric strings
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)
The text was updated successfully, but these errors were encountered: