Save only one Excel sheet as pdf with "Save Excel File as pdf"

[Mueller_Christoph]

Hallo,

I started to use UI Path and I want to print one selected Excel sheet as a pdf. My web search unfortunately has not helped me, because the field to select the sheet is missing in the latest version I am using. Any idea how I only can print only 1 selected sheet with “Save Excel File as pdf”?

Thanks a lot in advance

[Krishna_Raj]

@Mueller_Christoph

UiPath - Convert Excel to PDF | Save Excel File As PDF Activity | Select the pages to convert

Hello, In this video, you are going to learn about the UiPath activity to convert Excel documents to PDF. This will be helpful while automating the scenarios to convert the Excel to PDF for sending to the Client or for doing a file upload. " Saves an Excel workbook as a PDF file. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook." https://docs.uipath.com/activities/docs/save-as-pdf-x [UiPath - Convert Excel to PDF |…

check the thread

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Save Excel file as PDF activity - in a specific TAB

Hello Friends, Hope you are doing well. I would really appreciated if you could help me with this problem. I need to save an excel file as pdf document. I am using “Save Excel File as PDF” However, my excel file has several tabs [image] in the tab données, i have a lot of records and i want to save as pdf the information starting from the next tab… which starts at page 261. (please look at next picture below) [image] My question is: 1.- how i can set up this activity just to convert …

[Yoichi]

Hi,

How about copy the workbook to other name then remove unnecessary sheets in it as the following?

Regards,

[Mueller_Christoph]

Hallo, a good idea to delete the not needed sheet, but I want to print diagrams. I think they will not work if I delete the sheets with the data before printing. Unfortunately, everything is connected and I even cannot select the page, because it changes depending on the amount of data in the tables.

[Yoichi]

Hi,

All right. Can you try the following? This hides unnecessary sheets instead of removing and it will work as you expect.

Using wb As New ClosedXML.Excel.XLWorkbook(filename)
Dim sheets As ClosedXML.Excel.IXLWorksheets = wb.Worksheets
wb.Worksheet(targetSheet).SetTabActive()
For Each  s  In sheets
If s.Name<>targetSheet Then
		s.Hide()
End If
Next
wb.Save()
End Using

[Mueller_Christoph]

Hallo,

thanks a lot for your proposal. However, I found an easier solution: Invoke VBA. The VBA code is a two line code:

1. select sheet
2. save as

(you can generate your code in excel very easy by using record a macro)

[postwick (Paul Ostwick)]

Read Range that sheet into a datatable. Write Range that sheet to a new Excel file so it only has that sheet. Then Save Excel File as PDF.

[Alex_R (EncodianConnector)]

@Yoichi

wing? This hides unnecessary sheets instead of removing and it will work as you

The Encodian API can convert a particular sheet to PDF.

Swagger UI (apps-encodian.com)

The support pages has documentation for the Encodian PowerAutomate connector but the pages will show you the options and how each action works:

Power Automate Action Documentation – Encodian Customer Help

The request object has an element or “worksheet” where you can specify the worksheet name. You can also choose not to export hidden sheets and choose various configurations.

{
“outputFilename”: “excel”,
“fileName”: “string”,
“fileContent”: “string”,
“outputFormat”: “PDF”,
“worksheet”: “string”,
“onePagePerSheet”: false,
“allColumnsInOnePagePerSheet”: true,
“removeDocumentMarkup”: true,
“exportHiddenSheets”: false,
“cultureName”: “string”,
“generateBookmarks”: true,
“pdfaCompliance”: true,
“pdfaComplianceLevel”: “PDF_A_1A”,
“tiffCompression”: “None”
}

Specifically:

Convert Excel – Encodian Customer Help