Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert excel output to PDF (BLOB)

PassION_es
10 - Fireball

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.

 

Capture.PNG

 

render.PNG

formula_blob.PNG

 Thank you in advance.

4 REPLIES 4
OTrieger
12 - Quasar

@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
10 - Fireball

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

OTrieger
12 - Quasar

@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
10 - Fireball

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 

Labels