from openpyxl import load_workbook
from datetime import datetime  #导入时间模块
def create_time():wb=load_workbook('提取身份证号信息.xlsx')sh=wb.active now_year=datetime.now().yearmaxcol=sh.max_column#在列表B循环遍历i次,cell数值for i,cell in enumerate(sh['b']):pno=cell.value  #b列表0行至最大行每次的值#身份证号前六位：行政区划,4位年份,2月,2日,4为个人识别码year=pno[6:10]mouth=pno[10:12]  #月份day=pno[12:14]  #日age=now_year-int(year)sh.cell(i+1,maxcol+1).value=yearsh.cell(i+1,maxcol+2).value=mouthsh.cell(i+1,maxcol+3).value=daysh.cell(i+1,maxcol+4).value=agewb.save('.身份证号提取日期.xlsx')
if __name__ == '__main__':create_time()