python_xlrd_2

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 low --------"
i = 0
while i < nlow:
    print str(ws.row_values(i))
    i += 1

print "-------- Values of col --------"
i = 0
while i < ncol:
    print str(ws.col_values(i))
    i += 1