I'm creating a transformer and getting an XLS output starting to write on row 2. I've successfully set a template for the header and format, however I need to write specific data such as date or file description in the top row.
How can I write the Document title on cell A1, Author on cell B1, DDMMYY on cell C1?
Best answer by takashi
Hi @heboma, you can control cell positions to write specific values through using some Excel writer feature type parameters.
Output Field Names: Set "No" not to write field names.
Use Attribute Names As Column Positions: Set "Yes" so that attribute names (A, B, C, ...) determine the column positions.
Row Number Attribute: Set an attribute that stores "1", in order to the values will be written into the first row.
Did this help you find an answer to your question?
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.
Hi @heboma, have you tried defining the attribute names with an AttributeCreator or AttributeManager? Do these attribute names need to be created dynamically?
thanks @takashi @danilo_inovacao Great idea! Looks good, I just need to be able to insert the value above my data table as it is part of the header and not the data.
Hi,
I'm creating a transformer and getting an XLS output starting to write on row 2. I've successfully set a template for the header and format, however I need to write specific data such as date or file description in the top row.
How can I write the Document title on cell A1, Author on cell B1, DDMMYY on cell C1?
Page 1 / 1
Hi @heboma, have you tried defining the attribute names with an AttributeCreator or AttributeManager? Do these attribute names need to be created dynamically?
Hello @heboma, on the last year i created a Workspace that has your goal.
By the way has a interessant Webinar about format xls format Webinar Excel.
thanks @takashi @danilo_inovacao Great idea! Looks good, I just need to be able to insert the value above my data table as it is part of the header and not the data.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.