Insert image in Excel file

Questions
1

Hello,

I’m querying an API that allows me to download images from a list in an Excel file, and I’d like to be able to insert these images into the cell corresponding to the row being processed.

Is this possible?

Thanks in advance.

Information on your n8n setup

  • n8n version: 2.16.2
  • Database (default: SQLite): sqlite
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: linux
2

Hi @flipflip
I think using a service like Supabase would bring more ease to this operation, as in excel the native node does not support any notation which would help you achieve that, and so you have to do HTTP request and maybe that might have its limitations, but feel free to try the HTTP request approach.

4

@Anshul_Namdev : Unfortunately, the images absolutely must be visible in the file for offline viewing. I know this isn’t the ideal solution, but I don’t have any other options at the moment.

@Benjamin_Behrens : Thank you, I will test this solution.

5

hi @flipflip, Benjamin’s Code node + ExcelJS approach is the right call for embedding images directly in cells. One gotcha — ExcelJS isn’t bundled in n8n’s sandbox by default, so in your docker setup you’ll need to install it first with docker exec -it n8n npm install exceljs and allow it via NODE_FUNCTION_ALLOW_EXTERNAL=exceljs env var, otherwise the Code node will throw a require error.