Is there a way in n8n to pass a value to a specific Excel cell without using ExcelJS

Questions
1

Is there a way in n8n to pass a value to a specific Excel cell without using ExcelJS?

2

@Borelli theres no native node that targets a specific cell like B5, the Excel 365 node and the spreadsheet file nodes are all row/table based so cell-addressing just isnt a built-in operation. but you can skip exceljs, if the workbook lives in onedrive/sharepoint you point an HTTP Request node at the graph range endpoint (…/worksheets(‘Sheet1’)/range(address=‘B5’), PATCH with {“values”:[[“yourvalue”]]}) and set auth to predefined credential type so theres zero code. is your file in onedrive/sharepoint, or a local file moving through the workflow as binary?

3

Hi @Borelli

To update a specific cell without ExcelJS, the best method is to use the HTTP Request node to call the Microsoft Graph API directly.

How to use this:

  1. Copy the JSON block above.
  2. Open your n8n workflow and Paste (Ctrl+V or Cmd+V) it directly onto the canvas.
  3. Configure the “Configure Excel Cell” node​:
    • Replace YOUR_FILE_ID_HERE with your actual Excel File ID.
    • Update the sheetName (e.g., “Sheet1”) and cellAddress (e.g., “B5”).
  4. Configure the “Update Specific Cell” node​:
    • Click on the node and select your existing Microsoft Excel OAuth2 API credentials from the dropdown.
  5. Run the workflow​.