Jump to content
Sign in to follow this  

Column Headers When Saving as Excel

Recommended Posts

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.

Share this post

Link to post
Share on other sites

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.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.