Decimal points in excel export


How to reduce decimal points into two in excel exported file?

1 answer

WebDataRocks Team WebDataRocks May 11, 2020

Thank you for reaching out to us.
Reducing the number of decimal places is achievable through number formatting.
Adjusting the desired number of decimal places within the component affects the exported file. Therefore, in case the number of decimal places is limited with 2, the exported file will contain values with the same limitation.
The formatting itself can be configured using the format object. We recommend checking out our documentation dedicated to the mentioned object and its properties, including the decimalPlaces property.
It defines the number of decimals to appear after decimal separator in the fractional part of the number. The default value is -1, it means the number will not be changed and it will be shown in its original form.
Please check out an example we have prepared for you.
We hope it helps.
Do not hesitate to contact us in case additional questions occur.
Best regards,
WebDataRocks Team