Table to Multiple Excel Files | Including Formatting (Render)

Dear Alteryx Community,

I have excel Input files that I am splitting based on the Column "File" which shows the saving path as well as the Company Code (which is the differing criteria).

When running the workflow I get multiple Excel files, each showing different amount of rows which is as expected.

Is there however a way to also automatically format all those different Excel files? As far as I have seen, it can only be done for one Excel File with potentially more tabs but not for more Excel Files?

Thank you very much for your help on this!

Kind regards,

Alex

Output

Accepted answers

maier_alexander_MO

Hi @afv2688 ,

thank you very much again for your reply on the down below! Based on your input I tested quite a lot and finally made it without a macro:

I have two differerent Input Tables "BankAccountDetails" and "Deviations" which each show one report for different companies. I created Tables with the rendering tools as well as a helping column "File" which consists of the company code and the current date. Based on those information and different aggregations - I receive one (formatted) Excel Report for each company, containing two sheets each (BankAccountDetails & Deviations).

Kind regards,

Alex

Multiple_Excels_Multiple_Tabs.yxmd

All comments

afv2688

Hello @maier_alexander_MO ,

What are you looking for with the formatting exactly. There are multiple ways to format multiple sheets, even multiple excels at the same time with different format within the same excel file.

Could you share with us exactly what it is what you would like to do so I can maybe prepare something for you?

Regards

maier_alexander_MO

Hello @afv2688 ,

what I would require is basic formatting, like bold headers and adjusted column width.

I also attached the current workflow. In the first container the Excel Files are generated based on grouping by Column "File". In the second container, the data from a second excel file is then added within the existing Excel Files as an additional Excel Sheet.

I tried a few things with the Reporting Tools but did not manage to get separate excel files with the render tool..

Do you have any ideas on that?

Thank you very much for your help!

Kind regards,

Alex

BAA_Reporting.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703