i cant print all values from i row in excell

Question

I want take all values from a row in excell...

for one specific cell i use:

c=5
cell= wsact.cell(row = 9, column = c) 
print(cell.value)

and i take value for cell in 9 row and 5 column. If i want take all values for the first 10 columns i use:

c=1
while c<=10:
    cell= wsact.cell(row = 9, column = c) 
    print(cell.value)
    c=c+1

and i take :

File "makelist.py", line 23 cell= wsact.cell(row = 9, column = c) ^ IndentationError: expected an indented block

what am I doing wrong?

https://stackoverflow.com/questions/4446366/why-am-i-getting-indentationerror-expected-an-indented-block — Zhubei Federer, Aug 12 '20 at 08:41

score 0 · Accepted Answer · answered Aug 12 '20 at 08:41

0

You need to indent everything below the while statement:

c=1
while c<=10:
    cell= wsact.cell(row = 9, column = c) 
    print(cell.value)
    c=c+1

answered Aug 12 '20 at 08:41

7koFnMiP

1 Answers1