OK, so revised attached workflows deal with the xlsx issue. To summarise:
Report_Workflow.knwf (19.4 KB) - modified to use xls reader, and a quickform to create a parameter for the path to the input
Report_Name.knwf (20.0 KB) - Modified to create report pdf filename from the name of the xlsx file, which is now in the input table. Note that you need to escape \ in the path to the xlsx file. The JSON format to pass the parameter is a bit un-intuitive (see e.g. https://www.knime.com/forum/knime-general/awkward-column-typing-in-call-remote-workflow-node). If you want to run for multiple xlsx, with 1 report per file, then replace the Table Row to Variable node with a Table Row To Variable Loop Start node, and finish the loop with a Variable Loop End node. Then a separate email will be send for each xlsx file
The second issue, regarding the email node is dealt with as follows:
1 - enter something in the attachments tab for the first attachment (it doesnt really matter what, it will be ignored). You should now see another, empty row appear:
2 - In the flow variables tab, scroll down to attachedURLs and expand. In the box next to ‘0’, select the flow variable with the report filename:
3 - If you new check back in the attachments tab - you should see a warning that the parameter ‘0’ is controlled by a variable:
The excel input file used was testin.xlsx (11.7 KB)
Hope this helps,
Steve