读取Excel每个单元格并且计算重复数数量，最后保存

# -*- coding: utf-8 -*-
# @Time : 2018/11/16 22:03
# @Author : wujing
# @Site : 
# @File : read_txt.py
# @Software: PyCharm
# @Wechat : 18007148050

import sys
import xlrd
import xlwt
import random

print("计算重复数：")
# 打开Excel
mylist = []
workbook = xlrd.open_workbook('test.xls')

# 进入sheet
excel_sheet = workbook.sheet_by_index(0)

# 获取行数和列叔
nrows_num = excel_sheet.nrows
ncols_num = excel_sheet.ncols
for i in range(0, nrows_num):
    for j in range(0, ncols_num):
        current_number = excel_sheet.cell(i, j).value
        if current_number != 0 :
            mylist.append(current_number)
print(mylist)
# mylist = [1,2,2,2,2,3,3,3,4,4,4,4]

book = xlwt.Workbook(encoding='utf-8', style_compression=0)

myset = set(mylist)  #myset是另外一个列表，里面的内容是mylist里面的无重复 项
sheet = book.add_sheet("mysheet", cell_overwrite_ok=True)
m = 0
n = 0
for item in myset:
    # print("结果为:")

    print(str(item) + "    " + str(mylist.count(item)))

    sheet.write(m, n, item)
    sheet.write(m, n + 1, mylist.count(item))
    m += 1

book.save('output.xls')