use python to read and write xls

xls_process.py

import xlrd
import xlwt

data = xlrd.open_workbook('input.xls')
table = data.sheets()[0]

nrows = table.nrows
ncols = table.ncols

print data.nsheets
print nrows, ncols

dict = {}
for i in range(nrows):
    for j in range(ncols):
        content = table.cell_value(i, j)
        if not isinstance(content, float) and not isinstance(content, int):
            content = content
            //print content.encode('utf-8')

        if content in dict:
            dict[content] += 1
        else:
            dict[content] = 1

result = sorted(dict.items(), lambda x, y: cmp(x[1], y[1]), reverse=True)

f = xlwt.Workbook()
table = f.add_sheet('Sheet1')
for i in range(len(result)):
    table.write(i, 0, result[i][0])
    table.write(i, 1, result[i][1])

f.save('output.xls')