openpyxl
openpyxl copied to clipboard
theorchard
``` import time start = time.time() import openpyxl print("Importing openpyxl took %.1f seconds" % (time.time()-start)) ``` This prints `Importing openpyxl took 14.6 seconds`. This makes the library unusable for my...
I'd like to be able to edit fonts at the character level rather than the cell level for redlining.
With pandas 1.5.3 or pandas 2.0.0, reading in Excel files is broken with openpyxl 3.1.1. Version 3.1.2 fixes this, and is available with pip, but 3.1.2 is not available on...
Hi all, im trying to group columns with openpyxl but it seems not to be working properly. can anyone help me? ```python ws.column_dimensions.group('M', 'X', outline_level=1) ws.column_dimensions.group('AA', 'AL', outline_level=1) ``` result:...
Hi. When I try to list the images that are inside a worksheet, it returns back the same id and path for each image. See code snippet below. I am...
I'm using openpyxl to generate vba-enabled spreadsheets and it has been working a treat. I simply have a base xlsm file which I then populate with the relevant customer's data...
fields that have say up to around 4 commas in them are getting the commas stripped, but fields with more (8 is my reference point) are being retained. reading the...
HTR: call load_workbook() for the following Excel [report (20) bug - Copy.xlsx](https://github.com/theorchard/openpyxl/files/10931080/report.20.bug.-.Copy.xlsx)
Here is a MRE. Download [huge_bug.xlsx](https://github.com/theorchard/openpyxl/files/10886079/huge_bug.xlsx) first: ```py from openpyxl import load_workbook document = load_workbook("huge_bug.xlsx") # hide column AJ document.active.column_dimensions["AJ"].hidden = True # save workbook document.save("huge_bug_2.xlsx") ``` I want to...
I have a problem with the error `'ReadOnlyWorksheet' object has no attribute 'defined_names'` when loading a workbook. Stack trace: ``` File "/opt/my_project/utils/excel.py", line 55, in load_workbook return openpyxl.load_workbook( File "/usr/local/lib/python3.10/site-packages/openpyxl/reader/excel.py",...
