openpyxl-users

1–30 of 1229

0 selected

sza...@illinois.edu, … Justin Szaday11

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

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 Cobble2

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 Clark2

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

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

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

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

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

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 Clark4

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 Clark2

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 Clark4

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

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 Clark8

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 Clark3

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 Aziz10

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

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 Khamaganov7

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 Clark3

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 Clark10

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

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 Clark7

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 Patil10

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 Clark6

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 Garapati7

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 Clark3

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 Clark2

Jan 4

On 4 Jan 2023, at 12:14, udif wrote: > What is the expected release plan for 3.1 / 3.2? 3.1 should

unread,

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

Search

Clear search

Close search

Google apps

Main menu