How to Save a Specific Excel Sheet as a PDF

Help StudioX
,
1

Hello,

I need to save a specific sheet from an Excel workbook as a PDF. Is there a way to accomplish this?

Thank you!

2

Hi @lqxchan

You can use the save excel as pdf activity to save the excel as pdf.

Hope it helps!!

3

Hi @mkankatala

Thanks for the reply. I tried using the activity you suggested, but it appears to save the entire workbook instead of just one specific sheet.

Could you provide guidance on how to save only a particular sheet as a PDF?

Thanks!

4

Hi,

The following post may help you.

Regards,

5

Hi @lqxchan

If you want only particular sheet to PDF then copy that sheet into new excel then use Save excel file as PDF activity

Regards,

6

Okay @lqxchan

You want to save one sheet of excel as pdf right.

Then try the below steps,
→ Use the Copy file activity to copy the orginal file and paste it as a copied file, let’s name the copied file as Duplicate excel.xlsx.
→ Use the Excel Process scope activity and inside of it use the Use excel file activity and give the path of the Duplicate Excel.xlsx file to the Use excel file.
→ Inside use excel file activity use the For each excel sheet to iterate the each sheet in the excel.
→ Inside for each insert the if condition to not delete the required sheet.

- Condition -> Not(CurrentSheet.Name.toString.equals("Required sheet name"))

→ Inside the block insert the delete sheet activity to delete the current sheet which is not required to save it as pdf.
→ Then you have only sheet which is required to change to pdf.
→ After for each excel sheet activity use the save excel as pdf activity to save the excel as pdf.
→ Come out of Excel process scope activity and use the delete file activity to delete the Duplicate Excel.xlsx file.

Hope it helps!!

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.