python-excel

1–30 of 1277

0 selected

Anastasis Stathopoulos

12/24/21

Logic Functions don't work in openpyxl

Hey everyone, I am trying to automate something from excel and I need it to write some new IF

unread,

Logic Functions don't work in openpyxl

Hey everyone, I am trying to automate something from excel and I need it to write some new IF

12/24/21

Shubham Agrawal

1/22/21

Index out of range error in wb.save() in xlutils

Hi Guys, I am using "copy"function in xlutils to copy data from one workbook to another.

unread,

Index out of range error in wb.save() in xlutils

Hi Guys, I am using "copy"function in xlutils to copy data from one workbook to another.

1/22/21

Chris Withers, … Charlie Clark4

1/16/21

xlrd 2 released

On 16 Jan 2021, at 16:05, Chris Withers wrote: > xlsx files are made up of a zip file wrapping an

unread,

xlrd 2 released

On 16 Jan 2021, at 16:05, Chris Withers wrote: > xlsx files are made up of a zip file wrapping an

1/16/21

1/14/21

ANN: openpyxl 3.0.7 released

Hiya everyone, we're pleased to announce the release of openpyxl 3.0.7 This is a minor release

unread,

ANN: openpyxl 3.0.7 released

Hiya everyone, we're pleased to announce the release of openpyxl 3.0.7 This is a minor release

1/14/21

12/8/20

ANN: New SpreadSheet Formatter (ssf) packaged released to BETA

Hello all - just in time for the holidays - my ssf Number Format package is now available here: https

unread,

ANN: New SpreadSheet Formatter (ssf) packaged released to BETA

Hello all - just in time for the holidays - my ssf Number Format package is now available here: https

12/8/20

Joe Cool, John Yeung6

11/4/20

Please vote on my next project!

And the election results are in!! No, not THAT election - this one!! :-) On Sun, Nov 1, 2020 at 8:57

unread,

Please vote on my next project!

And the election results are in!! No, not THAT election - this one!! :-) On Sun, Nov 1, 2020 at 8:57

11/4/20

11/1/20

Re: [pyxl] Digest for python-excel@googlegroups.com - 1 update in 1 topic

So last time I checked it was a tie score, but now the openpyxl Rich Text has one more vote. I'll

unread,

Re: [pyxl] Digest for python-excel@googlegroups.com - 1 update in 1 topic

So last time I checked it was a tie score, but now the openpyxl Rich Text has one more vote. I'll

11/1/20

python...@raf.org, Joe Cool4

9/14/20

openpyxl: Why is 3 microseconds added to date/times?

Yeah maybe just round the values to the nearest millisecond or second or whatever resolution makes

unread,

openpyxl: Why is 3 microseconds added to date/times?

Yeah maybe just round the values to the nearest millisecond or second or whatever resolution makes

9/14/20

9/13/20

ANN: New xls2xlsx package released

Hello! Today I released a new package called xls2xlsx, which will convert files from xls, htm, and

unread,

ANN: New xls2xlsx package released

Hello! Today I released a new package called xls2xlsx, which will convert files from xls, htm, and

9/13/20

Deac-33 Lancaster, … Robert Silva28

8/18/20

Reading an Excel .xlsx file is extremely slow with openpyxl

Hi deac, seems you've it sorted now. Just wanted to share how I'm using openpyxl, and

unread,

Reading an Excel .xlsx file is extremely slow with openpyxl

Hi deac, seems you've it sorted now. Just wanted to share how I'm using openpyxl, and

8/18/20

Brian Field, Alfred Vachris2

6/28/20

Good Morning. You might want to take a look at https://newtonexcelbach.com/ Doug Jenkins has posted a

unread,

Good Morning. You might want to take a look at https://newtonexcelbach.com/ Doug Jenkins has posted a

6/28/20

Charlie Clark, … derek4

6/25/20

ANN: openpyxl 3.0.4 released

On 25 Jun 2020, at 8:04, derek wrote: > The https://foss.heptapod.net/openpyxl/openpyxl page is

unread,

ANN: openpyxl 3.0.4 released

On 25 Jun 2020, at 8:04, derek wrote: > The https://foss.heptapod.net/openpyxl/openpyxl page is

6/25/20

Felix Zumstein, Edward Sapp2

5/7/20

New hub for Excel/Python open-source projects: https://www.excelpython.org/

This is phenomenal. In the middle of replacing a monster model for my PE fund, believe this will come

unread,

New hub for Excel/Python open-source projects: https://www.excelpython.org/

This is phenomenal. In the middle of replacing a monster model for my PE fund, believe this will come

5/7/20

Deac Lancaster, … raf8

4/28/20

How can I read Excel .xls using xlrd to either fetch a floating point number as formatted in Excel or find the format Excel uses in the sheet?

Deac-33 Lancaster wrote: > Raf, > > I just asked if there's a way to use openpyxl to

unread,

How can I read Excel .xls using xlrd to either fetch a floating point number as formatted in Excel or find the format Excel uses in the sheet?

Deac-33 Lancaster wrote: > Raf, > > I just asked if there's a way to use openpyxl to

4/28/20

Scott Evans, Deac-33 Lancaster2

4/28/20

openpyxl - need help with a function to change cells to a text format (not General or Number or Dates) - like when you Right click on a cell to change formatting in excel

Scott, I'm sorry that no one has responded with suggestions, have you been able to resolve the

unread,

