python语言解析

import openpyxl
wb=openpyxl.load_workbook('day22作业.xlsx')#先读取文件
wb.create_sheet('Sheet3')
llll=wb['Sheet3']
print(wb.sheetnames)
aa=openpyxl.load_workbook("小宝剑大药房（高新店）2018年销售数据.xlsx")
print(aa.sheetnames)
sheet1=aa.worksheets[0]
print(sheet1)
z=[]
for w in range(1,10):
    row=sheet1[w]
    pp=[]
    for tt in row:
        if tt.value!=None:
            print(tt.value)
            pp.append(tt.value)
    if pp!=None:
        z.append(pp)
print(z)
for jjj in z:
    llll.append(jjj)
wb.save('day22作业.xlsx')
















# import openpyxl
# wb2 = openpyxl.Workbook()
# sheet2 = wb2.active
# sheet2.title = '小宝剑大药房汇总'
# sheet2.append(['小宝剑大药房2018年汇总数据'])
# sheet2.append(['购药时间','社保卡号','商品编码','商品名称','销售数量','应收金额','实收金额'])
# shop_lst = []
# def getvalue(xlname):
#     wb = openpyxl.load_workbook(f'小宝剑大药房（{xlname}）2018年销售数据.xlsx')
#     #读取数据
#     sheet = wb.active
#     #获取工作表对象
#     for n in range(3,sheet.max_row + 1):
#         row_list = []
#         row = sheet[n]
#         for cell in row:
#             if cell.value != None:
#                 row_list.append(cell.value)
#         if row_list != []:
#             shop_lst.append(row_list)
#
# getvalue('新津店')
# getvalue('犀浦店')
# getvalue('高新店')
# for sublist in shop_lst:
#     sheet2.append(sublist)
# wb2.save(r'小宝剑大药房汇总.xlsx')