Auto Increment Row In Xls And Update It's Values Using Python

Facing issue while automatically updating an xls file ( Row and column) using python. Example: ( This is for first and second row, want to automatically increase the row values a

Solution 1:

You could put the write in a loop to increment the row number.

maxRows = 10   # or however many rows you want
for rowNumber in range(maxRows):
    sheet1.write(rowNumber, 0, Number)
    sheet1.write(rowNumber, 1, algo_type.tag)
    sheet1.write(rowNumber, 2, ref_slope)
    sheet1.write(rowNumber, 3, opt_slope)
    sheet1.write(rowNumber, 4, angle)