Python is widely used in web applications, software development, data science, and machine learning (ML). Developers use Python because it’s efficient, easy to learn, and can run on various platforms. Python software is free to download, integrates well with all systems, and speeds up development. When you try to do anything automated in the tool, the following error appears: “Workbook contains no default style, apply openpyxl’s default in Python“. Don’t worry too much. This post will support you in resolving the error with the best solution.

When Will The Error “Workbook contains no default style, apply openpyxl’s default in Python” Occur?

You are using openpyxl and have a generated excel xlsx-file (with pandas).

myexcelfile = pd.read_excel(easy_payfile, engine="openpyxl")

But you do get a dreadful error:

/Users/milan/clientwork/environments/venv/lib/python3.8/site-packages/openpyxl/styles/stylesheet.py:214: UserWarning: Workbook contains no default style, apply openpyxl's default

  warn("Workbook contains no default style, apply openpyxl's default")

The Effective Methods For The Error “Workbook contains no default style, apply openpyxl’s default in Python”

Now, we will discuss some of the best solutions that will benefit you.

Solution 1: A straightforward and timely method

A straightforward and timely method to the problem would be to:

import warnings

with warnings.catch_warnings(record=True):

    warnings.simplefilter("always")

    myexcelfile = pd.read_excel(easy_payfile, engine="openpyxl")

Your error must now be fixed.

Solution 2: The original name containing a. (for example, MDM.TARGET)

You can solve the problem “Workbook contains no default style, apply openpyxl’s default in Python” by the original name containing a. (for example, MDM.TARGET), which you simply replace, and everything will be fine. Let’s look at the following code:

npm install

The above code may resolve your error.

Solution 3: Upgrade the sheet name in excel file

Excepting two methods mentioned above, there is another solution for you to fix the error “Workbook contains no default style, apply openpyxl’s default in Python”. It is that you should upgrade the sheet name in your excel file. Let’s change it from “sheet 1” to “Sheet1” and then the warning message will completely disappear. The warning is quite similar. We believe that finally Pandas will handle this error.

It is a simple method, right? However it works very perfectly and it will give you amazing results. The program will work without any errors. Let’s do it to get your desired results.

Conclusion

Python is a high-level programming language for general-purpose programming. Launched in 1991 by Guido van Rossum. The distinguishing feature of Python is its clean, easy-to-remember structure with minimal code structure, making it the perfect choice for every programmer, from the top experts to the novices. This language is also appreciated for its rigor, robustness, and integration with all operating systems. Those simple approaches presented above are solutions to the aforementioned major error: “Workbook contains no default style, apply openpyxl’s default in Python“. Please leave all your concerns in the comments section if you have any further questions. I wish you all an effective day with your tool.

Read more

→ Solutions For “FutureWarning: The default value of regex will change from True to False in a future version in Python”?