使用for循环中的dataframe和xlsxwriter将整个Beautifulsoup数组保存到excel中

import pandas as pd
import xlsxwriter

df = pd.DataFrame()

for item in beautifulsoup_array:
    # 假设每个item包含两个字段：title和content
    title = item.find('title').text
    content = item.find('content').text
    
    # 将数据添加到DataFrame中
    df = df.append({'Title': title, 'Content': content}, ignore_index=True)

# 创建Excel文件
workbook = xlsxwriter.Workbook('output.xlsx')

# 创建一个工作表
worksheet = workbook.add_worksheet()

# 写入DataFrame数据到工作表中
worksheet.write_string(0, 0, 'Title')
worksheet.write_string(0, 1, 'Content')

for i, row in df.iterrows():
    worksheet.write_string(i+1, 0, row['Title'])
    worksheet.write_string(i+1, 1, row['Content'])

# 关闭Excel文件
workbook.close()