Write Python List to Excel rows using xlwt

Question

I would like to write each value in a Python list to a new row in an Excel cell. The object I am generating the list from does not support indexing which is giving me an issue. If my list only generates one value, then there is no problem, however when I generate multiple values, I get multiple errors. I am a Python beginner using 64 bit OS X and Python 2.7. Any help would be much appreciated.

    import mlbgame
    month = mlbgame.games(2016, 7, 21, home ="Pirates")
    games = mlbgame.combine_games(month)
    for game in games:
        print(game)

    import xlwt
    from datetime import datetime

    wb = xlwt.Workbook()
    ws = wb.add_sheet('PiratesG')

    for game in games:
        ws.write(0, 0, str(game))
       #ws.write(1, 0, str(game[1]))

    wb.save('Pirates.xls')

    Error: Traceback (most recent call last):
      File "/Users/Max/Code/PiratesGameToExcel.py", line 14, in <module>
        ws.write(0, 0, str(game))
      File "/usr/local/lib/python2.7/site-packages/xlwt/Worksheet.py", line 1088, in write
        self.row(r).write(c, label, style)
      File "/usr/local/lib/python2.7/site-packages/xlwt/Row.py", line 241, in write
        StrCell(self.__idx, col, style_index, self.__parent_wb.add_str(label))
      File "/usr/local/lib/python2.7/site-packages/xlwt/Row.py", line 160, in insert_cell
        raise Exception(msg)
    Exception: Attempt to overwrite cell: sheetname=u'PiratesG' rowx=0 colx=0

mechanical_meat · Accepted Answer · 2016-07-22 16:38:22Z

2

You can use enumerate() to get the index of the list. Then you can write to successive rows like so:

for i,game in enumerate(games):
    ws.write(i,0,str(game))

answered Jul 22, 2016 at 16:38

mechanical_meat

170k25 gold badges238 silver badges231 bronze badges

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

1 Comment

mechanical_meat Over a year ago

Cheers, mate. Happy coding to you!

Collectives™ on Stack Overflow

Write Python List to Excel rows using xlwt

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related