How to save Excel as PDF in a landscape Orientation and fit all columns on one page

[saransh_garg]

Hi All,

Can you please let me know any direct method to save Excel as PDF in a landscape Orientation and fit all columns on one page without hot key option.

[Gayathri_Mk]

Have you tried with Save Excel as PDF activity

[lrtetala (Lakshman Reddy)]

Hi @saransh_garg

Try this

Excel to PDF.txt (452 Bytes)

Cheers!!

[Krishna_Raj]

@saransh_garg

Need help to print Excel as PDF in a landscape Orientation and fit all columns on one page

Hi @divya.x.kuchi Directly using UiPath Activities, not sure, but I did use this trick to get my workdone Sub PrintDataSheets() Dim mySheets As Variant, sh mySheets = Array("InputData", "interMediateData", "OutputData") For Each sh In mySheets Sheets(sh).PageSetup.Orientation = xlLandscape Next Sheets(mySheets).Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Test" & ".pdf", _ Quality:=xlQualityStandard, IncludeDocProperties:=True,…

check the reference

[Nayan_Sharma]

Hi @lrtetala,

I want to use classic activities for the same process can you please help me in this?

Cheers,
Nayan

[Nessundorma]

Select the range of data in your Excel worksheet that you want to save as a PDF.
- In Excel, go to the File tab (or Office in older versions of Excel).
- Select Print or “Save As”, depending on your version of Excel.
- In the print dialog, select the Microsoft Print to PDF printer (or another virtual PDF printer if you have others installed).
- Adjust print settings, including page orientation (landscape) and scaling (you may need to scale down to fit all columns on one page).
- Click the Print or Save button to save the document as a PDF.

[Mehul_Jethva1 (Mehul Jethva)]

This worked like a charm! Thank you!!