Windows popup interaction for downloading using selenium webdriver in python

Question

I am making a programme to automatically download the data using selenium webdriver in python. When i click on "download" button following popup occours

.

with default option "Open with" selected. I want my program to first click on the option "save file" and then click on "OK". I have used following piece of code to set up Firefox profile

    profile = webdriver.FirefoxProfile()
    profile.set_preference('browser.download.folderList', 2)
    profile.set_preference('browser.download.manager.showWhenStarting', False)
    profile.set_preference('browser.download.dir', os.getcwd())
    profile.set_preference('browser.helperApps.neverAsk.saveToDisk', "application/xlsx")

But it is not working in my case. Then I tried to switch to this window from main window by using following code

    parent_h = driver.current_window_handle
    handles = driver.window_handles
    handles.remove(parent_h)
    driver.switch_to_window(handles.pop())

But now I am not getting how to interact with this window?

Andersson · Accepted Answer · 2017-05-25 07:56:32Z

3

You should try to use preference with correct MIME type for xlsx extension which is "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", but not "application/xlsx":

profile.set_preference('browser.helperApps.neverAsk.saveToDisk', "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")

You can check list of MIME types for Microsoft Office files here

answered May 25, 2017 at 7:56

Andersson

52.8k18 gold badges83 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user8023364 Over a year ago

After using this mime also same pop-up window is appearing. Can you tell me another solution.

user8023364 · Accepted Answer · 2017-06-04 07:47:33Z

3

After so much findings and research, I get the following code which would be helpful for this type of situation.

    profile = webdriver.FirefoxProfile()
    profile.set_preference("browser.download.dir",os.getcwd());
    profile.set_preference("browser.download.folderList",2);
    profile.set_preference("browser.helperApps.neverAsk.saveToDisk", "application/csv,application/excel,application/vnd.msexcel,application/vnd.ms-excel,text/anytext,text/comma-separated-values,text/csv,application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/octet-stream");
    profile.set_preference("browser.download.manager.showWhenStarting",False);
    profile.set_preference("browser.helperApps.neverAsk.openFile","application/csv,application/excel,application/vnd.msexcel,application/vnd.ms-excel,text/anytext,text/comma-separated-values,text/csv,application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/octet-stream");
    profile.set_preference("browser.helperApps.alwaysAsk.force", False);
    profile.set_preference("browser.download.manager.useWindow", False);
    profile.set_preference("browser.download.manager.focusWhenStarting", False);
    profile.set_preference("browser.download.manager.alertOnEXEOpen", False);
    profile.set_preference("browser.download.manager.showAlertOnComplete", False);
    profile.set_preference("browser.download.manager.closeWhenDone", True);
    profile.set_preference("pdfjs.disabled", True);

answered Jun 4, 2017 at 7:47

user8023364

1591 silver badge12 bronze badges

1 Comment

s2t2 Over a year ago

after trying various SO solutions, i tried pdfjs.disabled as you mention, and it worked. however for me it only works in conjunction with browser.helperApps.neverAsk.saveToDisk, and the other settings are not needed.

Collectives™ on Stack Overflow

Windows popup interaction for downloading using selenium webdriver in python

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related