Hi When I am creating cell keys and cell values and adding in Export to exc

Let me know value need to enter on Cell_Keys,Cell_Values,Include_Header Row etc...

also can i use it through Export SQL to Excel ....?

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

thank..but i am how to use same for Export Sql to Excel smart service, I have 3 record FirstName LastName and Emplyee Number from SQL,in Cell__Keys i am using {"A1","B1","C1"} and Cell_Values {"FirstName"," LastName ","Emplyee Number "}, In Excel_base_template i am using template with same column name, Providing JNDI name, Sheet Number is 0 and SQL is "Select FirstName,LastName,EmployeeNumber from Contact" and Startimg Cell= A2...

no data is populating...

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.

ok thank you very much and Jndi Name you means <jndi-name>jdbc/primary_ds</jndi-name>
in appian-ds.xml ?

In most cases, yes. But it depends on if you've set the JAVA context to true or false. Ideally, its the JNDI name that is exposed for the application to consume. The easiest way is to drag and drop a Database node and check the JNDI name there.

I checked in Query Database Node...Now do you mean that JNDI name is same as DataSource name ?

you need the JNDI name. that's what the plug-in uses.

So you can try and copy what you see under "Data source" drop down in the Query database node.