Introduction
Working with Excel Files
Instruction
That was a piece of cake! Now, we can also add whole rows of data in one loop:
row_list = [ ["Time", "Event"], ["17:30", "Meeting with Jake"], ["20:00", "Cinema"] ] for row in row_list: ws.append(row)
As you can see, we've prepared a list of lists. Each list should be treated as a separate row that will be appended to a given worksheet, starting from column A and the first empty row.
Exercise
We've already selected the "Food" worksheet for you and given you a list of foods. Add them to the worksheet.
Save the modified workbook in the file budget.xlsx.
