0206python openpyxl筛选、datetime、Font(color,size)应用举例

##0206python openpyxl筛选、datetime、Font(color,size)应用举例##

import pandas as pd
import os
import openpyxl as vb
import random
from datetime import datetime
print(datetime.now())
from openpyxl.styles import Font
path='c:/Users/Administrator/Desktop'
input_data=os.path.join(path,'三年级.xlsx')
output_data=os.path.join(path,f'{str(random.random()).split('.')[1][1:3]}.xlsx')

wb=vb.load_workbook(input_data)
ws=wb.active
nwb=vb.Workbook()
nws=nwb.active
for sheet in wb.sheetnames:
    print(sheet)
    for rows in wb[sheet].iter_rows(values_only=True):
        print(rows)
        for i in range(1,wb[sheet].max_column-1):
            try:
                if (rows[i]>=90 and  rows[i] is not None and isinstance(rows[i],(int,float))):
                    #rows[i].font=Font(size=20,color='ff0000')
                    nws.append(rows)
                    
            except Exception as e:
                print(f'{wb[sheet].cell(i,i).value}')

for rows in nws.iter_rows():
    for cell in rows:
        if (isinstance(cell.value,(int,float)) and cell.value>=90):
            cell.font=Font(size=20,color='ff0000')
uniquerows=sorted(set([row for row in nws.iter_rows(values_only=True)]))
print(list(uniquerows))
nwb1=vb.Workbook()
nws1=nwb1.active
for row in uniquerows:
    nws1.append(row)
for rows in nws1.iter_rows():
    for cell in rows:
        if (isinstance(cell.value,(int,float)) and cell.value>=90):
            cell.font=Font(size=20,color='ff0000')
nwb1.save(output_data)