Main siteMain site  ForumForum  ForumSearch  Private messageEmail contact  RegisterRegister  Log inLog in 
Topic: excel headers
Reply to topic
Author Message
GMartin



Joined: Feb 5, 2010
Posts: 206

PostPosted: Jul 19, 2018 11:01 AM    Post subject: excel headers

Ok something went wrong with the attempted post.
I know I did this once many years ago but can not retrieve the snippet. I want to created multiple headers in and excel writer. I know to use the test set, I just can not remember what to use as a separator between the values in order to create multiple headers.

Thanks
jarek



Joined: Oct 22, 2007
Posts: 605

PostPosted: Jul 19, 2018 11:08 AM    Post subject:

Typically you use the same character between header names as selected in "Channel Separator". If that is a space, then just put 1 space between each header name. You can also use special characters there (which start with a backslash).
GMartin



Joined: Feb 5, 2010
Posts: 206

PostPosted: Jul 19, 2018 2:04 PM    Post subject:

apologize for being thick headed today.

I set the channel separator to semicolon. In the header field I entered the headers I wanted separated by semicolon but in the resulting file all the values were in the first column. I tried setting the headers via text set and property setter in the same way but with the same result.

I am not sure what I am doing wrong or if I misunderstood your reply

thanks for any help


George
jarek



Joined: Oct 22, 2007
Posts: 605

PostPosted: Jul 19, 2018 2:25 PM    Post subject:

What do you mean by "all the values were in the first column" ?

I created a very simple snippet, it seems to work:

http://proatech.com/design/excel_writer_headers.bpd
GMartin



Joined: Feb 5, 2010
Posts: 206

PostPosted: Jul 19, 2018 2:26 PM    Post subject:

Sorry,

I made a simple input error. It seems to be working now. I downloaded the snippet and will compare it to what I am doing

thanks for your help
Reply to topic