Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class CsvPipeline:
- def __init__(self):
- date = datetime.today().strftime("%d-%m-%Y")
- self.filename = f'{date}.xlsx'
- self.workbook = openpyxl.Workbook()
- # worksheet = workbook.active
- # worksheet.title = "data"
- def open_spider(self, spider):
- pass
- def close_spider(self, spider):
- self.workbook.save(self.filename)
- def process_item(self, item, spider):
- try:
- ws = self.workbook[item['data'][0]]
- except KeyError:
- ws = self.workbook.create_sheet(item['data'][0])
- item_d = list(item['data'][1])
- max_row = ws.max_row
- ws.cell(row=1, column=1, value=item['data'][0])
- for row, entry in enumerate(item_d, start=1):
- ws.cell(row=max_row+row, column=1, value=entry)
- return item
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement