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,
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.
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.