Interacting with Excel using pywin32

Question

I have an easy task - iterate over a list of excel files and replace all occurencies of some words with other words.

Can't find out how it could be made using pywin32 library. Namely I can't find any clear documentation or examples how to interact with excel.

I want to iterate all sheets in excel doc and replace '111' with '222'.

I'm using the following code:

def searchexcel():
    excel = win32.gencache.EnsureDispatch('Excel.Application')
    excel.Visible = False
    for infile in glob.glob( os.path.join('', '*.xls') ):
        print infile
        e = excel.Workbooks.Open(os.getcwd()+'\\'+infile)
        sh = e.Sheets()
        for sheet in e:
            sheet.Replace('111', '222', win32.constants.xlWhole)
        e.Save()
    excel.Application.Quit()

But it does not work properly.

What about sheet.Cells.Replace...?

David Zemens
– David Zemens

2013-04-02 16:31:47 +00:00
Commented Apr 2, 2013 at 16:31 — David Zemens
– David Zemens, Commented Apr 2, 2013 at 16:31

annndrey · Accepted Answer · 2013-04-09 11:41:39Z

1

As it was posted in comment, I should use sheet.Cells.Replace

answered Apr 9, 2013 at 11:41

annndrey

1,7882 gold badges20 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Interacting with Excel using pywin32

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related