Unable To Load Excel Lists From Workbooks / Worksheets

Describe the issue/error/question

Lists to select an Excel workbook or worksheet no longer populate

What is the error message (if any)?

  • There was a problem loading the parameter options from server: “Bad request - please check your parameters”

Please share the workflow

{
  "nodes": [
    {
      "parameters": {
        "operation": "addWorksheet",
        "additionalFields": {}
      },
      "name": "Microsoft Excel",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        460,
        300
      ],
      "typeVersion": 1,
      "credentials": {
        "microsoftExcelOAuth2Api": {
          "id": "21",
          "name": "Microsoft Excel account"
        }
      }
    }
  ],
  "connections": {}
}

Other Info

I’ve verified the connection to Excel works properly as I can get workbooks, download them, copy them, etc. as seen here:

Here’s what happens when I try to add a worksheet:

Information on your n8n setup

  • n8n version: 0.157.1
  • Database you’re using (default: SQLite): MySQL
  • Running n8n with the execution process [own(default), main]: own
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: npm

I just tested it, and it works fine for me. Did you try setting the Workbook ID with an expression? Since you can list the workbooks, you can grab the ID and put it with an expression in the meantime.

1 Like

Looks like that did the trick for what I needed! It didn’t work for Worksheet > Get All with the ID specified, but Get Content with the specified did work. Thanks Ricardo!

1 Like