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 sushilk307 over 10 years ago

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...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sushilk307 over 10 years ago

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...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data