Microsoft Excel overwrites data instead of Updating a row

Questions
,
1

I’m having issues with this Excel node; it’s not updating rows, whether by ID or any column. If I set a range from A1:BV2, it only goes up to that row 2 and overwrites. My spreadsheet has more than approximately 30,000 rows. With the Google Sheets node, I never had this problem, and I didn’t have to set a range. Now, with Microsoft Excel, everything is chaotic. Does anyone know how to work around my problem and have it search the sheet for the row to be updated? Thank you!"

  • n8n version: 0.236.3
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Windows
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:
4

Hi @Fernanda_Silva, I am so sorry you are having trouble.

I had a look into this and was able to reproduce the problem. To be honest, I am not quite sure I understand how this node should handle Append or Update operations, but I reckon this is very much not it.

As such I will add this to our engineering backlog for a closer look and a fix. We will of course update this thread as soon as there is any feedback.

1 Like
6

Thank you so much!

7

New version [email protected] got released which includes the GitHub PR 8461.

1 Like
8

Thank you so much! You guys are awesome

1 Like
9

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