I am using Export CDT To Excel to produce a file. Now that I have conquered tha

helmuta over 10 years ago

I am using Export CDT To Excel to produce a file. Now that I have conquered that item, I was given an additional challenge. I need to add some text 6 rows after the last entry. The nice thing is the text will never vary but the length of my document will. Any ideas on how I might tackle that item? I thought about trying to do something with my template but it does not even appear that my template is being used.

Thanks in advance for any suggestions....

Discussion posts and replies are publicly visible

0 helmuta over 10 years ago

It actually is using the template. I added the additional information to sheet two of the export template excel spreadsheet. Not the optimal situation but it will work for now. If anyone has other ideas please tell me.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Shawn Bittinger
Appian Employee
over 10 years ago

Could you conditionally set the Parameter "Starting_cell" to be 6 rows after your last entry?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmuta over 10 years ago

Not sure how to add the text after I have exported the data to excel.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Shawn Bittinger
Appian Employee
over 10 years ago

In that case you would have two Export CDT To Excel Smart Services. The first one would create your initial document. Then in your second node, you can use the document that was just generated by the first node as the template for the next export. There you can specify what cell you want to start your second export at.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmuta over 10 years ago

I will have to give that a try. Thanks for the suggestion.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel