We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

Export Excel

Answered

Hi,

  1. I have using json data display the value is good. But export to excel file decimal value in wrong. Displaying browser and excel value so different.
  2. How to change excel file name as default pivot.xlx

 
 

1 answer

WebDataRocks Team WebDataRocks May 1, 2020

Hello,
 
Thank you for contacting us.
 
Concerning the difference in the display within the browser and in Excel, our team would like to kindly explain that it can be due to the fact that Excel supports fewer decimal places than Flexmonster.
Therefore, the value will be rounded to fit the limit of seven decimals.
 
In case you are facing a different problem, our team would like to kindly ask you to provide some additional information about the issue or prepare a sample where it is reproducible.
 
As for changing the name of the exported file, the custom name can be specified as a value of the filename property which is contained in a parameter of the exportTo API call.
You are welcome to check out the page from our documentation dedicated to the exportTo method.
 
We hope it helps.
You are welcome to contact us in case of additional questions.
 
Regards,
WebDataRocks Team