Update specific rows with Excel node

Questions
1

Hi, I’m new to n8n and I’m trying to edit an existing Excel file using the “Microsoft Excel 365” node. Basically, I’d “just” like to replace rows 10–20 in a specific sheet. Unfortunately, the combinations/functions of “range, data mode, column to match on, value of column to match on, …” aren’t entirely clear to me. Is there more documentation or some more complex examples?

2

you can use Append or update node then specify range you want to update.

3

Thank you for your reply — a few questions about that:

  • In “Range” it says “First row must contain column names.” However, I want to update a range without column names. Is this really the range that will be edited?
  • When I choose “Map Each Column Below” in “Data Mode,” it looks to me like I have to define a condition to identify the row to be updated. But I “simply” want to replace rows 5 to 10. So I want to specify row numbers.
  • And under “Values to Send,” it looks to me like I can only update a single row, right? But I want to update multiple rows at once.
4

yes it might need to match values.
but you can use http node to change values, as n8n has built in authentication for http request you can use same oauth which you provided while connecting to excel365:

in this I have updated 2 columns

before:

image
image190×262 3.44 KB

after:

image
image218×276 4.42 KB

5

Thanks. I’ll use the Graph API!