CODEWITHSUNDEEP
excelpython-2.7xlrd
Jac Cook
Jac Cook

Reputation: 3

How to Extract Multiple Columns from Excel into an array

I am using xlrd to extract individual columns. I am hoping to extract multiple columns from excel into an array so I can use itertools group by function to analyze them.

Is it possible to pull more than one column from excel using xlrd?

Upvotes: 0

Views: 958

Answers (1)

Ankit Marothi
Ankit Marothi

Reputation: 1005

I think this should help you, Click python documentation for xlrd! 

Sheet.row_slice(rowx, start_colx=0, end_colx=None)
Returns a slice of the Cell objects in the given row.

You might just need to loop over it

Upvotes: 1

Related Questions