Groups
Conversations
All groups and messages
Send feedback to Google
Help
Sign in
Groups
openpyxl-users
Conversations
About
openpyxl-users
1–30 of 1242
Mark all as read
Report abusive group
0 selected
Avy Faingezicht
,
Charlie Clark
2
May 25
Formula reference tree extraction
On 25 May 2023, at 0:32, Avy Faingezicht wrote: > Hello, > > I'm a new user of the
unread,
Formula reference tree extraction
On 25 May 2023, at 0:32, Avy Faingezicht wrote: > Hello, > > I'm a new user of the
May 25
Prady A
May 15
Excel Automation help
Hi Experts, Beginner to Python modules. Please suggest I ve an excel template file having a header
unread,
Excel Automation help
Hi Experts, Beginner to Python modules. Please suggest I ve an excel template file having a header
May 15
Roger C
,
Charlie Clark
2
May 15
It ought to be possible to set default font for a workbook.
On 13 May 2023, at 20:30, Roger C wrote: > I think it ought to be possible to set the default font
unread,
It ought to be possible to set default font for a workbook.
On 13 May 2023, at 20:30, Roger C wrote: > I think it ought to be possible to set the default font
May 15
Larry FastCA
2
May 11
How to set a chart series title to a cell Reference instead of cell value?
Got an answer from stackoverflow from openpyxl.chart.series import Series, SeriesLabel from openpyxl.
unread,
How to set a chart series title to a cell Reference instead of cell value?
Got an answer from stackoverflow from openpyxl.chart.series import Series, SeriesLabel from openpyxl.
May 11
Prady A
May 8
could not able to install openpyxl
Hi, Greetings!! This is first time posting in this group. I am trying to install openpyxl but it is
unread,
could not able to install openpyxl
Hi, Greetings!! This is first time posting in this group. I am trying to install openpyxl but it is
May 8
zabih dawar
,
Udi Finkelstein
3
May 5
How I resolve the issue of getting error when I run the command "pip install openpyxl".
Yes, I installed Python and I got the error at that time now I have solved this problem by
unread,
How I resolve the issue of getting error when I run the command "pip install openpyxl".
Yes, I installed Python and I got the error at that time now I have solved this problem by
May 5
Abdulkareem Alghannam
Apr 25
how can delete a row in Exel by using a value of cell as row reference?
how can delete a row in Exel by using a value of cell as row reference?
unread,
how can delete a row in Exel by using a value of cell as row reference?
how can delete a row in Exel by using a value of cell as row reference?
Apr 25
Richard David
Apr 24
How do I clear an incorrect error message using openpyxl?
I'm using openpyxl to write a formula to an Excel workbook. The formula generates the error
unread,
How do I clear an incorrect error message using openpyxl?
I'm using openpyxl to write a formula to an Excel workbook. The formula generates the error
Apr 24
Roberto Sandoval
, …
Charlie Clark
4
Apr 19
RichText - Cell Formatting
On 22 Mar 2023, at 17:34, Udi Finkelstein wrote: > Yes, install lxml. > pip install lxml >
unread,
RichText - Cell Formatting
On 22 Mar 2023, at 17:34, Udi Finkelstein wrote: > Yes, install lxml. > pip install lxml >
Apr 19
Romain Lhotte
,
Charlie Clark
7
Apr 15
Degrouping column loses formatting and formatting whole columns cannot be re-applied
On 14 Apr 2023, at 15:08, Romain Lhotte wrote: > I would also add that indeed this notion of
unread,
Degrouping column loses formatting and formatting whole columns cannot be re-applied
On 14 Apr 2023, at 15:08, Romain Lhotte wrote: > I would also add that indeed this notion of
Apr 15
Aryn Yklas
Mar 31
Don't save formulas created and saved by formula manager
openpyxl don't save formulas created and saved by formula manager
unread,
Don't save formulas created and saved by formula manager
openpyxl don't save formulas created and saved by formula manager
Mar 31
Vyacheslav Vyacheslav
Mar 24
how to add data series lines in chart?
how to add data series lines in chart?
unread,
how to add data series lines in chart?
how to add data series lines in chart?
Mar 24
Вячеслав Вячеслав
2
Mar 23
How can I change the font, size, and color of text in charts?
s1 = chart1.series[0] s1.dLbls = DataLabelList() s1.dLbls.showVal = True s1.dLbls.dLblPos = 'ctr
unread,
How can I change the font, size, and color of text in charts?
s1 = chart1.series[0] s1.dLbls = DataLabelList() s1.dLbls.showVal = True s1.dLbls.dLblPos = 'ctr
Mar 23
Vyacheslav Vyacheslav
Mar 23
How do I align the values in the middle of the chart columns?
How do I align the values in the middle of the chart columns?
unread,
How do I align the values in the middle of the chart columns?
How do I align the values in the middle of the chart columns?
Mar 23
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
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