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
8190 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
if you are pulling the data using an SQL, you don't need the cell_key and cell_values. You just need the Starting cell. The entire table will auto populate starting from the starting cell that you mention.
So try your SQL statement and in the starting cell, mention the starting point (For e.g. A2). In this case, Column A - Starting from A2 will hold the First Name column, Column B starting from B2 will hold the Last Name and so on. Hope this helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sathya Srinivasan
Appian Employee
over 11 years ago
if you are pulling the data using an SQL, you don't need the cell_key and cell_values. You just need the Starting cell. The entire table will auto populate starting from the starting cell that you mention.
So try your SQL statement and in the starting cell, mention the starting point (For e.g. A2). In this case, Column A - Starting from A2 will hold the First Name column, Column B starting from B2 will hold the Last Name and so on. Hope this helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data