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)
Post a Comment for "Auto Increment Row In Xls And Update It's Values Using Python"