openpyxl-users

1–30 of 1107

0 selected

Sep 23

Python Process Killed while writing excel file with 900K rows in a Sheet

Can anyone please help with this issue? On Wednesday, September 15, 2021 at 12:59:09 PM UTC+2 Sathish

unread,

Python Process Killed while writing excel file with 900K rows in a Sheet

Can anyone please help with this issue? On Wednesday, September 15, 2021 at 12:59:09 PM UTC+2 Sathish

Sep 23

Sep 15

openpyxl-users@googlegroups.com

Dear openpyxl-users, Support Centre has sent you a protected message due to an Abuse Report. Verify

unread,

openpyxl-users@googlegroups.com

Dear openpyxl-users, Support Centre has sent you a protected message due to an Abuse Report. Verify

Sep 15

Sep 14

ValueError: could not convert string to float: '*leeg*'

Hi All, I have found that openpyxl version 3.0.8 is giving this error, downgraded to 3.0.7 and its

unread,

ValueError: could not convert string to float: '*leeg*'

Hi All, I have found that openpyxl version 3.0.8 is giving this error, downgraded to 3.0.7 and its

Sep 14

Rameez ali, Charlie Clark3

Sep 10

Border diagonals

Thanks, Charlie. On Friday, 10 September 2021 at 04:53:21 UTC-4 charli...@clark-consulting.eu wrote:

unread,

Border diagonals

Thanks, Charlie. On Friday, 10 September 2021 at 04:53:21 UTC-4 charli...@clark-consulting.eu wrote:

Sep 10

c.b...@posteo.jp, … Charlie Clark3

Sep 9

Expand columns to needed width

On 9 Sep 2021, at 15:02, c.buhtz@posteo.jp wrote: > Hello together, > > I create xlsx-files

unread,

Expand columns to needed width

On 9 Sep 2021, at 15:02, c.buhtz@posteo.jp wrote: > Hello together, > > I create xlsx-files

Sep 9

Polly, Charlie Clark2

Sep 9

What is unit for column width?

On 9 Sep 2021, at 15:11, Polly wrote: > Hi, > > After lots of digging around in the code and

unread,

What is unit for column width?

On 9 Sep 2021, at 15:11, Polly wrote: > Hi, > > After lots of digging around in the code and

Sep 9

Hongyi Zhao, Charlie Clark3

Sep 8

combine multiple xlsx files which include dropdown columns in them.

On Wednesday, September 8, 2021 at 4:00:33 PM UTC+8 charli...@clark-consulting.eu wrote: On 8 Sep

unread,

combine multiple xlsx files which include dropdown columns in them.

On Wednesday, September 8, 2021 at 4:00:33 PM UTC+8 charli...@clark-consulting.eu wrote: On 8 Sep

Sep 8

Sathish Kumar, Charlie Clark2

Sep 8

ValueError: Value must be one of {'field', 'selection', 'data'}

On 8 Sep 2021, at 10:55, Sathish Kumar wrote: > Hi All, > > Good day!! > > When trying

unread,

ValueError: Value must be one of {'field', 'selection', 'data'}

On 8 Sep 2021, at 10:55, Sathish Kumar wrote: > Hi All, > > Good day!! > > When trying

Sep 8

Shohei Nagata, Charlie Clark3

Sep 6

How to open .xlsx file from binary data?

Hi Charlie, Thank you so much for your replying. I tried BytesIO and the codes started to work well :

unread,

How to open .xlsx file from binary data?

Hi Charlie, Thank you so much for your replying. I tried BytesIO and the codes started to work well :

Sep 6

Kent Gang, … Charlie Clark4

Sep 4

Request for 3.0.8 release

On 4 Sep 2021, at 8:01, Yash Jhunjhunwala wrote: > Hi, is there any update on the 3.1 release or

unread,

Request for 3.0.8 release

On 4 Sep 2021, at 8:01, Yash Jhunjhunwala wrote: > Hi, is there any update on the 3.1 release or

Sep 4

Sep 1

Revised benchlist

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

unread,

Revised benchlist

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

Sep 1

Sep 1

Are cell width and height in pixels easily available?

Hi, Team! I see the following xml information for an excel sheet (after decompression): <?xml

unread,

Are cell width and height in pixels easily available?

Hi, Team! I see the following xml information for an excel sheet (after decompression): <?xml

Sep 1

Aug 30

Revised Benchlist

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

unread,

Revised Benchlist

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

Aug 30

Aug 30

Error when opening Excel file generated by openpyxl

Hi, The attached Excel file was generated with openpyxl (version 3.0.6). When opening this file in

unread,

Error when opening Excel file generated by openpyxl

Hi, The attached Excel file was generated with openpyxl (version 3.0.6). When opening this file in

Aug 30

Aug 25

Anyone else with this problem? Conditional Formatting fails only for MS Excel

Hey there, I read on heptapod that I should come here :D I've opened this issue quite some months

unread,

Anyone else with this problem? Conditional Formatting fails only for MS Excel

Hey there, I read on heptapod that I should come here :D I've opened this issue quite some months

