Formatted output in Excel (Header only)
- 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
Hi,
I have a requirement to format the excel output.
Assume that I have a 50 column report/output generated from the workflow. for first 5 columns, I want header (column name) to be in bold, text white with background black. for next 30 columns I need header text in red with background color in black and for rest of the fields, header (column name), text in blue background in white.
Data should remain in default format (black text on white background) - as we see when we open any sample excel file.
Please suggest how to complete it.
thanks
aK
Solved! Go to Solution.
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Alteryx_user_aK,
You can transform these things with the Table tool. Then you can output this table with a Render tool.
You need two settings in the Table tool config..
1. Default Header definition
2. Individual Column settings (Column Rules)
See the attached WF for an example.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello FrederikE, I tried the same but when I render it in Excel file. It is not working. I get an error "found problem in abc.xlsx, do you want to recover". when I click on Yes, I get garbage. I see the output in browser tool though.
Thanks for your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Alteryx_user_aK ,
The error you have mentioned will occur because of the table layout size & the paper size you have selected in the Render tool configuration is not enough to process the table correctly.
Change the Paper size to Custom and size in 40 x 11 .
Let me if it does not work .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Oh.. I did not realize it Ramesh. my report has 170 cols. I'll change the paper size and try.
thanks
aK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's a related Idea. Adding a Like may help us get better options for Excel formatting.
Enhance options for Excel output
Chris
