<h3>如果我理解你的问题…</h3>
<p>您可以使用pandas<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.ExcelWriter.html" rel="nofollow noreferrer">excel writer</a>(也可以查看<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_excel.html" rel="nofollow noreferrer">^{<cd1>}</a>的参数):</p>
<pre><code>writer = pd.ExcelWriter("Output.xlsx", engine='xlsxwriter')
# Convert the dataframe to an XlsxWriter Excel object.
df.to_excel(writer, sheet_name='Feuil1')
# Get the xlsxwriter workbook and worksheet objects.
workbook = writer.book
worksheet = writer.sheets['Feuil1']
# Add some cell formats
header_format = workbook.add_format({
'bold': True,
'text_wrap': True,
'valign': 'vcenter',
'align': 'center',
'bottom': 1}
)
# Create a base format
format1 = workbook.add_format({'align': 'center', 'border': False})
# Create a "red" format
format2 = workbook.add_format({'bg_color': '#FFC7CE',
'font_color': '#9C0006'})
# Create a "green" format
format3 = workbook.add_format({'bg_color': '#CDFFC7',
'font_color': '#324f2F'})
# Set the column width and format
worksheet.set_column('A:N', 16, format1)
worksheet.conditional_format(
'A1:N800',
{'type': 'cell', 'criteria': '==', 'value': '"no data"','format': format2}
)
worksheet.conditional_format(
'A1:N500',
{'type': 'cell', 'criteria': '==', 'value': '"not applicable"', 'format': format3}
)
# Write the column headers with the defined format.
for col_num, value in enumerate(df.columns.values):
worksheet.write(0, col_num, value, header_format)
</code></pre>
<p><a href="https://xlsxwriter.readthedocs.io/working_with_pandas.html" rel="nofollow noreferrer">Here</a>你可以找到一个大型教程</p>