Hi All,
I am using Export SQL to Excel SS in 18.1 version with predefined template where data need to writes.
Done the SS configuration like below. For testing i am trying only with 1 cell.
1. Cell_Keys: {B10}
2.Cell Values: {ABC}.
3. Document name to create :"Today"
4. Save directory :XYZ
5. Excel bases template :ABC template stored in KC
6. Sheet number: 0
7. JNDI: Data source
8. SQL : "Select * from XYZ where id=1234"
Here is the template:
I am getting below When i am running my PM.
Any pointer on this will really helpful.
Discussion posts and replies are publicly visible