Skip to main content
  • EN

Hi All,

I have successfully developed an automation process that customises and exports a table to Excel format. The final transformer in the workflow is a FeatureWriter, which generates the Excel file.

I am now looking to convert this Excel output into a PDF format. However, my attempts using the available FME PDF transformers have not been successful.

Could anyone advise on how to achieve this using FME? I have read that SystemCaller or a PythonCaller script might be viable options.

Thanks :)

Have a look at the brand new Document PDF Writer package from Safe, it replaces the old PDF writer and is a big improvement: https://hub.safe.com/publishers/safe/packages/documentpdf

Else, you could use a PythonCaller after your FeatureWriter. I think the xlwings python module can print excel files :
 

import xlwings as xw

wb = xw.Book(r"C:\path\to\yourfile.xlsx")

wb.api.ExportAsFixedFormat(0, r"C:\path\to\yourfile.pdf")

wb.close()
 

Community Stats

31,897
Posts
121,119
Replies
39,512
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.