我有一个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)
```