why the data in xlsx is Integer,but throuth the xlsx.parse,the data change into Float about node-xlsx HOT 5 CLOSED

@yourenA the data shown in the screenshot is not the same as the file. If you change the number format you can hide the decimal point. Here is an example:

The cell actually has the value 1.5 but i changed the format by hitting "decrease decimal" and now Excel shows "2" instead of "1.5". That's why we need to see the original workbook. Github lets you click and drag into the comment box to upload it.

from node-xlsx.

@mgcrea Please help me?

from node-xlsx.

@yourenA can you share the original XLSX or XLS file?

from node-xlsx.

My XLSX file like this . It has Integer and Float number.

@reviewher
T(℃) R(KΩ)
-40 3225
-39 3026
-38 2840
-37 2665
-36 2501
-35 2348
-34 2204
-33 2070
-32 1945
-31 1828
-30 1718
-29 1614
241 0.2615
242 0.2569
243 0.2524
244 0.2480
245 0.2437
246 0.2395
247 0.2354
248 0.2314
249 0.2275
250 0.2236

from node-xlsx.

@reviewher
HELPFUL !!!
This is my fault .
Thank you so much!

from node-xlsx.