Column Headers When Saving as Excel

[datalink]

Our naming standards work very well for us as developers, however its a problem when records are saved as excel files via a script. The first row of data are field our field names, which are not operator friendly.

Does anyone have any suggestions for scripted excel saves with human friendly field names? We'd like to avoid a second set of export fields.

Thanks for your thoughts.

[Colin Keefe]

If the fields you're exporting aren't laden with validation, you could disable the "use field names as first row" option on export, and create a dummy first record with human readable headers in the exported fields.

You'll need a method to force sort the dummy header record to the top before exporting, and a method for deleting the dummy record afterwards.