openpyxl - need help with a function to change cells to a text format (not General or Number or Dates) - like when you Right click on a cell to change formatting in excel

Scott, I'm sorry that no one has responded with suggestions, have you been able to resolve the

4/28/20

Viktor Kis, … John Yeung11

4/23/20

new light weight excel reader/writer - pylightxl

Hello everyone, Just following up on the status of pylighxl being added to the listed python-excel

unread,

new light weight excel reader/writer - pylightxl

Hello everyone, Just following up on the status of pylighxl being added to the listed python-excel

4/23/20

Angus King, Tony Roberts2

4/18/20

Another Python Excel package

Hi Angus, This is a great looking project! I'll take a closer look and add it to this blog post

unread,

Another Python Excel package

Hi Angus, This is a great looking project! I'll take a closer look and add it to this blog post

4/18/20

1/27/20

openpyxl leaving file open after reading?

hi, i've just come to the conclusion that openpyxl, when just reading an xlsx file, leaves it

unread,

openpyxl leaving file open after reading?

hi, i've just come to the conclusion that openpyxl, when just reading an xlsx file, leaves it

1/27/20

1/10/20

ANN: openpyxl 3.0.3 released

Hi everyone and a happy New Year, this is a brief announcement that openpyxl 3.0.3 has been released.

unread,

ANN: openpyxl 3.0.3 released

Hi everyone and a happy New Year, this is a brief announcement that openpyxl 3.0.3 has been released.

1/10/20

10/28/19

[Solved] Windows 10 | python3 setup.py install: error: can't create or remove files in install directory

I:\Python\xlwt\xlwt-1.3.0.tar\dist\xlwt-1.3.0>python3 setup.py install running install error: can

unread,

[Solved] Windows 10 | python3 setup.py install: error: can't create or remove files in install directory

I:\Python\xlwt\xlwt-1.3.0.tar\dist\xlwt-1.3.0>python3 setup.py install running install error: can

10/28/19

9/25/19

ANN: openpyxl 2.6.4 and 3.0.0 released

Dear all, this is an announcement of the joint release of openpyxl 2.6.4 and openpyxl 3.0.0. They

unread,

ANN: openpyxl 2.6.4 and 3.0.0 released

Dear all, this is an announcement of the joint release of openpyxl 2.6.4 and openpyxl 3.0.0. They

9/25/19

A S, Chris Wakibi2

9/25/19

Scan columns for keyword and extract all values in that column if the keyword is found in that column

Hi, You are supposed to loop through the column that has the "Keyword" you are referring to

unread,

Scan columns for keyword and extract all values in that column if the keyword is found in that column

Hi, You are supposed to loop through the column that has the "Keyword" you are referring to

9/25/19

7/19/19

xlutils.copy changing celll colors

Hi, friends. I'm trying to edit .xls file with xlutils and i have some issue that i can't

unread,

xlutils.copy changing celll colors

Hi, friends. I'm trying to edit .xls file with xlutils and i have some issue that i can't

7/19/19

S2H, Scott Evans2

7/15/19

Looking for a way to Merge specific rows on 2 different excel files - use Workbook 1 to find value in Workbook 2, and if it exists, copy specific cells over to workbook 2

I was able to solve this updated code below # open both files, load them in, orig_wb = load_workbook(

unread,

Looking for a way to Merge specific rows on 2 different excel files - use Workbook 1 to find value in Workbook 2, and if it exists, copy specific cells over to workbook 2

I was able to solve this updated code below # open both files, load them in, orig_wb = load_workbook(

7/15/19

Luis Durani, Charlie Clark2

7/9/19

Openpyxl - Slicer

Am .07.2019, 02:47 Uhr, schrieb Luis Durani <durani2424@gmail.com>: > Hello All, > > I

unread,

Openpyxl - Slicer

Am .07.2019, 02:47 Uhr, schrieb Luis Durani <durani2424@gmail.com>: > Hello All, > > I

7/9/19

MS, python...@raf.org5

5/21/19

Read cell number format on .xlsx files

MS wrote: > Yes I'm talking about xlrd. > > The problem I have is that I need to check

unread,

Read cell number format on .xlsx files

MS wrote: > Yes I'm talking about xlrd. > > The problem I have is that I need to check

5/21/19

Randolph Finder, derek2

3/1/19

reading csv's into template xml/xlsx

I'd probably tackle it using openpyxl -- here is a discussion about how to copy/re-use formats

unread,

reading csv's into template xml/xlsx

I'd probably tackle it using openpyxl -- here is a discussion about how to copy/re-use formats

3/1/19

2/25/19

Re: John Machin has retired

Many, many thanks to John for long and excellent service to the Python community. On Sun, 24 Feb 2019

unread,

Re: John Machin has retired

Many, many thanks to John for long and excellent service to the Python community. On Sun, 24 Feb 2019

2/25/19

2/22/19

John Machin has retired

Please don't expect answers to messages addressed to my private email address that request help

unread,locked,

John Machin has retired

Please don't expect answers to messages addressed to my private email address that request help

2/22/19

Rostislav Aleev

2/12/19

xlrd get info about font

I use xlrd/xlutils/xlwt to edit existing workbook. I have an issue with datetime cells (numeric '

unread,

xlrd get info about font

I use xlrd/xlutils/xlwt to edit existing workbook. I have an issue with datetime cells (numeric '

2/12/19

Search

Clear search

Close search

Google apps

Main menu