Aug 25

Denis Bourouffala, Charlie Clark2

Aug 23

Resizing Existing Picture in xlsx files

On 21 Aug 2021, at 17:13, Denis Bourouffala wrote: > Good Morning, > > I want to resize

unread,

Resizing Existing Picture in xlsx files

On 21 Aug 2021, at 17:13, Denis Bourouffala wrote: > Good Morning, > > I want to resize

Aug 23

Aug 20

Revised benchlist

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

unread,

Revised benchlist

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

Aug 20

STV June, Charlie Clark2

Aug 18

How to Find and highlight text, then delete shift cells up in openpyxl ?

On 18 Aug 2021, at 15:42, STV June wrote: > Hello I am new to openpyxl. > > Can anyone know

unread,

How to Find and highlight text, then delete shift cells up in openpyxl ?

On 18 Aug 2021, at 15:42, STV June wrote: > Hello I am new to openpyxl. > > Can anyone know

Aug 18

Rameez ali, Charlie Clark8

Aug 13

new named ranges are not written to the file

On 12 Aug 2021, at 21:38, Rameez ali wrote: Just found the solution, If DefinedName object has space

unread,

new named ranges are not written to the file

On 12 Aug 2021, at 21:38, Rameez ali wrote: Just found the solution, If DefinedName object has space

Aug 13

Aug 11

Openpyxl copy ColorScaleRule conditional formatting based on a reference cell/range?

Hi, I was wondering if anyone could help me figure out what I need to do in order to “copy” the

unread,

Openpyxl copy ColorScaleRule conditional formatting based on a reference cell/range?

Hi, I was wondering if anyone could help me figure out what I need to do in order to “copy” the

Aug 11

Aug 5

Re: [openpyxl-users] import spreadsheet integer vs character

On 5 Aug 2021, at 3:26, Rockie Brockway wrote: If I import a spreadsheet through openpyxl that is

unread,

Re: [openpyxl-users] import spreadsheet integer vs character

On 5 Aug 2021, at 3:26, Rockie Brockway wrote: If I import a spreadsheet through openpyxl that is

Aug 5

Aug 4

revised bench list

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

unread,

revised bench list

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

Aug 4

Paul Leopard, Charlie Clark2

Aug 3

Openpyxl version 3.0.7 Workbook.create_chartsheet() issue

On 3 Aug 2021, at 15:45, Paul Leopard wrote: > I've got an issue with the Workbook.

unread,

Openpyxl version 3.0.7 Workbook.create_chartsheet() issue

On 3 Aug 2021, at 15:45, Paul Leopard wrote: > I've got an issue with the Workbook.

Aug 3

Aug 2

Revised Benchlist

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

unread,

Revised Benchlist

Good Morning, Wishing you are safe and healthy from IT Pindits Inc, we have well experienced

Aug 2

Alexey Elfimov, Charlie Clark4

Jul 23

The speed of filling the background of cells through the fill field

On 22 Jul 2021, at 14:35, Alexey Elfimov wrote: > [image: 20210722_153347.jpg] > > Rewrote

unread,

The speed of filling the background of cells through the fill field

On 22 Jul 2021, at 14:35, Alexey Elfimov wrote: > [image: 20210722_153347.jpg] > > Rewrote

Jul 23

Manuel Cancino, … Charlie Clark4

Jul 20

INSTALL FOR RASPBERRY

On 20 Jul 2021, at 18:27, Lucas wrote: How do you install on Raspberry Pi? Same as on any other

unread,

INSTALL FOR RASPBERRY

On 20 Jul 2021, at 18:27, Lucas wrote: How do you install on Raspberry Pi? Same as on any other

Jul 20

Sheldon Cooper, Charlie Clark6

Jul 19

openpyxl changes the format of the saved file

On 19 Jul 2021, at 18:10, Sheldon Cooper wrote: > The same work I do with python (manipulating

unread,

openpyxl changes the format of the saved file

On 19 Jul 2021, at 18:10, Sheldon Cooper wrote: > The same work I do with python (manipulating

Jul 19

shirish bhalekar, SNoOK SP2

Jul 19

openyxl prints formula than its data or none

Have to use xlwings library to get values of formula On Monday, May 3, 2021 at 6:57:29 PM UTC+7

unread,

openyxl prints formula than its data or none

Have to use xlwings library to get values of formula On Monday, May 3, 2021 at 6:57:29 PM UTC+7

Jul 19

Xavier Morel, Charlie Clark3

Jul 9

What is the correct way to interact with a formula / error cell when reading?

Cells have a data_type attribute which contains a typecode, however the symbolic names (constants)

unread,

What is the correct way to interact with a formula / error cell when reading?

Cells have a data_type attribute which contains a typecode, however the symbolic names (constants)

Jul 9

Jul 6

安装openpyxl2.6版本。有个问题需要咨询你。发自我的iPhone

unread,

安装openpyxl2.6版本。有个问题需要咨询你。发自我的iPhone

Jul 6

Search

Clear search

Close search

Google apps

Main menu