Convert excel output to PDF (BLOB)

[PassION_es]

Hi,

Please help.

I have an excel template as my BLOB Input and my output resulted to same format (excel).  I would like to convert my excel output to pdf format but unable to figure out.

 

 

 Thank you in advance.

[OTrieger]

@PassION_es 

What are you trying to do?

Blob gives you the option to take a template and fill it in with data and then keep the original formatting. 

Are you trying to get a template fill it with data into a specific format and then need the file to be converted to PDF?

[PassION_es]

Yes, after blob fill all the data in excel format, i would want to convert it to pdf format.

[OTrieger · Accepted solution]

@PassION_es 
You can use Python tool to do it or Run Command tool. As the file that you are writing out will need to be excel file as Alteryx will need to enter the data into the template. After that this is done, the new file will need to be converted into PDF. There is no a straight way with Blob tool.

Another option, if the design is not too complex to try and recreate it in Table Tool and then render it to a PDF.

[PassION_es]

Ok, i see. dont know how to use python tool, don't have environment installed. And the table design is too complex (tax forrm). Maybe i will try a vba macro.

Thank you @OTrieger 

[Ojas1997]

You can use the below attached macro for multiple file. You need to enter just filepath,sheetname, pdf path.This is Python batch macro to convert any excel file to pdf format.