xlutils | Utilities for working with Excel files

Using your current method/Selenium you are rendering the actual webpage, which you don't need to do. I recommend using a Python library that will handle it for you. Below is an example of YoutubeDL:

looks like you haven't imported the right function from the right place. Try this:

Here is an example of using apply with a custom function. For small dfs this should be fine; this will not scale well for large dfs. A more sophisticated data structure for memo would be an ok place to start to improve performance without degrading readability too much:

According to the docs at https://xlrd.readthedocs.io/en/latest/on_demand.html:

on_demand=True and BIFF version >= 5.0: open_workbook() loads global data and returns without releasing resources.

You should either set on_demand=True to False so rb2 releases the underlying resources, or call rb2.release_resources() befor trying to save the copy.

You can use a try/except - see here for more information

Issue is with function return type. As seeing structure of your code I can assume you are creating your WebDriver driver in some set up class and passing it around.

Now you need to understand when you don't add a return type to a function in python, by default it returns None. As a result in setup method is self.driver set to None.

Please add return driver statement to your setup method and it should work.

You can use this

Package name is all lower case import xlutils. But before importing it make sure that it is added in your project interpreter in PyCharm settings. File -> Settings -> Project: (your project name) -> Project Interpreter, on the right top corner there is + sign, click on it and search for package name xlutils (all lower case), install the package and it should work.

To iterate over an excel sheet, you can use the sheet.nrows() function in the xlrd module.