Converting multiple tabs into PDF file

[hendricksk]

I have excel workbooks that have several tabs with different formats that need to be converted into PDF files. Is there a way to do that in Alteryx? Or is it just easier to use an Adobe or Nitro software program?

[Yoshiro_Fujimori]

Hi @hendricksk 

There are hundreds of discussions on this topic.

You may go to Knowledge Base and search with keyword like "excel multiple sheets".

You will find useful articles like

https://knowledge.alteryx.com/index/s/article/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Exce...

Good luck!

[KGT]

Using Alteryx to do this in the standard way, will involve reading the tabs in as data tables and then writing them back out. So, if you actually just want to "Print the worksheets to pdf" and with formatting or merged cells etc, then another method is better.

If there are advantages to doing it in Alteryx, then you can use the R/python/Run Command tool with a script (you'll have to find one) to just print the sheets to PDF. In R/Python this could be using FPDF or similar.

If you want to do something to the data in alteryx before writing out, then totally different story, and use whichever method fits your process from the search @Yoshiro_Fujimori mentioned, then the reporting suite will help you write to PDF.