pipelines_excel.py

def process_item(self, item, spider):
        adapter = ItemAdapter(item)
        d = adapter.asdict()

        if self.current_row_index == 0:  # Write Header
            fmt = self.heading_format
            for column, value in enumerate(d.keys()):
                self.worksheet.write(self.current_row_index, column, value, fmt)

        data = d.values()
        fmt = self.cell_format

        for column, value in enumerate(data):
            self.worksheet.write(self.current_row_index+1, column, value, fmt)

        self.current_row_index += 1
        
        return item