How to import Excel columns into Python (Word2Vec text processing)?

[szakharov7723]

I want to import ,say, D column from .xls (not csv) file, data is range, not table.
How to do that ?

I found how to import named column, but not basic

 

[jay_py]

You will need pandas library.
Assuming the column D has a header named "column D".

import pandas as pd
df = pd.read_excel('file.xls')
col_d = df['column D']