Hi I am using Export To Excel smart service. I am not able to find any sam

madhankumarb over 10 years ago

Hi
I am using Export To Excel smart service. I am not able to find any samples for excel template. Could you please provide me excel template and how to create the template.

I have array of numbers which I need to show in excel vertically. Could you please provide me template and what is that I should provide in Cell_Keys and Cell_Values in smart service.

Regards,
Madhankumar. B

Discussion posts and replies are publicly visible

0 helmuta over 10 years ago

Here is a template that I use to export information out of Appian. maybe this will give you some ideas.
export template.xlsx
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 10 years ago

@madhankumarb If you want to map a specific cell (rather than mapping an array of cells), please go with usage of Cell_Keys and Cell_Values.
Example:
Cell_Keys: ={"B5","B6","D5","E5","E6"}
Cell_Values: ={pv!a,pv!b,pv!c,pv!d,pv!e}
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 madhankumarb over 10 years ago

Thanks Helmuta. The excel template contains the headers like WRID,Submitter etc., Where will I supply the process variable for WRID, Submitter. In my case I have process variable namely "dummyLocations" which has array of numbers. I need place these values vertically from row2 in generated excel. What would be my excel template for this.

Thanks in advance,
Madhankumar. B
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmuta over 10 years ago

If you only have one column, your template would only have that one column. The name of the column does not matter.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel