python_xlrd_3

gistfile1.txt

__author__ = 'Administrator'
import xlrd

wb = xlrd.open_workbook("C:\\test.xlsx")
ws = wb.sheet_by_index(0)
ncol = ws.ncols
nlow = ws.nrows

print "-------- Sheet1 --------"
print "Number of col: " + str(ncol)
print "Number of low: " + str(nlow)

print "-------- Values of Excel file --------"

i = 0
j = 0
low = []
list = []
while i < nlow :
    while j < ncol :
        low.append(str(ws.row_values(i)[j]))
        j += 1
    list.append(low)
    low = []
    i += 1
    j = 0

i = 0
while i < 4 :
    print list[i]
    i += 1