Excel file index

Can i track the index of each row when reading from an excel file after using the ‘Extract From File’ Node, i want to make an update to the same row.

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:

You can reference the {{ $itemIndex }}, of each item (row) in the output, in an expression.

Can i get the index from using Loop Over Items node?

No, within a loop, the itemIndex represents the position in the current loop iteration’s batch of items, but you can use a Set node to inject the overall itemIndex before looping.

Please mark this post as the solution if it resolves your issue.

Im trying to read an csv file, using loop node to cycle through each row to use the data to calculate some result, then update back the result into same row. tried using convert to file then write to file, is it possible to update the same row in the same file without appending new row or overwriting the original file

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