Extract columns from Excel using Python

The

u

means it is a unipre string, it gets put there when you call

str()

.
If you write the string out to a file it wont be there. What you are getting
is 1 row from the column. It’s because you are using

end_rowx=1

it returns a
list with one element.

Try getting the column value lists:

ids = sh.col_values(0, start_rowx=1)english = sh.col_values(1, start_rowx=1)spanish = sh.col_values(2, start_rowx=1)french = sh.col_values(3, start_rowx=1)

and then you can

zip

them into tuple lists:

english_with_IDS = zip(ids, english)spanish_with_IDS = zip(ids, spanish)french_with_IDS = zip(ids, french)

Which are in the form:

("1", "Hello"),("2", "Hi"), ("3", "Bus")

If you want to print the pairs:

for id, word in english_with_IDS:       print id + "=" + word

col_values

returns a list of column values, if you want single values you
can call

sh.cell_value(rowx, cellx)

.