优化下面这段代码# Define your item pipelines here # # Don't forget to add your pipeline to the ITEM_PIPELINES setting # See: https://docs.scrapy.org/en/latest/topics/item-pipeline.html # useful for handling different item types with a single interface import openpyxl from itemadapter import ItemAdapter class TaobaospiderPipeline: def __init__(self): self.wb = openpyxl.Workbook() # 创建工作簿 self.ws = self.wb.active # 拿到默认激活的工作表 self.ws.title = 'TaoBaoData' # 工作表名称 self.ws.append(('标题','价格','销量','店铺名称','店铺地址')) # 表头 def close_spider(self, spider): # 爬虫停止运行的时候执行该方法,钩子函数，自己执行不需要调用 self.wb.save('淘宝商品数据.xlsx') def process_item(self, item, spider): title = item.get('title', '') # 如果字典中的title值为空的话，就把''（空值）赋给title变量,写法一 price = item.get('price') or 0 # 如果字典中的title值为空的话，就把''（空值）赋给title变量，写法二 deal_count = item.get('deal_count', '') shop = item.get('shop', '') location = item.get('location', '') self.ws.append((title, price, deal_count, shop, location)) # return item

# 导入所需库
import openpyxl
from itemadapter import ItemAdapter

class TaobaospiderPipeline:
def __init__(self):
# 创建工作簿、工作表和表头
self.wb = openpyxl.Workbook()
self.ws = self.wb.active
self.ws.title = 'TaoBaoData'
self.ws.append(('标题','价格','销量','店铺名称','店铺地址'))

def close_spider(self, spider):
# 爬虫停止运行时保存文件
self.wb.save('淘宝商品数据.xlsx')

def process_item(self, item, spider):
# 使用 ItemAdapter 将 item 转换为字典类型
item_dict = ItemAdapter(item).asdict()

# 获取商品信息
title = item_dict.get('title', '')
price = item_dict.get('price', 0)
deal_count = item_dict.get('deal_count', '')
shop = item_dict.get('shop', '')
location = item_dict.get('location', '')

# 将商品信息写入工作表
self.ws.append((title, price, deal_count, shop, location))

return item