Spreadsheet with two title lines...
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
4 posts
Page 1 of 1
- Posts: 1
- Joined: Tue Apr 30, 2013 5:39 pm
Hello, I'ma new user and I am having a hard time finding what I'm looking for in the user guide and forums.
I want to create a title on the spreadsheet which spans multiple row. For example:
This is the first line of the title
Second line
Third line
Details....
On the writeExcelTask I am only allowed on Title (additional title was my first thought).
Then I changed the value of Title to ${Concat('This is the first line of the title','\n','Second line', '\n','Third line')]
but it still only wrote the title on one line.
How do I get the title to flow to more than one line?
Thanks,
Rob
I want to create a title on the spreadsheet which spans multiple row. For example:
This is the first line of the title
Second line
Third line
Details....
On the writeExcelTask I am only allowed on Title (additional title was my first thought).
Then I changed the value of Title to ${Concat('This is the first line of the title','\n','Second line', '\n','Third line')]
but it still only wrote the title on one line.
How do I get the title to flow to more than one line?
Thanks,
Rob
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
The easiest way to do this is to create a Template with your headers already defined. Something like:
Then, set up your project for the writeExcel Task like this:
Add the Data Element:
And execute ... your final output would look something like this:
Then, set up your project for the writeExcel Task like this:
Add the Data Element:
And execute ... your final output would look something like this:
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
- Support Specialist
- Posts: 62
- Joined: Thu Jul 19, 2012 9:15 am
- Location: Ashland, NE
-
If you need to dynamically build a spreadsheet with multiple heading rows here is another approach to consider.
Pass along your variables to your project, and write all your header specific rows to a file (I'd recommend you use a workspace to store it). Then, when you get ready to write out the data, simply use this new file that contains your header specifics as your template.
This will give you ultimate flexibility in writing your headings as you see fit while still being dynamic.
Thanks - Jon
Pass along your variables to your project, and write all your header specific rows to a file (I'd recommend you use a workspace to store it). Then, when you get ready to write out the data, simply use this new file that contains your header specifics as your template.
This will give you ultimate flexibility in writing your headings as you see fit while still being dynamic.
Thanks - Jon
4 posts
Page 1 of 1