Need Help taking Excel worksheets and making them their own pdfs

(0) Share

Report

Posted on by AB-14010011-0

I have a workbook which takes forms submissions for equipment inspections and displays them as a daily checklist log for the month. I have designed these checklists in a specific way to resemble my company's paper format. I am trying to build an automated flow which takes each sheet and exports it with the sheet name as the file name and saves it as a pdf in a single folder. I cant find any help on this which doesnt require reformatting of the checklist. The checklist I built is not a table on excel because I couldn't get the formatting the way I wanted when it was a table because you can't merge cells on a table in excel.

I can currently get each worksheet to save to a destination, but the worksheets are always corrupted.

This is my current flow:

The Convert File step always ends up as "Bad Request".

I am lost if anyone can help.

Categories:

Business Process Flows

All responses (1)

Answers (0)

AlexEncodian 4,302 on at

Like (0)

Report

Need Help taking Excel worksheets and making them their own pdfs

You can convert specific worksheets to PDF using Excel - Convert – Encodian Customer Help.

If you don't know the worksheet names, you could convert the entire workbook to a PDF setting One Page Per Sheet property to 'Yes' and subsequently split the PDF into individual pages (i.e. worksheets) using PDF - Split – Encodian Customer Help