Problem with reading non-en-US numbers from HTML file #3227

New Issue

angelomaria · 2024-09-24T15:08:45Z

angelomaria commented

2024-09-24 15:08:45 +00:00

If I try to read numbers that end in 0, the library deletes all the “0” at the end of the number.
For example if I have 10,000 in the excel file, it reads 10, if I have 23,980 instead it reads 23,98

If I try to read numbers that end in 0, the library deletes all the “0” at the end of the number. For example if I have 10,000 in the excel file, it reads 10, if I have 23,980 instead it reads 23,98

sheetjs commented

2024-09-24 19:37:44 +00:00

Can you share a sample file?

Under the hood, SheetJS uses en-US locale settings: , is the thousands separator and . is the decimal point. If you are in a locale that uses different settings, the plaintext parsers may misinterpret values.

Can you share a sample file? Under the hood, SheetJS uses en-US locale settings: `,` is the thousands separator and `.` is the decimal point. If you are in a locale that uses different settings, the plaintext parsers may misinterpret values.

angelomaria commented

2024-09-25 07:41:16 +00:00

Hello,
this is the example of excel file that is generated by other management software I have.

Greetings,

Hello, this is the example of excel file that is generated by other management software I have. Greetings,

schema_civilistico_openapi_spa (1).xls

237 KiB

sheetjs commented

2024-10-05 16:08:39 +00:00

Thanks for sharing!

Your "XLS" file is really a HTML table. The TD elements are parsed using JS built-in features, which assume en-US interpretation. For example:

<td  class="olo-tot olo-tot_11975958 olo-border-right-3"  >10.000</td>

This is probably the value 10000 (1.0e+4).

If you have control over the HTML generation, use the data- overrides to specify the true value and the desired number format.

The general problem is tracked in issue #3180

Thanks for sharing! Your "XLS" file is really a HTML table. The TD elements are parsed using JS built-in features, which assume en-US interpretation. For example: ```html <td class="olo-tot olo-tot_11975958 olo-border-right-3" >10.000</td> ``` This is probably the value `10000` (`1.0e+4`). If you have control over the HTML generation, [use the `data-` overrides](https://docs.sheetjs.com/docs/api/utilities/html#value-override) to specify the true value and the desired number format. The general problem is tracked in issue #3180

sheetjs closed this issue

2024-10-05 16:08:40 +00:00

sheetjs changed title from ~~Problem with reading numbers from excel file~~ to Problem with reading non-en-US numbers from HTML file

2024-10-05 16:09:05 +00:00

Sign in to join this conversation.