Groups
Groups
Conversations
All groups and messages
Send feedback to Google
Help
Training
Sign in
Groups
Groups
openpyxl-users
Conversations
About
openpyxl-users
1–30 of 1359
Mark all as read
Report group
0 selected
Kiran Anilkumar
Jun 19
Generate excel sheet
i want this code to be worked and generate a detailed excel sheet. import pandas as pd from openpyxl
unread,
Generate excel sheet
i want this code to be worked and generate a detailed excel sheet. import pandas as pd from openpyxl
Jun 19
John Skilleter
, …
Vasan Varadarajan
14
Jun 13
Problems with charts in openpyxl 3.1.4 and later
Finally using various links, I got the 3.1.5 scatter plot working. The main difference was to specify
unread,
Problems with charts in openpyxl 3.1.4 and later
Finally using various links, I got the 3.1.5 scatter plot working. The main difference was to specify
Jun 13
Feng, Youyang
, …
Yuuya
11
May 26
Cannot detect all strikethrough in within a cell
Hello, Thank you for your explanation. Although creating a new cell was not my intention, with your
unread,
Cannot detect all strikethrough in within a cell
Hello, Thank you for your explanation. Although creating a new cell was not my intention, with your
May 26
Denis Bourouffala
, …
Руслан Кударов
7
May 25
openpyxl problem Workbook contains no default style, apply openpyxl's default
pd.read_excel(io, engine='calamine') пятница, 17 мая 2024 г. в 03:39:02 UTC+3, John Hendy:
unread,
openpyxl problem Workbook contains no default style, apply openpyxl's default
pd.read_excel(io, engine='calamine') пятница, 17 мая 2024 г. в 03:39:02 UTC+3, John Hendy:
May 25
Kyler Laird
,
Charlie Clark
2
May 22
access calculated value without resorting to data_only
On 22 May 2025, at 16:10, Kyler Laird wrote: Hi Kyler, My work has evolved into mostly using OpenPyxl
unread,
access calculated value without resorting to data_only
On 22 May 2025, at 16:10, Kyler Laird wrote: Hi Kyler, My work has evolved into mostly using OpenPyxl
May 22
吴少博
, …
Charlie Clark
4
May 19
insert_rows MemoryError
On 19 May 2025, at 16:37, john pendreich wrote: > if you think about programming in the "old
unread,
insert_rows MemoryError
On 19 May 2025, at 16:37, john pendreich wrote: > if you think about programming in the "old
May 19
Junaid Iqbal
May 12
pfa
from openpyxl import Workbook from openpyxl.utils.dataframe import dataframe_to_rows from datetime
unread,
pfa
from openpyxl import Workbook from openpyxl.utils.dataframe import dataframe_to_rows from datetime
May 12
Abdul Hakeem
,
Charlie Clark
2
Apr 23
Storing Excel files into a Sqlite databse
On 23 Apr 2025, at 13:22, Abdul Hakeem wrote: > Hello > > Could someone point me to how to
unread,
Storing Excel files into a Sqlite databse
On 23 Apr 2025, at 13:22, Abdul Hakeem wrote: > Hello > > Could someone point me to how to
Apr 23
Gericke Potgieter
, …
Buna sorn
7
Apr 14
Reading font color and cell fill color
what you cut my money stole from out from my card On Fri, 11 Apr 2025 at 8:29 PM Luis Fernando <
unread,
Reading font color and cell fill color
what you cut my money stole from out from my card On Fri, 11 Apr 2025 at 8:29 PM Luis Fernando <
Apr 14
Peter Capazzi
,
Charlie Clark
2
Mar 20
Waterfall chart
On 20 Mar 2025, at 15:45, Peter Capazzi wrote: > Would be great if waterfall charts were supported
unread,
Waterfall chart
On 20 Mar 2025, at 15:45, Peter Capazzi wrote: > Would be great if waterfall charts were supported
Mar 20
Sreejith Rangarajan
,
Charlie Clark
5
Mar 18
Cell styling attributes are not showing up when invoked for a sheet made through create_sheet method
Hi Charlie, To be frank I don't think this is an IDE issue. Here is the same issue being
unread,
Cell styling attributes are not showing up when invoked for a sheet made through create_sheet method
Hi Charlie, To be frank I don't think this is an IDE issue. Here is the same issue being
Mar 18
Arth Shah
, …
Sergey Krylov
4
Mar 17
Ungroup rows or columns
for row in ws.row_dimensions: if row > ws.max_row: ws.row_dimensions[row].outlineLevel = 0 четверг
unread,
Ungroup rows or columns
for row in ws.row_dimensions: if row > ws.max_row: ws.row_dimensions[row].outlineLevel = 0 четверг
Mar 17
Alessandro Pisa
,
Charlie Clark
5
Feb 19
Avoid injections attacks
On Wed, 19 Feb 2025 at 12:52, Charlie Clark wrote: Microsoft's own approach to this is to disable
unread,
Avoid injections attacks
On Wed, 19 Feb 2025 at 12:52, Charlie Clark wrote: Microsoft's own approach to this is to disable
Feb 19
Peter Holzer
2
Feb 17
Weird pseudo-merged cells
Found it: These cells are formatted with alignment.horizontal='centerContinuous'. Apparently
unread,
Weird pseudo-merged cells
Found it: These cells are formatted with alignment.horizontal='centerContinuous'. Apparently
Feb 17
Himanshi verma
Feb 6
Openpyxl charts getting corrupted on export
Hi All, I am facing the issue where when iam exporting charts into png , on or two charts are getting
unread,
Openpyxl charts getting corrupted on export
Hi All, I am facing the issue where when iam exporting charts into png , on or two charts are getting
Feb 6
Philippe Olszewski
Jan 17
Styles, colors for charts / python 3.8.2 , openpyxl 3.1.2
I read that there are issues with colors being lost when reopening with Excel. It works for cells,
unread,
Styles, colors for charts / python 3.8.2 , openpyxl 3.1.2
I read that there are issues with colors being lost when reopening with Excel. It works for cells,
Jan 17
Sumit Jahagirdar
,
Charlie Clark
2
Jan 17
Optionally apply styles to avoid file read bug
On 17 Jan 2025, at 12:33, Sumit Jahagirdar wrote: Hi, > I'd like to make a change to
unread,
Optionally apply styles to avoid file read bug
On 17 Jan 2025, at 12:33, Sumit Jahagirdar wrote: Hi, > I'd like to make a change to
Jan 17
Eugenijus Januškevičius
,
Charlie Clark
3
Jan 16
Grouping rows
Well, this roadmap is almost impossible. I would like to create every instance from scratch. Current
unread,
Grouping rows
Well, this roadmap is almost impossible. I would like to create every instance from scratch. Current
Jan 16
Reinis Reiņikovs
,
Charlie Clark
2
Jan 16
how to handle equals sign ?
On 3 Jan 2025, at 13:18, Reinis Reiņikovs wrote: > General question is how to print arbitrary data
unread,
how to handle equals sign ?
On 3 Jan 2025, at 13:18, Reinis Reiņikovs wrote: > General question is how to print arbitrary data
Jan 16
Eugenijus Januškevičius
,
Michel MARTIN
3
Jan 16
Noob question: named styles
Hi, thank you for the response. I can access the the cell styles, but I can't access and modify
unread,
Noob question: named styles
Hi, thank you for the response. I can access the the cell styles, but I can't access and modify
Jan 16
aurelien...@gmail.com
, …
Charlie Clark
5
12/12/24
Keeping sharedStrings.xml
On 12 Dec 2024, at 8:43, Ivan Jiang wrote: > Is there a link for this specification that states
unread,
Keeping sharedStrings.xml
On 12 Dec 2024, at 8:43, Ivan Jiang wrote: > Is there a link for this specification that states
12/12/24
saleh harak
,
Michel MARTIN
2
12/6/24
Just joined.
Hello from France Le mercredi 4 décembre 2024 à 09:05:53 UTC+1, saleh...@gmail.com a écrit : Hello
unread,
Just joined.
Hello from France Le mercredi 4 décembre 2024 à 09:05:53 UTC+1, saleh...@gmail.com a écrit : Hello
12/6/24
Levi Jennings
12/5/24
Pivot table renamed field
I am trying to scan a pivot table to compare against fields in a connection or normal tables, this
unread,
Pivot table renamed field
I am trying to scan a pivot table to compare against fields in a connection or normal tables, this
12/5/24
林伟明
,
Michel MARTIN
3
11/27/24
How do I get images of an embedded cell?
You use the openpyxl_image_loader module from openpyxl import load_workbook from
unread,
How do I get images of an embedded cell?
You use the openpyxl_image_loader module from openpyxl import load_workbook from
11/27/24
Brian Murrell (Brian J. Murrell)
,
Michel MARTIN
3
11/27/24
Delete rows but translate remaining rows
Are you referring to the block of text that reads: Note Openpyxl does not manage dependencies, such
unread,
Delete rows but translate remaining rows
Are you referring to the block of text that reads: Note Openpyxl does not manage dependencies, such
11/27/24
Gaurav Nandode
,
Michel MARTIN
2
11/27/24
Unable to Extract Cell Colors with RGB Values
Hey, Di you try this ? sh['B1'].fill.start_color.index[2:] It's work for me... Michel Le
unread,
Unable to Extract Cell Colors with RGB Values
Hey, Di you try this ? sh['B1'].fill.start_color.index[2:] It's work for me... Michel Le
11/27/24
Duc Thien Tran
,
Charlie Clark
4
11/6/24
Weird unmerged cell
On 6 Nov 2024, at 4:44, Duc Thien Tran wrote: > Yeah i tried that, and even print out the merge at
unread,
Weird unmerged cell
On 6 Nov 2024, at 4:44, Duc Thien Tran wrote: > Yeah i tried that, and even print out the merge at
11/6/24
Lee Carpenter
, …
Charlie Clark
20
11/4/24
Embedded Objects lost on workbook save.
Well, even a 3K or 6K zip does not post, so here is the code block for your reference: import xml.
unread,
Embedded Objects lost on workbook save.
Well, even a 3K or 6K zip does not post, so here is the code block for your reference: import xml.
11/4/24
Harald
,
Charlie Clark
3
11/1/24
On OpenPyXL and Dynamic Arrays!
On 31 Oct 2024, at 20:31, Harald wrote: > Now that I found the code repository I see that this is
unread,
On OpenPyXL and Dynamic Arrays!
On 31 Oct 2024, at 20:31, Harald wrote: > Now that I found the code repository I see that this is
11/1/24
Charlie Clark
10/25/24
et_xmlfile v2 released
Dear all, we're very pleased to announce the release of et_xmlfile version 2.0 with proper
unread,
et_xmlfile v2 released
Dear all, we're very pleased to announce the release of et_xmlfile version 2.0 with proper
10/25/24