read and write in excel file with python

Question

I am trying to read the cell of a excel file in python, change its value and save it. If I do not have the line from xlutils.copy import copy in code, it recognizes workbook.sheeets(), but otherwise it says

    AttributeError: 'Workbook' object has no attribute 'sheets'

Here is my code:

    from xlutils.copy import copy

    import xlrd
    st = xlwt.easyxf('pattern: pattern solid;')
    rb = xlrd.open_workbook('00-17.xlsx')

    workbook = copy(rb)
    for sheet in workbook.sheets():
        for row in range(sheet.nrows):

            current_value = sheet.cell(row,3).value
            if(current_value == '1' ) :
                st.pattern.pattern_fore_colour = 5

                for column in [0,2,3]:
                    value = sheet.cell(row, column).value

                    print value
                    sheet.write(row, column, value,st)
    workbook.save('1.xlsx')

AttributeError: 'Workbook' object has no attribute 'get_sheet_by_name' — Pegah, Jul 07 '17 at 13:30
You may want to go ahead and read the documentation for `xlrd` first. The method for accessing a sheet by name is `.sheet_by_name` not `.get_sheet_by_name`. Also, to get row counts, just use `sheet.nrows`. — Abdou, Jul 07 '17 at 13:33
You can try this alternative method for read sheet: sheet_names = xl_workbook.sheet_names() xl_sheet = xl_workbook.sheet_by_name(sheet_names[0]) — Rinos, Jul 07 '17 at 13:34

score 0 · Answer 1 · edited Jul 08 '17 at 11:26

0

I believe you may have to use load_workbook() method first. Check out the link Print Excel workbook using python it will probably help.

Can you try doing it with workbook = xlrd.open_workbook('00-17.xlsx') and remove the line workbook = copy(rb)?

edited Jul 08 '17 at 11:26

Bhargav Rao

45,811
27
120
136

answered Jul 07 '17 at 13:33

Cary Shindell

1,296
6
25

My python has a problem with load_workbook(), and because it does not finde the base package (although I installed it). Could you have a look at my update? – Pegah Jul 07 '17 at 14:28
Can you try doing it with `workbook = xlrd.open_workbook('00-17.xlsx')` and remove the line `workbook = copy(rb)`? – Cary Shindell Jul 07 '17 at 14:35

read and write in excel file with python

1 Answers1