Groups
Sign in
Groups
openpyxl-users
Conversations
About
Send feedback
Help
openpyxl-users
Contact owners and managers
1–30 of 1294
Mark all as read
Report group
0 selected
John Skilleter
,
Charlie Clark
6
Jul 5
Problems with charts in openpyxl 3.1.4 and later
On 5 Jul 2024, at 16:29, John Skilleter wrote: I agree that it is an Excel bug - LibreOffice Calc is
unread,
Problems with charts in openpyxl 3.1.4 and later
On 5 Jul 2024, at 16:29, John Skilleter wrote: I agree that it is an Excel bug - LibreOffice Calc is
Jul 5
Ettien Etienne BEKOIN
Jul 3
INFORMATIONS
Hello everyone, sorry for the inconvenience, is it possible to import a password-protected Excel file
unread,
INFORMATIONS
Hello everyone, sorry for the inconvenience, is it possible to import a password-protected Excel file
Jul 3
Francis Finnegan
,
Charlie Clark
2
Jun 25
Changing Text Color of Chart title, x-axsi, and y-axis
On 24 Jun 2024, at 22:34, Francis Finnegan wrote: Does anyone know how to change the color of a
unread,
Changing Text Color of Chart title, x-axsi, and y-axis
On 24 Jun 2024, at 22:34, Francis Finnegan wrote: Does anyone know how to change the color of a
Jun 25
Charlie Clark
Jun 19
Re: [openpyxl-users] Problem with install
On 19 Jun 2024, at 8:55, Attila Gábris wrote: > Hi! > I downloaded the sourcecode in a .zip and
unread,
Re: [openpyxl-users] Problem with install
On 19 Jun 2024, at 8:55, Attila Gábris wrote: > Hi! > I downloaded the sourcecode in a .zip and
Jun 19
Jay Taffer
,
M N
3
Jun 18
n00b, reading cell's value
Thanks! On Monday, June 17, 2024 at 3:09:52 PM UTC-5 MN wrote: `cell.value` not `cell.value()`,
unread,
n00b, reading cell's value
Thanks! On Monday, June 17, 2024 at 3:09:52 PM UTC-5 MN wrote: `cell.value` not `cell.value()`,
Jun 18
Charlie Clark
Jun 12
ANN: Openpyxl 3.1.4 released
Hi everybody, it's been a while but I'm pleased to announce that Openpyxl 3.1.4 has been
unread,
ANN: Openpyxl 3.1.4 released
Hi everybody, it's been a while but I'm pleased to announce that Openpyxl 3.1.4 has been
Jun 12
Kurt Schmitz
,
Charlie Clark
4
Jun 11
Array Formulas : how can I see the actual dynamic array formula?
OK, I've been playing with your (Charlie's) proposed code. With a slight modification I have
unread,
Array Formulas : how can I see the actual dynamic array formula?
OK, I've been playing with your (Charlie's) proposed code. With a slight modification I have
Jun 11
Chad Dale
, …
suresh S
3
Jun 11
formulas in workbook are being altered when saving
Hi I now about working the in python On Tue, Jun 11, 2024, 3:56 PM Charlie Clark <charlie.clark@
unread,
formulas in workbook are being altered when saving
Hi I now about working the in python On Tue, Jun 11, 2024, 3:56 PM Charlie Clark <charlie.clark@
Jun 11
Muskan Tolani
Jun 11
Learn data manipulation in flask
Hello, I want to learn data manipulation in flask can someone please give me link to free resources
unread,
Learn data manipulation in flask
Hello, I want to learn data manipulation in flask can someone please give me link to free resources
Jun 11
Marta lop seb
,
Charlie Clark
5
Jun 6
Problem with number formats
I am working on an automatization of a process to generate an excel with accountancy information. I
unread,
Problem with number formats
I am working on an automatization of a process to generate an excel with accountancy information. I
Jun 6
Marta lop seb
,
Charlie Clark
2
Jun 6
Problem with custom Conditional Formatting
On 5 Jun 2024, at 21:25, Marta lop seb wrote: Hello again! I have a question about how to do a custom
unread,
Problem with custom Conditional Formatting
On 5 Jun 2024, at 21:25, Marta lop seb wrote: Hello again! I have a question about how to do a custom
Jun 6
Bhavin Bhatt
,
pw wang
2
Jun 5
openpyxl textbox support in 3.1.2
Hi, Bhatt, I encounter same problem, and google leads me to you. looks like no solution so far? On
unread,
openpyxl textbox support in 3.1.2
Hi, Bhatt, I encounter same problem, and google leads me to you. looks like no solution so far? On
Jun 5
Maxwell Hernandez Canton
,
Charlie Clark
4
May 29
Developer access request - Header and Footer images feature
Hi Charlie, Thanks you , i was able to create the merge request with your instructions (mr : 451) ,
unread,
Developer access request - Header and Footer images feature
Hi Charlie, Thanks you , i was able to create the merge request with your instructions (mr : 451) ,
May 29
Sagar Nikesh
,
udif
2
May 23
Guidance on implementation
Yes, it can be done, as long as you need to process modern Excel files ("xlsx") and not the
unread,
Guidance on implementation
Yes, it can be done, as long as you need to process modern Excel files ("xlsx") and not the
May 23
Rafli Aulia Hafiz
,
Sagar Nikesh
2
May 23
openpyxl Doc
did you get any solution ? On Friday, January 5, 2024 at 8:50:18 AM UTC+5:30 Rafli Aulia Hafiz wrote:
unread,
openpyxl Doc
did you get any solution ? On Friday, January 5, 2024 at 8:50:18 AM UTC+5:30 Rafli Aulia Hafiz wrote:
May 23
Marc Daniele Lopez
May 19
Inserting picture in cell
Is there a way to insert an image into the a cell the same way you would do it in Excel by going to
unread,
Inserting picture in cell
Is there a way to insert an image into the a cell the same way you would do it in Excel by going to
May 19
Denis Bourouffala
, …
John Hendy
5
May 16
openpyxl problem Workbook contains no default style, apply openpyxl's default
That is indeed one approach, but why is this preferred vs. giving the user a way to say "I know
unread,
openpyxl problem Workbook contains no default style, apply openpyxl's default
That is indeed one approach, but why is this preferred vs. giving the user a way to say "I know
May 16
Michael O'Donnell
,
Charlie Clark
2
May 15
Merge request !345
On 15 May 2024, at 14:47, Michael O'Donnell wrote: > Hi, > > I have seen that merge
unread,
Merge request !345
On 15 May 2024, at 14:47, Michael O'Donnell wrote: > Hi, > > I have seen that merge
May 15
Yves Larbodiere
,
Charlie Clark
4
May 8
find the coordinates of the cell with a given value
On 8 May 2024, at 17:57, Yves Larbodiere wrote: > Valeur =Detail_col[(Detail_col['Col4']!=
unread,
find the coordinates of the cell with a given value
On 8 May 2024, at 17:57, Yves Larbodiere wrote: > Valeur =Detail_col[(Detail_col['Col4']!=
May 8
Walbers
, …
Charlie Clark
4
May 7
It only works after opening the file and saving it manually
On 6 May 2024, at 23:10, James Johnson wrote: > I debugged through the read_properties function
unread,
It only works after opening the file and saving it manually
On 6 May 2024, at 23:10, James Johnson wrote: > I debugged through the read_properties function
May 7
Angelo Corsaro
,
Charlie Clark
2
May 3
Update of Excel file
On 3 May 2024, at 8:42, Angelo Corsaro wrote: > Hi all, > I read some time ago the possibility
unread,
Update of Excel file
On 3 May 2024, at 8:42, Angelo Corsaro wrote: > Hi all, > I read some time ago the possibility
May 3
Yves Larbodiere
,
Charlie Clark
7
Apr 25
search coordinates of the current cell
Charlie, you're right. I went back over the code and reread the documentation to generate the
unread,
search coordinates of the current cell
Charlie, you're right. I went back over the code and reread the documentation to generate the
Apr 25
The Tester Boy
Apr 21
Insert formula using Openpyxl
In python: I am trying to insert this formula : =@FILTER(CP!$B$5:$B$13,(TDS_Conso_Summary!E2=CP!$A$5:
unread,
Insert formula using Openpyxl
In python: I am trying to insert this formula : =@FILTER(CP!$B$5:$B$13,(TDS_Conso_Summary!E2=CP!$A$5:
Apr 21
AN513
, …
The Tester Boy
8
Apr 21
Excel not opening my file when I try to write formulas using python
I am trying to insert this formula : =@FILTER(CP!$B$5:$B$13,(TDS_Conso_Summary!E2=CP!$A$5:$A$13)*(
unread,
Excel not opening my file when I try to write formulas using python
I am trying to insert this formula : =@FILTER(CP!$B$5:$B$13,(TDS_Conso_Summary!E2=CP!$A$5:$A$13)*(
Apr 21
Charlie Clark
,
Katende Francis
2
Apr 17
Re: [openpyxl-users] Urgent Call for Action: Request for Openpyxl Release to Address Critical Bugfixes
In Luganda we say, Abantu banyivu nyo! haha! On Wed, 17 Apr 2024 at 12:58, Charlie Clark <charlie.
unread,
Re: [openpyxl-users] Urgent Call for Action: Request for Openpyxl Release to Address Critical Bugfixes
In Luganda we say, Abantu banyivu nyo! haha! On Wed, 17 Apr 2024 at 12:58, Charlie Clark <charlie.
Apr 17
ni chunfeng
Apr 12
indirect functions are not compatible
After being read and written by openpyxl, the ordinary excel formula has become an array formula, and
unread,
indirect functions are not compatible
After being read and written by openpyxl, the ordinary excel formula has become an array formula, and
Apr 12
Andy Yee
, …
Charlie Clark
9
Apr 10
Saved .xslm file must be repaired to open; file loaded with keep_vba=true; only some radio button controls saved
On 10 Apr 2024, at 14:13, Markus Schmid wrote: > Hello All, > > how has this issue been
unread,
Saved .xslm file must be repaired to open; file loaded with keep_vba=true; only some radio button controls saved
On 10 Apr 2024, at 14:13, Markus Schmid wrote: > Hello All, > > how has this issue been
Apr 10
benneb...@gmail.com
, …
Parvateesam Naidu
8
Apr 8
ImportError: cannot import name 'Workbook'
You saved my time.. but if you chose openpyxl.py thats a poor choice. This may seem obvious... but
unread,
ImportError: cannot import name 'Workbook'
You saved my time.. but if you chose openpyxl.py thats a poor choice. This may seem obvious... but
Apr 8
useless.
, …
Laurent Martinez
4
Apr 3
get theme-dependant info about tables
Hello, I am looking for information how I can duplicate and customize a Table Style changing Header
unread,
get theme-dependant info about tables
Hello, I am looking for information how I can duplicate and customize a Table Style changing Header
Apr 3
Chichko Liobopitko
, …
Charles Gagnon
18
Mar 27
RichText problem with forward compatibility
It works ! Thanks ! On Wednesday, February 15, 2023 at 9:16:57 AM UTC-5 Benoit Blanchon wrote: Hi, I
unread,
RichText problem with forward compatibility
It works ! Thanks ! On Wednesday, February 15, 2023 at 9:16:57 AM UTC-5 Benoit Blanchon wrote: Hi, I
Mar 27