Extract the data and modify an existing excel with openpyxl

If I add this

n=1
for n in range(1, 100):
    ws.cell(row=n, column=1).value(4)
    n+1

It paste all 4 in column A

But I want the whole yahoo [‘Open’] array to be pasted