# -*- 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')