利用python对Excel中的特定数据提取并写入新表
import openpyxl
import re
def Exceldivide(file_dir):
wb=openpyxl.load_workbook(file_dir) #打开原有的excel表
sheet=wb.get_sheet_by_name('Sheet1')
tuple(sheet['A1':'C3'])
wb.create_sheet('Sheet2') #新建一个表
sheet2=wb.get_sheet_by_name('Sheet2')
tuple(sheet2['A1':'C3'])
L1=(r'\d\d/\d\d/\d\d\d\d') #日期格式
L2=(r'[a-zA-Z0-9_]+@[a-zA-Z0-9-]+.com') #邮件格式
l1=[]
l2=[]
for rows in sheet['A1':'C3']: #提取日期和邮件数据
for cell in rows:
A=()
a=()
B=()
b=()
for rows in sheet2['A1':'A9']: #把日期数据写入新表
for cell in rows:
=a
print(,)
for rows in sheet2['B1':'B9']: #把邮件数据写入新表
for cell in rows:
=b
print(,)
return wb
g=Exceldivide('C:\\Users\\Desktop\\111_copy.xlsx')
('C:\\Users\\Desktop\\111_copy.xlsx') #保存