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...

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