Combining multiple excel workbooks into one pdf

[bethgrap]

Is there a way to combine multiple excel workbooks using the directory tool, keeping the formatting of each workbook, and exporting them to one single pdf?

Thanks!

[MichelleMitchellLutz]

Hi! When you say "keeping the formatting" are you referring to font, borders, etc.? If so, I don't think Alteryx will read in that kind of formatting. 

You can bring in multiple excel files and export them into one PDF, if that's what you are wanting to do. If you want to provide a sample of your Excel workbooks, I'd be happy to mockup an example. 

[Emmanuel_G]

Hi @bethgrap 

Find in attachement a way of doing that with dummy samples of data in .zip file and workflow to do the job.

Let me know if it works as you want.