python比较excel表格内容并提取_python 实现excel数据的提取和整理

看了很多大牛的帖子，结合前辈的经验。从excel表格中批量提取数据，整理后重新写回excel。

#!coding:utf-8

# Author:pymingming

import xlrd

import re

from xlrd import open_workbook

from xlutils.copy import copy

def read(file, sheet_index=0):

workbook = xlrd.open_workbook(file)

sheet = workbook.sheet_by_index(sheet_index)

# print("工作表名称:", sheet.name, "行数:", sheet.nrows, "列数:", sheet.ncols)

data = []

for i in range(0, sheet.nrows):

data.append(sheet.row_values(i))

return data

def reg(data):

regexp = r'MGG_\d{5}'

pat = re.compile(regexp)

MGG_all = re.findall(pat, str(data)) # 需为string格式

Mgg_unique = set(MGG_all)

return Mgg_unique

rexcel = open_workbook("a.xls") # 用wlrd提供的方法读取一个excel文件

rows = rexcel.sheets()[0].