Hi,
I am trying to export sql data into an excel report template. for example: I need to pass a particular attribute to the cell A24. Any pointers?
Thanks so much
Question
exporting data into an excel template
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+52- Celebrity
Hi @gerry,
About to write attribute in a particular cell in XLS file, has two interesting Questions:
- Set especific value https://knowledge.safe.com/questions/50005/xls-writer-set-specific-cell-value.html
- Identify the cell information https://knowledge.safe.com/questions/20516/identify-the-cell-information-xls.html
Thanks,
Danilo
+15- Safer
Hi @gerry,
In the Excel Feature Type Writer, you can define the starting cell location using the following parameters.
Depending on your data and your excel template, you may or may not want to output the field names.
If you need more assistance, this article here has a section on starting cell locations (Step 8).