How do I concatenate string and an integer? [duplicate]

Question

act = input("Enter name of the activity") cellone = int(input("Enter the order number of activity")) cell1 = "A" + cellone worksheet.write(cell1, act)

I'm trying to concatenate A and cellone but I'm getting some error saying that I can't concatenate string and an integer, is there a way to do this?

You don't actually need to concatenate the string and integer. The XlsxWriter write() function take integer values as well as strings so you could just do this: worksheet.write(cellone -1, 0, act). See the XlsxWriter docs: xlsxwriter.readthedocs.io/worksheet.html#worksheet-write — jmcnamara
– jmcnamara, Commented Mar 20, 2022 at 14:17

SultanOrazbayev · Accepted Answer · 2022-03-20 07:05:41Z

3

You can change int to a string representation using this:

cell1="A"+str(cellone)

Alternatively, f-string formatting will also work:

cell1=f"A{cellone}"

edited Mar 20, 2022 at 7:05

answered Mar 20, 2022 at 6:43

SultanOrazbayev

16.7k3 gold badges25 silver badges59 bronze badges

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

3 Comments

Thu Ya Kyaw Over a year ago

I agree with this answer. f-string is a preferred way for Python as of now. Not only it's cleaner, it's faster as well.

Commissar Vasili Karlovic Over a year ago

@IamThuYa indeed it's faster and easy, but still a "hack". In a professional environment where thousands of lines are reviewed and maintained, it's very important to maintain the logic behind the writing. In the first case the developer shows that he's casting a string in order to concat with 'A', while in the second it's like reformatting the variable.

Thu Ya Kyaw Over a year ago

@CommissarVasiliKarlovic I agree with maintaining the logic but this is not a "hack". For python at least, we care about pythonic ways. Using f-string provide so much more control over plain casting. If the variable is a float, with f-string I can control how many decimal I want to use, etc.

clickbait · Accepted Answer · 2022-03-20 06:43:21Z

1

str(cellone) returns the value of cellone as a string.

call1="a"+str(cellone)

answered Mar 20, 2022 at 6:43

clickbait

3,0181 gold badge30 silver badges68 bronze badges

Comments

user18511682 · Accepted Answer · 2022-03-20 06:43:39Z

Remove the int in line 2 as follows:

cellone=input("Enter the order number of activity")

It takes the input as a string data type anyway

balu · Accepted Answer · 2022-03-20 06:43:51Z

Just dont convert the string to int. correct that to

cellone=input("Enter the order number of activity")

Collectives™ on Stack Overflow

How do I concatenate string and an integer? [duplicate]

4 Answers 4

3 Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Linked

Related