Ok - so this is weird but for a specific application I need to have an excel sheet with identical headers on several columns. For the import on the other side they have to have it like that. So I made a structure so I can specify the header names however instead of just using my supplied headers the built in record list to excel puts the column as "myname", "myname(32)" and "myname(33)" when I want it to just be "myname", "myname" and "myname". Anyone know how to edit the headers so that I can make this happen?
Hi Jason,
If there is a way of doing what you want is with this component
Regards,
Marcelo
Marcelo Ferreira wrote:
Marcelo - thank you for the pointer. I was able to use the built in record list to excel, then open that binary, get the worksheet from that, edit the cells I wanted to (I did not do find/replace but I know where these are going to be so I just hard coded what to put in where) then I get the binary from what I had just been editing and use that for download. I will be deleting several of the actions I don't need but this seems to work great!
Glad I could help :)