Groups
Conversations
All groups and messages
Send feedback to Google
Help
Sign in
Groups
openpyxl-users
Conversations
About
openpyxl-users
1–30 of 1229
Mark all as read
Report abusive group
0 selected
sza...@illinois.edu
, …
Justin Szaday
11
Mar 21
Use Values From Cells as Data Labels for Scatter Chart
Unfortunately, this was for a project at a past employer, and I no longer recall the alternative I
unread,
Use Values From Cells as Data Labels for Scatter Chart
Unfortunately, this was for a project at a past employer, and I no longer recall the alternative I
Mar 21
Santiago Rossetti
Mar 21
Excel file Breaking links after open and saving
Im using openpyxl to open an excel file pasting data on some pages by the sheet.cell() method and the
unread,
Excel file Breaking links after open and saving
Im using openpyxl to open an excel file pasting data on some pages by the sheet.cell() method and the
Mar 21
Oviyaa M
Mar 20
How to check password protection is enabled in excel
Hi all, I want to know to do we check whether excel file is protected or not. Could be passowrd
unread,
How to check password protection is enabled in excel
Hi all, I want to know to do we check whether excel file is protected or not. Could be passowrd
Mar 20
David Tyler
,
Jason Cobble
2
Mar 19
Same border side returning different styles
cause you're a faggot! On Wed, Mar 15, 2023 at 11:01 AM David Tyler <bdt...@gmail.com>
unread,
Same border side returning different styles
cause you're a faggot! On Wed, Mar 15, 2023 at 11:01 AM David Tyler <bdt...@gmail.com>
Mar 19
philippe pecqueur
,
Charlie Clark
2
Mar 19
replace th point by the commas how seprator of decimal
On 18 Mar 2023, at 19:36, philippe pecqueur wrote: > Dear all, > Maybe you can help my > I
unread,
replace th point by the commas how seprator of decimal
On 18 Mar 2023, at 19:36, philippe pecqueur wrote: > Dear all, > Maybe you can help my > I
Mar 19
Charlie Clark
Mar 16
ANN: Python Düsseldorf Sprint, March 25th & 26th
Hi everyone, just a quick note that our local user group is holding a Python sprint at the end of
unread,
ANN: Python Düsseldorf Sprint, March 25th & 26th
Hi everyone, just a quick note that our local user group is holding a Python sprint at the end of
Mar 16
qiniso fortune
Mar 14
Installing openpyxl layer in lambda function ERROR
Hi Please assist I am new. I was attempting to install openpyxl layer in lambda function, Python 3.9
unread,
Installing openpyxl layer in lambda function ERROR
Hi Please assist I am new. I was attempting to install openpyxl layer in lambda function, Python 3.9
Mar 14
Charlie Clark
Mar 11
ANN: openpyxl 3.1.2 released
Hiya everyone, just letting you know that I've just released version 3.1.2. This is a bug fix
unread,
ANN: openpyxl 3.1.2 released
Hiya everyone, just letting you know that I've just released version 3.1.2. This is a bug fix
Mar 11
vaibhav chavan
Mar 1
AttributeError: 'ReadOnlyWorksheet' object has no attribute 'defined_names'
Hello Charlie Clark, below two python statement throwing the error --> AttributeError: '
unread,
AttributeError: 'ReadOnlyWorksheet' object has no attribute 'defined_names'
Hello Charlie Clark, below two python statement throwing the error --> AttributeError: '
Mar 1
Вячеслав Вячеслав
Feb 28
How can I change the font, size, and color of text in charts?
How can I change the font, size, and color of text in charts?
unread,
How can I change the font, size, and color of text in charts?
How can I change the font, size, and color of text in charts?
Feb 28
Jordan D'Addeo
Feb 27
Invalid File Specification error
I've been using openpyxl to open and process .xlsx files output by some scientific equipment.
unread,
Invalid File Specification error
I've been using openpyxl to open and process .xlsx files output by some scientific equipment.
Feb 27
Jordan Verhofstadt
,
Charlie Clark
4
Feb 21
Borders not saving
Just resolved the issue. This comes from the MS office version, my company has to update it Thanks
unread,
Borders not saving
Just resolved the issue. This comes from the MS office version, my company has to update it Thanks
Feb 21
prakash kademani
,
Charlie Clark
2
Feb 21
Error while importing Openpyxl
On 21 Feb 2023, at 15:37, prakash kademani wrote: > 1. In some forum i see the openpyxl 2.6.4 is
unread,
Error while importing Openpyxl
On 21 Feb 2023, at 15:37, prakash kademani wrote: > 1. In some forum i see the openpyxl 2.6.4 is
Feb 21
Matthew Hegarty
,
Charlie Clark
4
Feb 21
Secure write of formulas
On 21 Feb 2023, at 14:48, Matthew Hegarty wrote: > Hi Charlie > > Thanks for the quick
unread,
Secure write of formulas
On 21 Feb 2023, at 14:48, Matthew Hegarty wrote: > Hi Charlie > > Thanks for the quick
Feb 21
Chichko Liobopitko
, …
蔡皓宇
16
Feb 15
RichText problem with forward compatibility
It works. Thank you very much. Moved to cry! :) 在2023年2月15日星期三 UTC+8 22:16:57<Benoit Blanchon>
unread,
RichText problem with forward compatibility
It works. Thank you very much. Moved to cry! :) 在2023年2月15日星期三 UTC+8 22:16:57<Benoit Blanchon>
Feb 15
Charlie Clark
Feb 13
ANN: Openpyxl 3.1.1 released
Hi everyone, I'm pleased to announce that 3.1.1 has been released. This is a minor bugfix release
unread,
ANN: Openpyxl 3.1.1 released
Hi everyone, I'm pleased to announce that 3.1.1 has been released. This is a minor bugfix release
Feb 13
Dave
, …
Charlie Clark
8
Feb 13
Using Excel's external data connection with openpyxl
On 13 Feb 2023, at 4:44, Barry Penner wrote: > I did go poking around in the source code, though,
unread,
Using Excel's external data connection with openpyxl
On 13 Feb 2023, at 4:44, Barry Penner wrote: > I did go poking around in the source code, though,
Feb 13
KrisC
,
Charlie Clark
3
Feb 10
AttributeError: 'Worksheet' object has no attribute 'formula_attributes'
Many thanks for your help! Charlie Clark <charli...@clark-consulting.eu>於 2023年2月10日 週五,下午8
unread,
AttributeError: 'Worksheet' object has no attribute 'formula_attributes'
Many thanks for your help! Charlie Clark <charli...@clark-consulting.eu>於 2023年2月10日 週五,下午8
Feb 10
tobias....@gmail.com
, …
Suleman Aziz
10
Feb 7
Is there an efficient way to read named ranges from Excel into Python?
I'm able to make it work with the following code. I'm not sure if this is the most optimized
unread,
Is there an efficient way to read named ranges from Excel into Python?
I'm able to make it work with the following code. I'm not sure if this is the most optimized
Feb 7
Vikram Samak
Feb 5
How to separate categories in barchart3d ?
i want to separate categories of this chart how can do that ?
unread,
How to separate categories in barchart3d ?
i want to separate categories of this chart how can do that ?
Feb 5
benneb...@gmail.com
, …
Alexander Khamaganov
7
Feb 3
ImportError: cannot import name 'Workbook'
You best of the best!!!) четверг, 4 февраля 2021 г. в 03:35:36 UTC+2, Pedro Dardengo Mesquita: This
unread,
ImportError: cannot import name 'Workbook'
You best of the best!!!) четверг, 4 февраля 2021 г. в 03:35:36 UTC+2, Pedro Dardengo Mesquita: This
Feb 3
Ilnur Khairullin (IkeKazan)
,
Charlie Clark
3
Feb 2
Can not access Worksheet Defined Names in openpyxl 3.1.0
No worries. It is good that you have found the reason. I'm glad I was able to help find the bug
unread,
Can not access Worksheet Defined Names in openpyxl 3.1.0
No worries. It is good that you have found the reason. I'm glad I was able to help find the bug
Feb 2
Marco Baggio
, …
Charlie Clark
10
Feb 1
python 3.9 and opepyxl : Error "zipfile.BadZipFile: File is not a zip file"
On 1 Feb 2023, at 4:24, Ovin Gamage wrote: > I had the same issue. Running a code to compare 2
unread,
python 3.9 and opepyxl : Error "zipfile.BadZipFile: File is not a zip file"
On 1 Feb 2023, at 4:24, Ovin Gamage wrote: > I had the same issue. Running a code to compare 2
Feb 1
Charlie Clark
Jan 31
ANN: Openpyxl 3.1 released
Dear all, I'm pleased to announce that Openpyxl 3.1 has finally been released. It's been a
unread,
ANN: Openpyxl 3.1 released
Dear all, I'm pleased to announce that Openpyxl 3.1 has finally been released. It's been a
Jan 31
Mathias Cuypers
,
Charlie Clark
7
Jan 16
Data Validation / INDIRECT
On 16 Jan 2023, at 10:59, 'Mathias Cuypers' via openpyxl-users wrote: > Hi, > >
unread,
Data Validation / INDIRECT
On 16 Jan 2023, at 10:59, 'Mathias Cuypers' via openpyxl-users wrote: > Hi, > >
Jan 16
Rania Labib
, …
Sagar Patil
10
Jan 16
appending lists to an existing file starting from a specific cells
Hello Charlie I have to do same appending lists in existing file im new in openpyxl library so could
unread,
appending lists to an existing file starting from a specific cells
Hello Charlie I have to do same appending lists in existing file im new in openpyxl library so could
Jan 16
Rahul Pandey
, …
Charlie Clark
6
Jan 13
No module named 'openpyxl'
On 13 Jan 2023, at 14:06, 'Rahul Pandey' via openpyxl-users wrote: > I have solved the
unread,
No module named 'openpyxl'
On 13 Jan 2023, at 14:06, 'Rahul Pandey' via openpyxl-users wrote: > I have solved the
Jan 13
janain...@gmail.com
, …
Murali Mohan Garapati
7
Jan 11
Problem with Excel files saved with openpyxl
Hi, Did you see any solution for this? I am facing the same issue, it will be great if you can help
unread,
Problem with Excel files saved with openpyxl
Hi, Did you see any solution for this? I am facing the same issue, it will be great if you can help
Jan 11
snoo...@gmail.com
,
Charlie Clark
3
Jan 6
is_date_format gives incorrect results
I put the replacement function in my xls2xlsx: https://xls2xlsx.readthedocs.io/en/latest/_modules/
unread,
is_date_format gives incorrect results
I put the replacement function in my xls2xlsx: https://xls2xlsx.readthedocs.io/en/latest/_modules/
Jan 6
udif
,
Charlie Clark
2
Jan 4
Release plan
On 4 Jan 2023, at 12:14, udif wrote: > What is the expected release plan for 3.1 / 3.2? 3.1 should
unread,
Release plan
On 4 Jan 2023, at 12:14, udif wrote: > What is the expected release plan for 3.1 / 3.2? 3.1 should
Jan 4