How to Control Export to Excel

D

Delnang

All,
I have a need to export InfoPath data to Excel. Everything is working fine
except for the following tweeks:

1. I want to know if I can control the order of the columns. For example,
when I use the export command the order of the fields are: Job Title, Job
Code, Level. I would like it to export as: Job Code, Level, then Job Title.
I changed the order for which these fields are in the data source, but that
did not seem to make a difference. Any suggestions?

2. I would like the specify the column headings. Excel file has heading
like: "Job_Code (my:myFields/my:position/my:Job_Code)" where I would rather
the column heading be JobCode. Is there a way to control this?

Thanks,
Angie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top