This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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..
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).