openpyxl
openpyxl copied to clipboard
theorchard
Hello, There`s and issue with 'self.read_worksheets()' when trying to open Excel file with specific structure. Issue discovered within pandas as backend. Method is unable to open excel file when there...
SmartArt figures are lost when opening with openpyxl unlike images
I am using pandas and openpyxl to generate a excell sheet. Everything works except: ``` validation = DataValidation( type="list", formula1='"Keep,Delete,Production"', allow_blank=True, showDropDown=True ) ``` Validation to the cells is added,...
I'm reading tables with openpyxl load_workbook. As it's extremely slow to load the workbook, I need to use `read_only = True`. Then I get a ReadOnlyWorksheet. But it has no...
Apologies if this is covered elsewhere, but I could not find anywhere a list of supported letters / codes that can be used for number_formats in the context of date...
```python from openpyxl.reader.excel import load_workbook xlsx_fp = r"D:\xslx_with_ole.xlsx" out_fp = r"D:\xslx_with_ole_processed.xlsx" wb = load_workbook(xlsx_fp, keep_vba=True) # cause corrupted file wb = load_workbook(xlsx_fp) # cause ole missing wb.save(out_fp) ```
After re-insert the same image in the excel file and tried to reopen it the file went corrupted. In other words, when an image is updated in the excel file...
Hi, when trying to open an excel (.xlsx) file, i got this error: Traceback (most recent call last): File "main.py", line 15, in load_workbook(filename='old.xlsx') File "~/.local/lib/python3.10/site-packages/openpyxl/reader/excel.py", line 317, in load_workbook...
See https://github.com/python/typeshed/issues/10995
This repo is NOT the official repo for openpyxl despite that it is the top google hit. As noted on the PyPI site: https://pypi.org/project/openpyxl/, The actual source is here: https://foss.heptapod.net/openpyxl/openpyxl...
