from openpyxl import Workbook

class ExcelPipeline(object):
    def __init__(self):
        self.wb = Workbook()
        self.ws =self.wb.active
        self.check=False

    def process_item(self,item, spider):
        if item:
            if not self.check:
                self.ws.append(list(item.keys()))
                self.check=True

            line = list(item.values())

            os.chdir(r'path')

            self.ws.append(line)
            self.wb.save(f"{'文件名'}.xlsx")
            return item