Excel Exporter Customizations

0
Is there a way to customize the way the exported Excel file looks? Specifically, I'd like to highlight the row with the column names and highlight the cells with the aggregate values. I am using the Excel Exporter module in Mendix 10.6.3.
asked
1 answers
0

Trisha,

You can create formats for cells in Excel Exporter - this would work for the column names.  To do this, create a style with the background and highlighting you want in your template here:

image.png

 

Then on each sheet, select that Style for the header row:

image.png

 

You can also use styles on Aggregate columns, which may help you format the totals in your spreadsheet:

image.png

Hope that helps,

Mike

answered