Excel 365 Delete Row And Shift Up

Questions
1

Hi,

Is there a way to use the Excel 365 node to delete a row from the middle of a worksheet, and shift the remaining/lower rows up in to its place? (just like deleting a row using the UI)

Currently we can get the node to blank out the contents of the row we intend to delete by using the node’s Sheet->Clear function and specifying the row as a range. But I can’t find a way to make the remaining rows shift.

According to the API docs, there’s a “shift” parameter that could be set to “Up” to do this. Range: delete - Microsoft Graph v1.0 | Microsoft Learn

Thanks!

image
image434×915 20.1 KB

Information on your n8n setup

  • n8n version: 1.70.2
  • Database (default: SQLite): n/a
  • n8n EXECUTIONS_PROCESS setting (default: own, main): n/a
  • Running n8n via (Docker, npm, n8n cloud, desktop app): n/a
  • Operating system: n/a
2

hey @jzrts

Sorry for the late response here. If there’s an API option that would be the best way, have you considered adding an http node after row deletion to make that happen?

3

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