Need Excel sheet with identical column headers

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?

Solution

Hi Jason,

If there is a way of doing what you want is with this component

Regards,

Marcelo

Solution

Marcelo Ferreira wrote:

Hi Jason,

If there is a way of doing what you want is with this component

Regards,

Marcelo

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 :)