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.

Spreadsheet with two title lines...

Postby rogersonra » Tue Apr 30, 2013 7:05 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
rogersonra
 
Posts: 1
Joined: Tue Apr 30, 2013 5:39 pm

Re: Spreadsheet with two title lines...

Postby Support_Rick » Fri May 24, 2013 12:08 pm

The easiest way to do this is to create a Template with your headers already defined. Something like:

Double_Header_XLS_Template.JPG
Double_Header_XLS_Template.JPG (24.53 KiB) Viewed 237 times


Then, set up your project for the writeExcel Task like this:

WriteExcelTask_BasicTab.JPG


Add the Data Element:

WriteExcelTask_DataElement.JPG


And execute ... your final output would look something like this:

WriteExcelTask_FinalOutput.JPG
Rick Elliott
Sr. Product Specialist
(402) 944.4242
(800) 949-4696
Support_Rick
Support Specialist
 
Posts: 172
Joined: Tue Jul 17, 2012 2:12 pm


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 1 guest