把计算得出的2个值写入到不同的sheet中

Question

我有一个excel文件叫Aged analysis，有2个sheet。sheet名为red的有一组数据，其中B8单元格空着。sheet名为blue的有一组数据，其中b8单元格也空着。我现在需要把我下面得到的a值5写入red的B8单元格，把b值写入blue的bB8单元格。请问这部分代码怎么写？

```python
import pandas as pd
import openpyxl
from openpyxl import load_workbook
data=  pd.read_excel('This Week.xlsx',sheet_name='details')
 x=len(data)
print(x)
 df_bool_multi_and = ((data['Sales Org'] == 2118) & (data['SDV Code'] != 'LP6') & (data['Block Bucket (Aged update)'] != 'Service') & (data['Aged'] == 'Aged order'))
a=df_bool_multi_and.sum()*100/(x*1.0)
print(a)
data.rename(columns={'Sales Order Type':'E'},inplace=True)
df_bool_multi_and2 = ((data['Sales Org']!=2118) & (data['SDV Code'] != 'LP6') & (data['Block Bucket (Aged update)'] != 'Service') & (data['Aged'] == 'Aged order') & (data['Blue Aged Excl. Flag'] != 'Y') & (data.E.isin(['ZB1S','ZB1B','ZB1A','ZB1O','ZB4S','ZB4B'])))
b=df_bool_multi_and2.sum()*100/(x*1.0)
print(b)

```

Answer 1

先载入excel文件，分别读取sheet并写入单元格即可。代码可这样写：

from  openpyxl import load_workbook

wb = load_workbook('t913.xlsx')
ws1=wb['red']
ws2=wb['blue']
ws1['B8'].value=a
ws2['B8'].value=b
wb.save('t913.xlsx')

如对你有帮助，请点击我回答右上方采纳按钮给予采纳支持。