这是一个如何将条件格式应用于Pandas创建的XlsxWriter Excel文件的示例：
import pandas as pd# Some sample data to plot.list_data = [30, 40, 50, 40, 20, 10, 5]# Create a Pandas dataframe from the data.df = pd.Dataframe(list_data)# Create a Pandas Excel writer using XlsxWriter as the engine.excel_file = 'testfile.xlsx'sheet_name = 'Sheet1'writer = pd.ExcelWriter(excel_file, engine='xlsxwriter')df.to_excel(writer, sheet_name=sheet_name)# Access the XlsxWriter workbook and worksheet objects from the dataframe.# This is equivalent to the following using XlsxWriter on its own:## workbook = xlsxwriter.Workbook('filename.xlsx')# worksheet = workbook.add_worksheet()#workbook = writer.bookworksheet = writer.sheets[sheet_name]# Apply a conditional format to the cell range.worksheet.conditional_format('B2:B8', {'type': '3_color_scale'})# Close the Pandas Excel writer and output the Excel file.writer.save()输出如下所示：
请参阅有关条件格式的XlsxWriter文档，以了解如何更改颜色或其他属性。
另请参阅使用Python
Pandas和XlsxWriter。
