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
4 subscribers
Views
2723 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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