Is it possible to apply styles to cells using Excel Exporter?

0
Hi everyone,I'm using the Excel Exporter module from the Marketplace to generate spreadsheets in my app, and it's working fine for exporting data. But now, in the project I'm working on, the client asked for the exported Excel file to match a specific visual layout they already use, with colored columns, cell borders, bold titles, and similar formatting. I looked through the Excel Exporter options, but I couldn't find anything related to styling or formatting. So far, I'm only able to export raw data without any visual customization. Does anyone know if it's possible to apply this kind of formatting with Excel Exporter? Thanks!
asked
2 answers
2

Hey Luciano,

It's possible to customize the excel template using the style area on the template configuration page: Style.png

 

However, it doesn't provide a wide variety of options for styling the file.

Another option would be to use a template file that already has all the styles applied.

 

If possible, you can also use the "Advanced Excel" module, which gives you greater customization freedom than the Excel Exporter.

In this module, you can customize the style of each cell individually.

 

Best Regards,

Ricardo Pereira

answered
1

Hey Luciano,

You need to create .xlsm (you can write script to changed styling) file need to have same structure as your file that will be export after you create your .xlsm file just add it here (to your template).

image.png

answered