Groups
Conversations
All groups and messages
Send feedback to Google
Help
Training
Sign in
Groups
openpyxl-users
Conversations
About
Groups keyboard shortcuts have been updated
Dismiss
See shortcuts
openpyxl-users
Contact owners and managers
1–30 of 1352
Mark all as read
Report group
0 selected
Sreejith Rangarajan
,
Charlie Clark
4
5:16 AM
Cell styling attributes are not showing up when invoked for a sheet made through create_sheet method
On 15 Mar 2025, at 8:12, Sreejith Rangarajan wrote: > Is there something we can do to make this
unread,
Cell styling attributes are not showing up when invoked for a sheet made through create_sheet method
On 15 Mar 2025, at 8:12, Sreejith Rangarajan wrote: > Is there something we can do to make this
5:16 AM
Arth Shah
, …
Sergey Krylov
4
5:08 AM
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 четверг
5:08 AM
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
John Skilleter
, …
Yaakov W.
12
Jan 28
Problems with charts in openpyxl 3.1.4 and later
hi, I am trying to tun this, have no idea what to do... working with chat gbt,, lol can you help me i
unread,
Problems with charts in openpyxl 3.1.4 and later
hi, I am trying to tun this, have no idea what to do... working with chat gbt,, lol can you help me i
Jan 28
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
Abhi K
,
Charlie Clark
2
10/17/24
openpyxl is not loading images after certain number of rows
On 17 Oct 2024, at 8:58, Abhi K wrote: > Hi, > > I have a excel file with 1000+ images.
unread,
openpyxl is not loading images after certain number of rows
On 17 Oct 2024, at 8:58, Abhi K wrote: > Hi, > > I have a excel file with 1000+ images.
10/17/24
Aman Verma
, …
Charlie Clark
11
10/12/24
openpyxl returns None for value actually present and updated in the created sheet.
On 11 Oct 2024, at 23:27, Marcelo Lopes wrote: Hi Charlie, "Openpyxl itself never evaluates
unread,
openpyxl returns None for value actually present and updated in the created sheet.
On 11 Oct 2024, at 23:27, Marcelo Lopes wrote: Hi Charlie, "Openpyxl itself never evaluates
10/12/24
Marek Staroň
, …
Francis Finnegan
7
9/29/24
VLOOKUP formula using a named Table is corrupted when saved
Thank you Francis. Unfortunately, adding the _xlfn. before the function didn't help to get rid of
unread,
VLOOKUP formula using a named Table is corrupted when saved
Thank you Francis. Unfortunately, adding the _xlfn. before the function didn't help to get rid of
9/29/24
Maryanna Vernia
,
LeeHunter
2
9/28/24
Download Playlist From Spotify To Mp3 Online
Looking to advance your music career on Spotify? Discover how to implement key strategies to get your
unread,
Download Playlist From Spotify To Mp3 Online
Looking to advance your music career on Spotify? Discover how to implement key strategies to get your
9/28/24
Kristóf Kereszturi
,
Christian Harries
2
9/16/24
Turn off gridlines in bar chart
Hey, I worked on something similar. Try adding this: chart.y_axis.majorGridlines = None On Monday 12
unread,
Turn off gridlines in bar chart
Hey, I worked on something similar. Try adding this: chart.y_axis.majorGridlines = None On Monday 12
9/16/24
Luke Van Namen
,
Charlie Clark
2
9/3/24
Support for Copying Values of Formulas
On 2 Sep 2024, at 21:02, Luke Van Namen wrote: I have been using the WorksheetCopy class, and in the
unread,
Support for Copying Values of Formulas
On 2 Sep 2024, at 21:02, Luke Van Namen wrote: I have been using the WorksheetCopy class, and in the
9/3/24
Denis Bourouffala
, …
Diego DM
6
8/28/24
openpyxl problem Workbook contains no default style, apply openpyxl's default
I agree with John On Friday, May 17, 2024 at 2:39:02 AM UTC+2 John Hendy wrote: That is indeed one
unread,
openpyxl problem Workbook contains no default style, apply openpyxl's default
I agree with John On Friday, May 17, 2024 at 2:39:02 AM UTC+2 John Hendy wrote: That is indeed one
8/28/24
Ronald Domi
,
Charlie Clark
3
8/22/24
Insert rows wierd style behaviour
On 21 Aug 2024, at 10:06, Ronald Domi wrote: > Hello everybody, Hi Ronald, > While working with
unread,
Insert rows wierd style behaviour
On 21 Aug 2024, at 10:06, Ronald Domi wrote: > Hello everybody, Hi Ronald, > While working with
8/22/24
Thomas
, …
Charlie Clark
5
8/16/24
can't install with Python 3
On 15 Aug 2024, at 23:52, Jess Vriesema wrote: > Hi! Hi Jess, > I'm new to Google Groups,
unread,
can't install with Python 3
On 15 Aug 2024, at 23:52, Jess Vriesema wrote: > Hi! Hi Jess, > I'm new to Google Groups,
8/16/24