Appending data to Excel Template
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I possess an Output Template.xlsx. I have a Create Table with Data.yxmd workflow which I used to create Data File.xlsx. I would like to append the 3 columns of data in Data File.xlsx below Output Template.xlsx at Cell A16 and create a new Excel file using Reporting tools.
I have attached the 3 files. Can I get recommendations on how to create the required output?
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @busybee
Since you have a template file you can directly write to the file. You can configure like below.
Workflow:
1. Write from range. Start A16 and infinite end Z99999 so that it can fit the table.
2. Skip field names.
3. Preserve formatting on overwrite.
4. Output option should be overwrite sheet.
Output:
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @busybee
If you want to create a new file each time and keep the original template as it is you can do something like below. This is a method I learnt from @AkimasaKajitani
Workflow:
You can use a branch with blob tools to read a template file and create a copy of it with a different name. Once you have created the new template file write to it using output tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The Table tool in my Create Table with Data.yxmd workflow will create background colors and font colors for the data. I cannot output this formatting without Reporting tools.
The updated workflow and the output are attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @busybee
If you are using report tool then you would need to use render tool to output the file. Render tool default and only mode is to overwrite file hence it cannot write range or write to an existing formatted excel file.
You can instead apply all these formatting including conditional formatting in the excel file itself and write to it using output tool. The formatting will be applied based on the excel file hence if you have conditional formatting it would format based on value.
Hope this helps : )
