Headers

[ejpvi]

I have posted this question before...

But I want to word it differently.

When exporting from Filemaker to Excel format, is there anyway to provide custom column header information?

Right now, it will export the column header as the field name, or the table Occurrence::field name.

If I am trying to design a very specific excel report, is there a way to denote my own columns headers through scripting?

[JesseSFR]

Nope. There are fowl hacks that would work.... Such as creating a dummy record that has the headers of the fields in it and sorting that to the top of the found set you wish to export.

[Vaughan]

This could be done with a custom xml export and an xlst (xslt?) style sheet thingy to wrangle the data into the right shape.

The resulting Excel file would only be compatible with versions that support the xml format.

[JesseSFR]

I figured out how to get ride of the straggler field. So I deleted my previous post. Here is what you need to do:

1. Edit my file and rename Col1,col2 to a list of column names that are separated by columns.

2. Export records as xsl and apply this style sheet.

You will get a csv with the names of the columns as you specified. Voila...

Great Idea Vaughan

test.xsl.zip