!/usr/bin/python

coding=utf-8

import xlrd
import xlwt

def read_excel():
ExcelFile=xlrd.open_workbook(r'/Users/liyuanlong/WorkSpace/test_paper/original.xlsx')
sheet_name=ExcelFile.sheet_names()[0]

sheet=ExcelFile.sheet_by_index(0)
row_cnt = sheet.nrows

cols1=sheet.col_values(0)
cols2=sheet.col_values(1)

dictAll = {}
for i in range(row_cnt):
    if dictAll.has_key(sheet.row_values(i)[0]):
        dictAll[sheet.row_values(i)[0]]["cnt"] += 1
        dictAll[sheet.row_values(i)[0]]["content"].append(sheet.row_values(i)[1])
    else:
        dictAll[sheet.row_values(i)[0]]={
                "cnt":1,
                "content":[sheet.row_values(i)[1]]
                }   

return  dictAll

def write_excel(contentDict):
f = xlwt.Workbook()
sheet1 = f.add_sheet(u'sheet1',cell_overwrite_ok=True)
cnt = 0
for i in contentDict.keys():
oneLine = contentDict[i]
sheet1.write(cnt,0,i)
sheet1.write(cnt,1,oneLine["cnt"])
sheet1.write(cnt,2,oneLine["content"])
cnt += 1

f.save('processed.xls')

if name =='main':
content = read_excel()
write_excel(content)