我有一个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)
```
先载入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')
如对你有帮助,请点击我回答右上方采纳按钮给予采纳支持。