Answer the question
In order to leave comments, you need to log in
Spreadsheet for parsing xls trims leading zeros. How to solve the problem?
The Spreadsheet gem is used to parse xls files.
And when parsing, if the cell contains a set of numbers with a zero at the beginning,
for example "0753", then the gem pulls out the value as "753".
How to solve the problem?
Answer the question
In order to leave comments, you need to log in
' to help
put in the column before 0000001
' 0000001 will be read normally
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question