openpyxl problem Workbook contains no default style, apply openpyxl's default

[Denis Bourouffala]

Good Morning,

In the version 3.1.2 of openpyxl, I've message :

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

This is my prog : 

from openpyxl import load_workbook
filename = "C:\\Analyse Article EPF.xlsx"
wb = load_workbook(filename, data_only=True)
ws_conversion = wb["Conversion"]
print(ws_conversion.max_column)

Where is the problem ?

Thanks to help

Best regards

[Charlie Clark]

On 1 Feb 2024, at 9:56, Denis Bourouffala wrote:

> Where is the problem ?

There isn't a problem: it's just a warning that the workbook contains no stylesheet and that we apply Openpyxl's default. All workbooks should contain a stylesheet so that there is no confusion when styles, including time and date formats are applied.

Charlie

--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Sengelsweg 34
Düsseldorf
D- 40489
Tel: +49-203-3925-0390
Mobile: +49-178-782-6226

[Denis Bourouffala]

Thank you

How can I solve or remove this?

Best regards

--
You received this message because you are subscribed to the Google Groups "openpyxl-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openpyxl-user...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/openpyxl-users/934281DC-F0C3-4A30-BCA7-FE99229857B8%40clark-consulting.eu.

[Charlie Clark]

On 1 Feb 2024, at 10:44, Denis Bourouffala wrote:

> Thank you
>
> How can I solve or remove this?

You can configure Python to ignore warnings.

[John Hendy]

That is indeed one approach, but why is this preferred vs. giving the user a way to say "I know my workbook has no default style; please apply openpxyl's default"?

I expected something like pd.read_excel('foo.xlsx', style='openpyxl_default') so that I can be explicit and remove the warning, and was surprised not to find this ability. As a counter, see this proposed solution from SO where all the answers say to silence the warnings[1]:

import warnings

with warnings.catch_warnings():

    warnings.simplefilter("ignore")

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

What if I'm reading in hundreds of files and some other warning I actually care about emerges? Other answers wrap pd.read_excel() in some other function just to handle this warning. Having the function itself address this seems cleaner in my opinion.

I'm reading that the "value" of this warning is to say, "All excel sheets should have a stylesheet and yours doesn't! But I went ahead and applied one, FYI!" Why not let me grant explicit permission to apply that default so I don't have to be warned that openpyxl is doing it anyway?

Admittedly the nuisance is minor, but results in a ton of junk output in e.g. jupyter notebooks if I'm reading in/concatenating a directory of excel files. Importing a library just to silence warnings this also feels like a nuisance, and that there's a better approach than silencing warnings.

Best,

John

[1] https://stackoverflow.com/questions/66214951/deal-with-openpyxl-warning-workbook-contains-no-default-style-apply-openpyxl

[Diego DM]

I agree with John