Excel to PDF

All,

I would like to be able to take an excel file and convert this into a PDF file, is this possible in Knime?

Thanks,

The simples way to do this is using

node.

3 Likes

You would like to save an existing Excel file with images and formats etc. as a pdf?
I don’t think Knime can do that.
The quick and dirty variant: Open Excel file, save as PDF and close Excel.
You can use a Python node to do that, Something like that:
from pandas import DataFrame
import win32com.client

o = win32com.client.Dispatch(“Excel.Application”)

o.Visible = False
wb_path = r’c:\temp\temp.xlsx’
path_to_pdf = r’c:\temp\temp.pdf’
wb = o.Workbooks.Open(wb_path)
ws_index_list = [1] #tabelle1
wb.WorkSheets(ws_index_list).Select()
wb.ActiveSheet.ExportAsFixedFormat(0, path_to_pdf)
wb.Close()
o.Quit()

output_table = DataFrame()

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.