Optionally apply styles to avoid file read bug

[Sumit Jahagirdar]

Some excel files have minor corruption in cell style metadata.

 

Extraction of this is done triggered at reader > excel > excel.py > ExcelReader

This is blocking reading of the actual cell values.

I'd like to make a change to optionally apply stylesheets and ideally have it included in the next release.

In case someone knows of an existing workaround, please let me know.

Thanks!

[Charlie Clark]

On 17 Jan 2025, at 12:33, Sumit Jahagirdar wrote:

Hi,

> I'd like to make a change to optionally apply stylesheets and ideally have
> it included in the next release.

It's unlikely that such a change would be accepted. It is much better to fix or, if you insist, remove the stylesheet from the archive before you pass it to Openpyxl.

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