read_file.style.apply(lambda x: [ 'background-color:%s' % 'red' if x < y else 'background-color :%s' % 'green' for x in read_file.language], axis=0 ,inplace=True) print("done") read_file.to_excel('coloured.xlsx',engine='openpyxl', index=False)
uj5u.com熱心網友回復：
采用：
import openpyxl
from openpyxl import load_workbook
excel_file = 'color.xlsx'
wb = load_workbook(excel_file, data_only = True)
sh = wb['Sheet1']
out = []
for row in sh:
if row[0].fill.start_color.index == '00000000':
out.append([row[i].value for i in range(len(row))])
pd.DataFrame(out).to_excel('no_red.xlsx')
顏色.xlsx：
no_red.xlsx：
多列輸入：
輸出：
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/447199.html