Multiple worksheets go to one workbook

Questions
1

Hello,
I am a new user of n8n and would like to know which nodes can support me with “Multiple worksheets go to one workbook.” Please share your input.

Thank you.

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @Swapna_Nayak ,

Welcome to the community! :dizzy:

The nodes that would help you here would be the mainly the Extract from File - Extract From File | n8n Docs - and Convert to File nodes - Convert to File | n8n Docs.

To accomplish this you could build a workflow somewhat like this:

Where you would load the data from you rmachine > extract it and it and convert it to json > then merge it together (for this you can either use the merge node or the set node if you want to edit which fields to combine) > and then convert it back to, for example, XLSX.

4

Hello marina,
Thank you for your reply and useful for me to merger the excel file but question was different. I am receiving two different excel sheets from API. These two different excel sheets, I want to place as sheet 1 and sheet 2 in one excel workbook. So I can send to the users one excel workbook and they can see the result in sheet1 and sheet 2. I hope it’s clear now. Please help me to solve the situation.

Regards

5

Ah! Appologies for missing the point.

For this you can then just use the Excel node to add a spreadsheet to a workbook, but as this node only allows for the insertion of one sheet at a time, you will need to loop over it to add more inputs.

Something like this:

Here you can also read more about the Loop Over Items node, including an example on how to test it: Loop Over Items | n8n Docs and about the Excel node, including all it’s possible applications: Microsoft Excel | n8n Docs

Hope this one hit the mark! :dart:

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.