Groups
Sign in
Groups
openpyxl-users
Conversations
About
Send feedback
Help
openpyxl-users
Contact owners and managers
1–30 of 1278
Mark all as read
Report group
0 selected
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
Ago ni
Mar 20
unmerge_cells Exception
Hey, guys. I unmerge cells in the following way. merged_cells = ws.merged_cells for m_area in
unread,
unmerge_cells Exception
Hey, guys. I unmerge cells in the following way. merged_cells = ws.merged_cells for m_area in
Mar 20
Walbers
Mar 11
It only works after opening the file and saving it manually
"Hello everyone, I encountered an issue where after writing an Excel file and attempting to read
unread,
It only works after opening the file and saving it manually
"Hello everyone, I encountered an issue where after writing an Excel file and attempting to read
Mar 11
Yunusemre ŞAHİN
2
Feb 29
How To Protect My Excel File
My code is: wb = load_workbook(filename=file_path) ws = wb[sheet_name] ws[cell] = new_value wb.save(
unread,
How To Protect My Excel File
My code is: wb = load_workbook(filename=file_path) ws = wb[sheet_name] ws[cell] = new_value wb.save(
Feb 29
Denis Bourouffala
, …
Ivan Andy
4
Feb 19
PageBreak openpyxl
Good Morning I want to create two or more pagebreaks, but openpyxl ignore second and next. my code
unread,
PageBreak openpyxl
Good Morning I want to create two or more pagebreaks, but openpyxl ignore second and next. my code
Feb 19
Denis Bourouffala
,
Charlie Clark
4
Feb 1
openpyxl problem Workbook contains no default style, apply openpyxl's default
On 1 Feb 2024, at 10:44, Denis Bourouffala wrote: > Thank you > > How can I solve or remove
unread,
openpyxl problem Workbook contains no default style, apply openpyxl's default
On 1 Feb 2024, at 10:44, Denis Bourouffala wrote: > Thank you > > How can I solve or remove
Feb 1
ram s
Jan 9
Revised Benchlist
Hello all, I am from Devfi Inc, we have well experienced consultants who can join the project
unread,
Revised Benchlist
Hello all, I am from Devfi Inc, we have well experienced consultants who can join the project
Jan 9
Emma
2
Jan 5
How to encrpt .xlsx file from python
on linux ! (Centos) 2024년 1월 5일 금요일 오후 4시 37분 35초 UTC+9에 Emma님이 작성: Dear All, Can I know encrpting
unread,
How to encrpt .xlsx file from python
on linux ! (Centos) 2024년 1월 5일 금요일 오후 4시 37분 35초 UTC+9에 Emma님이 작성: Dear All, Can I know encrpting
Jan 5
Rafli Aulia Hafiz
Jan 4
openpyxl Doc
Hi guys, I need to insert some data from excel to an website. And I want to use openpyxl library but
unread,
openpyxl Doc
Hi guys, I need to insert some data from excel to an website. And I want to use openpyxl library but
Jan 4
Sido Brak
12/23/23
How to add rows from python dict based on colum names
I have excel with columns: name | col1 | col2 | col3 | col4 | col5 And I have dict: [ { "name
unread,
How to add rows from python dict based on colum names
I have excel with columns: name | col1 | col2 | col3 | col4 | col5 And I have dict: [ { "name
12/23/23
Emircan KILIÇ
12/9/23
openpyxl Documentation
Hi guys, I need to insert some data from web to an excel file. And I want to use openpyxl library but
unread,
openpyxl Documentation
Hi guys, I need to insert some data from web to an excel file. And I want to use openpyxl library but
12/9/23
Aman Verma
, …
Y. Taborda
5
11/27/23
openpyxl returns None for value actually present and updated in the created sheet.
How can I solve it if I have a linux machine? On Tuesday, July 7, 2020 at 12:41:40 AM UTC-5 agow...@
unread,
openpyxl returns None for value actually present and updated in the created sheet.
How can I solve it if I have a linux machine? On Tuesday, July 7, 2020 at 12:41:40 AM UTC-5 agow...@
11/27/23
Bhavin Bhatt
10/6/23
openpyxl textbox support in 3.1.2
Hello all, Am new to this community. I have a task to save an existing *.xlsx file with textbox
unread,
openpyxl textbox support in 3.1.2
Hello all, Am new to this community. I have a task to save an existing *.xlsx file with textbox
10/6/23
snoo...@gmail.com
,
sarmad ali Ali
2
9/30/23
Excel gives error on styles.xml
hellow may i know the jaunrauh On Monday, September 11, 2023 at 1:53:27 AM UTC+5 snoo...@gmail.com
unread,
Excel gives error on styles.xml
hellow may i know the jaunrauh On Monday, September 11, 2023 at 1:53:27 AM UTC+5 snoo...@gmail.com
9/30/23
Scott Barnes
,
Charlie Clark
2
9/18/23
Developer access request
On 16 Sep 2023, at 5:56, Scott Barnes wrote: > I recently created an account on Heptapod and would
unread,
Developer access request
On 16 Sep 2023, at 5:56, Scott Barnes wrote: > I recently created an account on Heptapod and would
9/18/23
Lee Don
,
Charlie Clark
6
8/30/23
Array formulae handling by excel on Mac?
On 30 Aug 2023, at 12:35, Lee Don wrote: > Thanks. I will try to find a Windows environment (I am
unread,
Array formulae handling by excel on Mac?
On 30 Aug 2023, at 12:35, Lee Don wrote: > Thanks. I will try to find a Windows environment (I am
8/30/23
Jose Lemos Cardoso
8/25/23
Python / Excel
Boa Tarde. Tenho uma folha excel onde pretendo ler uma coluna com cerca de 1500 linhas. Ao ler com o
unread,
Python / Excel
Boa Tarde. Tenho uma folha excel onde pretendo ler uma coluna com cerca de 1500 linhas. Ao ler com o
8/25/23
Jesse
8/24/23
Sheet/cell styling questions
Hello openpyxl folks, I have a handful of different styling questions (which probably all just boil
unread,
Sheet/cell styling questions
Hello openpyxl folks, I have a handful of different styling questions (which probably all just boil
8/24/23
Maksim Penguin
,
Charlie Clark
6
8/15/23
Why are different worksheet parents not allowed?
On 15 Aug 2023, at 16:00, Maksim Penguin wrote: > As I said I am asking with honest interest and
unread,
Why are different worksheet parents not allowed?
On 15 Aug 2023, at 16:00, Maksim Penguin wrote: > As I said I am asking with honest interest and
8/15/23
Darrell Reich
8/7/23
Excel error file not found with hyperlink using defined name
The code to create a hyperlink works. The code to create a defined name does not work when used in a
unread,
Excel error file not found with hyperlink using defined name
The code to create a hyperlink works. The code to create a defined name does not work when used in a
8/7/23
Darrell Reich
8/7/23
Docs typos: Defined Names
The example in the link below has two typos preventing it from working: * f-string missing "f
unread,
Docs typos: Defined Names
The example in the link below has two typos preventing it from working: * f-string missing "f
8/7/23