Error "list indices must be integers or slices, not str"

[dee]

I want to format Excel column to percent. The following code gave me "list indices must be integers or slices, not str" error. The __class__ of Column D is 'str'. Is it because the header is string?

Please advise how to format the columns with %. Thank you.

    wb = xl.load_workbook(fullpath)
    wsData = wb.worksheets["Data"]    
    wsData.Range("D2:O2").Style = "Percent"

or

    wsData.Range("D2:O2").NumberFormat = "0.00%"

See attachment for data.
   

Yoriz write Dec-30-2022, 12:34 AM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[deanhystad]

I'm assuming you are using openpyxl. I may be wrong since only 1 line in your post is valid based on "xl" being openpyxl.

The error is here:

wsData = wb.worksheets["Data"]

Worksheets is not a dictionary. It cannot be indexed by name. You can do this.

wsData = wb["Data"]

After you change that you'll soon learn that worksheets don't have a method "Range()". This is how you can set the number format for a range of cells.

import openpyxl as xl

wb = xl.load_workbook("test.xlsx")
sheet = wb["Sheet1"]
for cell in sheet["D2:O2"][0]:
    cell.number_format = "0.00%"

Have you looked through any of the openpyxl documentation?

https://openpyxl.readthedocs.io/en/stable/tutorial.html

[dee]

Thank you deanhystad. It works.