Python concatenation of variable and string

Question

for i in range (0,len(list4)):
  ws.write(1, 0, datetime.now(), style1)
  ws.write(2, 1, 1)
  ws.write(2, 2, xlwt.Formula("A3+B3"))
  wb.save('example.xls')

how do i generalize (A3+B3) ?

'"A" + i' + '"B" + i'

Is this correct???

Ignacio Vazquez-Abrams · Accepted Answer · 2011-03-28 11:48:34Z

7

'A%(row)d+B%(row)d' % {'row': 3}

or

'A{0}+B{0}'.format(3)

answered Mar 28, 2011 at 11:48

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

2 Comments

David Heffernan Over a year ago

+1 I'm upvoting because I think the versions of the string formatting routines that you use are cleaner than my very old-fashioned ways. I prefer the first one where a meaningful name can be used.

Katriel Over a year ago

Just to point out you can still use named fields in the newer PEP 3101 .format syntax: "A{row} + B{row}".format(row=3). The 0 just means "use the first value".

David Heffernan · Accepted Answer · 2011-03-28 11:45:32Z

3

You need:

ws.write(2, 2, xlwt.Formula("A" + str(i) + "+B" + str(i)))

Or more idiomatically:

ws.write(2, 2, xlwt.Formula("A%d+B%d" % (i,i)))

answered Mar 28, 2011 at 11:45

David Heffernan

616k46 gold badges1.1k silver badges1.5k bronze badges

Collectives™ on Stack Overflow

Python concatenation of variable and string

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related