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
26 replies
Subscribers
5 subscribers
Views
8187 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi When I am creating cell keys and cell values and adding in Export to exc
siddharthg521
over 11 years ago
Hi
When I am creating cell keys and cell values and adding in Export to excel smart service it works fine if the keys are till Z. However after that when key reaches AA, then it works incorrect. I mean , if the key is "AA1", then the data is rendred in the cell "A1" in excel instead of "AA1". Similarly if the key is "BB1", the data is getting populated in cell "B1". Why is this happening? Any special reason which I am missing out.
Thanks in advance...
OriginalPostID-65982
OriginalPostID-65982
Discussion posts and replies are publicly visible
Parents
0
Sathya Srinivasan
Appian Employee
over 11 years ago
This plug-in at the moment does not support exporting CDT. One way I can think of is to create a report with each column being cdt.value and then using the Export Report to Excel smart service that's in this package to get the data out.
For your other question, Cell__Keys and Cell_Values are array of the Cells in Excel where data should be written into and the corresponding data. Remember, this is a one-to-one mapping. For e.g Cell_Keys {"A1","A2","A3"} Cell values {"Cat","Bat","Rat"} would populate the first three cell columns of Column A with the corresponding value. Header Row is used for SQL to use the SQL column as the 1st row of the report
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sathya Srinivasan
Appian Employee
over 11 years ago
This plug-in at the moment does not support exporting CDT. One way I can think of is to create a report with each column being cdt.value and then using the Export Report to Excel smart service that's in this package to get the data out.
For your other question, Cell__Keys and Cell_Values are array of the Cells in Excel where data should be written into and the corresponding data. Remember, this is a one-to-one mapping. For e.g Cell_Keys {"A1","A2","A3"} Cell values {"Cat","Bat","Rat"} would populate the first three cell columns of Column A with the corresponding value. Header Row is used for SQL to use the SQL column as the 1st row of the report
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data