Convert excel output to PDF without using Render

[Jenina]

Hi All,

Is there any way to simply convert the excel output to pdf without using table + render as the user wants to retain the excel formatting exactly how it looks.

Thank you!

[OTrieger]

Hi @Jenina 
One wqy will be using Python tool calling a pack that can save to PDF and another way is to use Run Command Tool that will call external program, such as excel to save the file as PDF.

[apathetichell]

https://devblogs.microsoft.com/scripting/save-a-microsoft-excel-workbook-as-a-pdf-file-by-using-powe... - I'd recommend using a powershell script - the python package (pywin32) which is most germane for this doesn't have the level of support I'd vouch for.

[Jenina]

@apathetichell @OTrieger Hello both - I am new to these tools, can you please share a sample workflow? Test file attached.

Thanks,

Jenina

[apathetichell]

I'd recommend asking ChatGPT and looking at the run command tool in Alteryx. This is a pretty complicated workflow and pretty customized.