python-excel - Google Groups (original) (raw)

0 selected

John Machin's profile photo

John Machin

2/22/19

AnnouncementJohn Machin has retiredPlease don't expect answers to messages addressed to my private email address that request help

unread,locked,

AnnouncementJohn Machin has retiredPlease don't expect answers to messages addressed to my private email address that request help

2/22/19

Sarah Ritterspach's profile photo

Sarah Ritterspach

6/9/23

.bat failing with Task SchedulerHi, all! I have a .bat file that I've set up to run on my machine via the native Task Scheduler.

unread,

.bat failing with Task SchedulerHi, all! I have a .bat file that I've set up to run on my machine via the native Task Scheduler.

6/9/23

Joe Cool's profile photo

Joe Cool

1/6/23

xlx2xlsx 0.2.0 releasedGreetings! I'm happy to report that I released a new version of xls2xlsx. It's been

unread,

xlx2xlsx 0.2.0 releasedGreetings! I'm happy to report that I released a new version of xls2xlsx. It's been

1/6/23

richard shen's profile photo

richard shen, Charlie Clark2

9/7/22

Workbook need check list index whether out of range in get_biff_data()On 3 Sep 2022, at 7:04, richard shen wrote: > As the xlwt repository is real-only now, I give the

unread,

Workbook need check list index whether out of range in get_biff_data()On 3 Sep 2022, at 7:04, richard shen wrote: > As the xlwt repository is real-only now, I give the

9/7/22

Alexander Zverev's profile photo

Alexander Zverev2

6/7/22

Wrong background color after xlutils.copyIf someone interested, I solved this by redefining method _Workbook__palette_rec of object with

unread,

Wrong background color after xlutils.copyIf someone interested, I solved this by redefining method _Workbook__palette_rec of object with

6/7/22

Charlie Clark's profile photo

Charlie Clark

5/19/22

ANN: Openpyxl 3.0.10 releasedHiya everyone, this is a brief announcement that Openpyxl 3.0.10 has been released. This is bugfix

unread,

ANN: Openpyxl 3.0.10 releasedHiya everyone, this is a brief announcement that Openpyxl 3.0.10 has been released. This is bugfix

5/19/22

Anastasis Stathopoulos's profile photo

Anastasis Stathopoulos

12/24/21

Logic Functions don't work in openpyxlHey 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 openpyxlHey everyone, I am trying to automate something from excel and I need it to write some new IF

12/24/21

Shubham Agrawal's profile photo

Shubham Agrawal

1/22/21

Index out of range error in wb.save() in xlutilsHi 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 xlutilsHi Guys, I am using "copy"function in xlutils to copy data from one workbook to another.

1/22/21

Chris Withers's profile photo

Chris Withers, … Charlie Clark4

1/16/21

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

unread,

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

1/16/21

Charlie Clark's profile photo

Charlie Clark

1/14/21

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

unread,

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

1/14/21

Joe Cool's profile photo

Joe Cool2

12/8/20

ANN: New SpreadSheet Formatter (ssf) packaged released to BETAHello 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 BETAHello all - just in time for the holidays - my ssf Number Format package is now available here: https

12/8/20

Joe Cool's profile photo

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

Joe Cool's profile photo

Joe Cool

11/1/20

Re: [pyxl] Digest for python-excel@googlegroups.com - 1 update in 1 topicSo 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 topicSo 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's profile photo

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

Joe Cool's profile photo

Joe Cool

9/13/20

ANN: New xls2xlsx package releasedHello! Today I released a new package called xls2xlsx, which will convert files from xls, htm, and

unread,

ANN: New xls2xlsx package releasedHello! Today I released a new package called xls2xlsx, which will convert files from xls, htm, and

9/13/20

Deac-33 Lancaster's profile photo

Deac-33 Lancaster, … Robert Silva28

8/18/20

Reading an Excel .xlsx file is extremely slow with openpyxlHi 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 openpyxlHi deac, seems you've it sorted now. Just wanted to share how I'm using openpyxl, and

8/18/20

Brian Field's profile photo

Brian Field, Alfred Vachris2

6/28/20

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

unread,

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

6/28/20

Charlie Clark's profile photo

Charlie Clark, … derek4

6/25/20

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

unread,

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

6/25/20

Felix Zumstein's profile photo

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's profile photo

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's profile photo

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 excelScott, 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 excelScott, I'm sorry that no one has responded with suggestions, have you been able to resolve the

4/28/20

Viktor Kis's profile photo

Viktor Kis, … John Yeung11

4/23/20

new light weight excel reader/writer - pylightxlHello everyone, Just following up on the status of pylighxl being added to the listed python-excel

unread,

new light weight excel reader/writer - pylightxlHello everyone, Just following up on the status of pylighxl being added to the listed python-excel

4/23/20

Angus King's profile photo

Angus King, Tony Roberts2

4/18/20

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

unread,

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

4/18/20

raf's profile photo

raf

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

Charlie Clark's profile photo

Charlie Clark

1/10/20

ANN: openpyxl 3.0.3 releasedHi 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 releasedHi everyone and a happy New Year, this is a brief announcement that openpyxl 3.0.3 has been released.

1/10/20

R's profile photo

R

10/28/19

[Solved] Windows 10 | python3 setup.py install: error: can't create or remove files in install directoryI:\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 directoryI:\Python\xlwt\xlwt-1.3.0.tar\dist\xlwt-1.3.0>python3 setup.py install running install error: can

10/28/19

Charlie Clark's profile photo

Charlie Clark

9/25/19

ANN: openpyxl 2.6.4 and 3.0.0 releasedDear 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 releasedDear 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's profile photo

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 columnHi, 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 columnHi, You are supposed to loop through the column that has the "Keyword" you are referring to

9/25/19

Daler Boboev's profile photo

Daler Boboev

7/19/19

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

unread,

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

7/19/19

S2H's profile photo

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 2I 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 2I was able to solve this updated code below # open both files, load them in, orig_wb = load_workbook(

7/15/19

Luis Durani's profile photo

Luis Durani, Charlie Clark2

7/9/19

Openpyxl - SlicerAm .07.2019, 02:47 Uhr, schrieb Luis Durani duran...@gmail.com: > Hello All, > > I

unread,

Openpyxl - SlicerAm .07.2019, 02:47 Uhr, schrieb Luis Durani duran...@gmail.com: > Hello All, > > I

7/9/19