Remove formatting from excel file.

Answered
Rafael Bernardes asked on May 31, 2019


Dear, how do I leave the export file without any type of formatting? The reason is the file size.

3 answers

Public
Vera Didenko Vera Didenko Flexmonster June 3, 2019

Hello, Rafael,
 
Thank you for your question.
 
May we suggest the following solution:
 
When exporting to CSV the formats will not be included in the export.
The CSV format can easily be viewed in Excel and saved as xls or xlsx file.
 
Please let us know if such a solution works for you.
 
We are looking forward to hearing from you.
 
Best Regards,
Vera

Public
Rafael Bernardes June 3, 2019

Hello, in my view this is not a solution. Is there any way to set up for excel to be exported without any formatting?

Public
Vera Didenko Vera Didenko Flexmonster June 4, 2019

Hello, Rafael,
 
Thank you for your response.
 
Exporting to Excel without any formatting is not on our roadmap at the moment and we are not sure omitting formats will remarkably decrease the file size.
 
Our team kindly suggests the following workaround:
 
1) Get a plain CSV (formatting will not be included) in the callback function:

flexmonster.exportTo('csv', {filename : 'flexmonster.csv'},
function(result) {console.log(result.data)}
);

For more details please refer to docs: https://www.flexmonster.com/api/exportto/
 
2) Convert the CSV to an Excel file if necessary.
 
This can be done on the client side (for example, by the help of SimpleExcel.js) as well as on the server.
 
Feel free to contact us in case any questions arise.
 
Best Regards,
Vera

Please login or Register to Submit Answer