How to save formats

posted on November 20th, 2019

Answered

chen asked November 20, 2019

hello，In the process of using, I want to solve the following problems：

Can I customize the font size of Excel file when exporting excel file
Can I save the current report format?If so, how can I continue to use the current format when I click the query and other buttons?
When opening a local JSON file, how to get the JSON string in the file?

Looking forward to your help！

WebDataRocks Team ⋅ WebDataRocks ⋅ November 21, 2019

Hello, Chen,

Thank you for reaching out to us.

Font size can be adjusted using CSS. Check out the following code:
```
#wdr-pivot-view .wdr-grid-layout .wdr-cell {
    font-size: 15px;
}
```
Also we prepared an example for you.

Font size, as well as other styles on the table, will be applied to your excel file.
The current report can be saved using the Save button. The JSON file with the report will be downloaded. To set the downloaded report, you can copy the content of the file to the report object of your component or specify the path to the file containing a report.
You can find more about setting the report from the file by the link: saving and opening reports.
Opening the local JSON file will load it into the component automatically. Also, it is possible to store your data directly on your page as a variable.
Find an example of getting the data set from the variable here.

We hope it helps.

Best Regards,
WebDataRocks Team