Formatting and data type conversion

[mercurial_maverick]

Hello all,

Attached file has "Input" and "Desired Output" tabs for your reference. I've a workflow which outputs data as in the Input tab. However I need the data to be formatted with borders, colors (for column names and rows with "total"), last 5 columns to be converted to financial information, etc. Long story short I need the Input tab to be replicated as the desired output tab. I tried to use the "Table" tool (with row rule for highlighting total row, borders, etc) and "Render" tools but unable to achieve the desired output. Please let me know how this can be done.

[AngelosPachis · Accepted solution]

Hi @mercurial_maverick ,

Is this good enough?

You can edit the background colour through the default table settings, under the headers tab. To make the final row grey, i have created a row rule checking if the value under the "Total" field=="Total".

The for the final 5 fields, I have used a multi-field formula tool before the table tool.

Hope that helps, let me know if you have any questions.

Regards,

Angelos

[mercurial_maverick]

@AngelosPachis Thank you for your input. I tried to run your workflow and encountered the below issues. Please attached output file using render tool.

1. Most column values and column headers are truncated. Even the financial information towards the end is truncated.

2. Most row values & column headers are listed as "wrapped text" making the row and column width uneven. Is it possible to have the same view as mentioned in my "desired output" tab?

[AngelosPachis]

Hi @mercurial_maverick 

That's probably because the size of the Excel table your are outputting to does not suffice to fit the whole table.

I've used an html in my example, but for an Excel you can change the Report Style in the configuration window of the render tool to custom; I tried 1000x1000 and it worked fine, no cells were truncated.

Give it a try and let me know if it worked for you.

Regards,

Angelos

[mercurial_maverick]

@AngelosPachis This worked, thank you!