Append as column
Doc from ws.append
Appends a group of values at the bottom of the current sheet.
If it’s a list: all values are added in order, starting from the first column
If it’s a dict: values are assigned to the columns indicated by the keys (numbers or letters)
Can ws.append be designed to have one more parameter row
/col
? So that all values can be added in order, starting from the first row, if col
is selected.
Just like this:
for i in range(N):
_ = ws.cell(row=i+1, column=1, value=list[i])
Edited by Firestar-Reimu