Can we automate MS Excel File?

Help Studio
,
1

Hi All,

I am trying to automate Excel File , where I have to open Excel File and then click on File Option and Select Print option, where I have select printer dropdown and choose Printer type, Then click on No Scaling option to choose “Fit all columns on one Page” And click to Save As option and click on Browse option, then save as window will open and save your file as pdf.

Mainly focus all columns fit into one page and then convert into pdf file.

for reference sharing screen shot:-
1.
image

image
image197×765 4.96 KB

3.
image
image386×685 18.7 KB

Any suggestions??

2

@shuklarchana001

Yes you can automate these steps. Just record the steps how you are going to do it manually.

3

Why not just use the Export feature that directly creates a PDF? You don’t have to “print to PDF”

4

@lakshman Selectors does not support

5

@postwick I need to fit all columns in one page than save into pdf.

6

@shuklarchana001

What do you mean by not support ?