How to use variables in loop, for nested lists

Question

I`am trying to extract some data from a sheet in excel 'recursos is the name of the page', I would like to not use the current for cycle any ideas?

celdas3=recursos['AN8':str(rsearch)+str(max_row)]   

for c1,c2,c3,c4,c5,c6,c7,c8,c9,c10 in celdas3:                
    var_3=[c1.value,c2.value,c3.value,c4.value,c5.value,c6.value,c7.value,c8.value,c9.value,c10.value]
    ex3.append(var_3)
    print(ex3)

And I would like to instead of use c1,c2,c3, etc use a variable. celdas3 is:

Anonymous · Accepted Answer · 2019-12-26 18:53:54Z

3

You don't have to unpack the list in the for loop:

for c in celdas3:                
    var_3 = [c1.value for c1 in c]
    ex3.append(var_3)
    print(ex3)

answered Dec 26, 2019 at 18:53

Anonymous

12.1k7 gold badges37 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CVM Over a year ago

Thanks! It was the answer I was looking for,

Collectives™ on Stack Overflow

How to use variables in loop, for nested lists

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related