Filemaker is limited in the fact that it can not format the cells it exports in a .xls/.xlsx file. We have a need to format data automatically in an excel export.
We are building a virtual table list, rendering a report for X number of columns, then exporting that in a specific format. Each Row has an indicator as to type (IE "Header", "Summary", "date range", "Spacer"), and each row has consistent formatting across all columns. The only thing that changes is the number of "date range" rows, it could be one, could be 20, so the template would need to account for rowType when it runs. It would also need to trim off the serial number column, and the field name row.
Can someone show me how to take the attached .MER merge file from filemaker, and import the data to make it look like the attached .xls file.
Here is the sample merge file
and the sample output file