search

DiegoZoracKy / convert-excel-to-json

Convert Excel to JSON, mapping sheet columns to object keys.
MIT License
287 stars 91 forks source link

how to modify excel column data i want to apply toFixed function in particular excel column whole data while converting it to in JSON #31

Open priyanka-modanwal opened 5 years ago

priyanka-modanwal commented 5 years ago

{ "Pricing_Segment_1_Voice_ONNET": [ { "undefined": 1, "[25 - 50[": 1.6, "[50 - 100[": 1.4400000000000002, "[100 - 200[": 1.2960000000000003, "[200 - 300[": 1.1664000000000003, "[300 - 400[": 1.0497600000000002, "[400 - 500[": 0.9447840000000003, "[500 - 1000[": 0.8503056000000003, "[1000 - 1500[": 0.7652750400000004, "[1500 - 2000[": 0.6887475360000004, "[2000 - 2500[": 0.6198727824000003, "[2500 - 3000[": 0.5578855041600003, "[3000 - 3500[": 0.5020969537440002, "[3500 - +00[": 0.4518872583696002 } ] }

DiegoZoracKy commented 5 years ago

We have this feature request here which is exactly about that:

https://github.com/DiegoZoracKy/convert-excel-to-json/issues/4

But currently there's not a way to do that during the conversion process.

I suggest you to use .map() on the result in order to do that.