Customize Excel Report

Hi There!

I'm using this library tabletoExcel for my report generation in excel. But it has some limitations like If I want to add a chart or any picture on it. which is not possible.

Idea is to get data from the database and create a report out of it with excel (and the most preferred option is PDF). Can you guide me on the below option ( by continuing on this library or any replaceable library for this)

  1. how can I add a picture or chart to my excel generated sheet from the nodered?
  2. what is the preferred option for PDF generation from nodered?

P.S: I use this library for a reason as I've not found any node that can create customized excel sheets that I needed.