I Can’t find how to insert a table row in a Microsoft Excel worksheet.
I need to correlate the columns with the values? How?
When I create an Excel node with an “add row” operation and run it, I get the result like bellow image.
The index value wouldn’t need to be set unless you want to insert the new row at a specific position.
Also it’s worth keeping in mind that Excel doesn’t immediately show the newly inserted data, so you might want to reload the page when checking the results.
when you say: “you need to make sure they both have the same column header.”
Are you referring to the output of the previous node? In my case the webhook.
So it looks like in your webhook data the Name field is nested under body. You could use a Set node in front of your Excel node, this let’s you specify which columns you want to keep when enabling the Keep Only Set option:
Simply enter the column name in the Name field, then in the Value field using an expression such as {{ $json.body.Name }} to read the Name field inside body from your previous node.
