python_xlrd_1

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)

ws = wb.sheet_by_index(1)
ncol = ws.ncols
nlow = ws.nrows

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