转换大数字不准确。
使用 XLSX.sheet_to_json() 将此文件转换后,结果数据的部分内容如下: "B50": { "t": "n", "v": 23000000, "w": "23000000" }, "C50": { "t": "n", "v": 32199999.999999996, "w": "32200000" }, "D50": { "t": "n", "v": 48299999.99999999, "w": "48300000" }, "E50": { "t": "n", "v": 77199999.99999999, "w": "77200000" }, "F50": { "t": "n", "v": 153999999.99999997, "w": "154000000" }, "G50": { "t": "n", "v": 337999999.99999994, "w": "338000000" }, "H50": { "t": "n", "v": 810999999.9999999, "w": "811000000" }, "J50": { "t": "n", "v": 2099999999.9999998, "w": "2100000000" }, "K50": { "t": "n", "v": 5879999999.999999, "w": "5880000000" }, "L50": { "t": "n", "v": 18799999999.999996, "w": "18799999999" } 由于数字转换不准确,我通常使用"w"属性来获得准确的结果,但"K50"单元格的"w"属性也不准确(原始值为 18800000000)。
内容来源: SheetJS/sheetjs