Formatting for Batch Macro Excel Output Sheets

Hello, I have a batch macro which outputs each new table to a new excel sheet. I am looking to format each of the sheets with the below formatting, is there a way to include the reporting tools in a batch macro so all the different excel sheets are formatted? I have attached the Alteryx Package for this, and please let me know if more information is needed. Below is the formatting I would need done:

Can the report be formatted so we don’t have to spend time opening columns in excel? Can we make sure the columns are spaced out so the headers are all showing?

Can we have the header rows highlighted?

Can we have first column highlighted?

Can we have the Metrics and Thresholds as percentages?

Thanks in advance!

Work needs Layout.yxzp

Workflow

Reporting

Accepted answers

All comments

messi007

@macst245,

Yes you can add table formating tool inside of the batch macro. And with a table tool you can the formating that you're looking for :

However in order to generate the Excel files you have to use a render tool.

Hope this helps !

Regards,

macst245

Thanks, I did try that, however when I added the table tool and the render tool, I kept getting an error. Are you able to edit the workflow with the formatting table added in?

Thanks again!

JagdeeshN

@macst245 can you please elaborate more on what is the error you are getting.

macst245

@JagdeeshN It's not an error that I'm getting, but I am just not able to output a file. Are you able to download the package and see if you are able to do the above that @messi007 suggested? Thanks in advance if you are able to try!

JagdeeshN

@macst245 Understood.

I think you are using the normal output tool within your batch macro (In the attached package)

Please refer to this post below. @christine_assaad and @pedrodrfaria have explained in detail about the possible solutions.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Formatting-Excel-Output-File/td-p/686734

Hope this helps!

macst245

@JagdeeshN I have read through those posts, but they are using a single input file. Should I replace my regular output file within my macro with a render tool?

JagdeeshN

@macst245 You can actually structure the batch macro to accept/process one file at a time.

And as described in the post i shared earlier you would need to use a combination of the Table tool and the Render tool to get the formatted output.

Hope this helps!.

Best,

Jagdeesh

macst245

@JagdeeshN Thanks for the push on this, I tried putting the table and render tool inside the batch macro, but am now getting the below error when running my overall workflow.

JagdeeshN

@macst245 Interesting!

The below post has different way in which this can be resolved depending on the cause.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/The-Designer-x64-reported-InboundNamed...

Specifically check out @Jackie7890 's answer:-

'I had this same error (The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended) and here is how I was able to fix it.

The problem started when I changed my output file name in a Render Tool using the text box directly, instead of browsing to the folder and typing in the name. In Alteryx, you have two options for entering your output filename, either by entering the full file path as a string, or by navigating to the folder and typing just the name of the output file, selecting the datatype, and clicking Save. in this case I was outputting a Report to an .xlxs, and had changed the output string directly to the same name as an existing file, desiring the Report Output to overwrite the existing file.

I resolved the problem by navigating to the desired folder using the Disc/Save button, then typing in the box, and the error disappeared. Even overwriting an existing report, I had no error. '

macst245

@JagdeeshN I really appreciate you pointing me to that thread, however I had tried the solution you had posted and others in that thread and am still getting the same error.

macst245

@JagdeeshN I figured this out and thanks again for your help. I had to add a layout tool in my workflow as well as the render tool (both of those were outside the macro).

Thanks again

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703