Microsoft Excel 365 node Lookup table taking super long

Questions
1

Hello,

Describe the problem/error/question

I’m using excel node to do some lookup in excel file that has currently ca 20000 rows and the lookup takes really really long (minute or more) and im wondering how the lookup is actually working (i have impression that it does in background tons of calls to excel 365 api and checks row by row).
I came to this conclusion since it seems like i hit api rate limit on that alone when doing lookup just few times 1 after another.

Information on your n8n setup

  • n8n version: latest stable cloud
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:
3

Hi @Andrzej ,

To iterate over a worksheet, the node makes one API call iterating all the requested rows, instead of one call per row. Given the data size, this can become slow.
What I would suggest here is to split the request in batches. You do two smaller calls rather than such a big one and this should help speed up the running time.

For reference, here is our code for the API calls done in this action, in case you would like to take a closer look at how it is set up behind the scenes: n8n/packages/nodes-base/nodes/Microsoft/Excel/v2/actions/worksheet/readRows.operation.ts at master · n8n-io/n8n · GitHub :slight_smile:

4

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