how to concatenate two columns in excel using python

Question

I want to concatenate two columns is excel and make it as a single column.

For example : column A=12 column B=778

The output should be column c=12778

please find the sample file in the attachment.

What does this have to do with Python? Just use concat or + and convert the cells to text. — dfundako
– dfundako, Commented May 10, 2018 at 13:41

Szabolcs · Accepted Answer · 2018-05-10 13:50:18Z

1

Well you can use the xlwings package for this.

import xlwings as xw

sht = xw.apps[0].books[0].sheets[0]
sht.range('C1').value = int(str(sht.range('A1').options(numbers=int).value) + str(sht.range('B1').options(numbers=int).value))

This snippet will connect to the first active excel application's first worksheet on your system, then grabs the numeric values from cells A1 and B1, convert them to integers then to strings and concatenate them, and finally reconvert it to an integer and pass the final value to cell C1.

For further reference please visit the package documentation.

Hope it helps.

edited May 10, 2018 at 13:50

answered May 10, 2018 at 13:45

Szabolcs

4,11620 silver badges44 bronze badges

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

4 Comments

kasi_VN Over a year ago

can you please write a code without using xlwings package.

Szabolcs Over a year ago

@kasi_VN in vanilla Python?

kasi_VN Over a year ago

can u help me by using xlrd package.

kasi_VN Over a year ago

i am a beginner in python, please tell me how to open and read excel and execute this operation with code.

Collectives™ on Stack Overflow

how to concatenate two columns in excel using python

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related