Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
9 replies
Subscribers
5 subscribers
Views
2431 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Has anyone got examples of how to use the Export to Excel shared component?
Richard
over 9 years ago
Has anyone got examples of how to use the Export to Excel shared component?
...
OriginalPostID-120516
OriginalPostID-120516
Discussion posts and replies are publicly visible
0
Aleksi White
Appian Employee
over 9 years ago
The page for the plugin has some useful tips:
forum.appian.com/.../summary
Are you running into any specific issues?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
helmuta
over 9 years ago
I have some working examples if you need more information.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Richard
over 9 years ago
I have two primary questions:
One, I need to write a CDT list, but only specific elements.
Two, I want to write the data starting at a specific row, into an existing spreadsheet, and match specific columns. The spreadsheet runs formulas and summaries based on where I put the data.
I'm not 100% sure that I'm being clear, but if anyone has experience with this, I'd love the help...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
helmuta
over 9 years ago
As part of the node inputs you can select the CDT fields to export here is an example ={"wrid","submittername","submitdate","projectedstartdate","projectedlaunchdate"}
I have not tried starting to write at a particualr row but I know you can select the starting cell and sheet number (required)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Richard
over 9 years ago
How do you select the starting cell? That would be good enough, given what you've explained
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
helmuta
over 9 years ago
I use the Export CDT To Excel nodes
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
helmuta
over 9 years ago
I would assume you would need to put the Excel spreadsheet cell value something like A18 if you wanted to start at row 18 and the first cell. But I am not sure because I have not used this feature before. I could try and run a quick test if you would like.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Richard
over 9 years ago
Bugger, I just spotted the "Starting Cell" data input. Sorry, I think I get it now. Cheers!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
helmuta
over 9 years ago
Works like a charm. I put in a value of A10 and the export start on row 10. Just make sure to not put quotes around the value.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel