How to Extract Multiple Columns from Excel into an array

958 views Asked by At

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?

1

There are 1 answers

0
Ankit Marothi On

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