How do I make my spider save in a single XML file all the Excel data from the links that I extract? Or do you also save in each single XLS file in the project folder?
Part of my spider:
def parse(self, response):
divs = response.xpath('''meu caminho html''')
for div in divs:
#o arquivo xls sai dessa html
links = div.xpath('.//a/@href').extract_first()
yield {'Links': links,}