problem with ExcelToPDFWriter

I've installed the phyton stuff right and copied the two .dll files correctly

but always the same error.......I'm not the phyton guru but it would be very nice if i yould test this transformers for an important task or is another possibility to convert excel sheets to pdf in the meantime in the new 2022 release?

here is my error message:

Python Exception <ModuleNotFoundError>: No module named 'win32api'

Error executing string `"""

Converter from Excel (.xlsx) to PDF (.pdf).

This module depends on the following modules:

- pywin32

To install open an elevated command prompt and enter: pip3 install <module_name>.

Heijmans

18-04-18

Rob Braggaar

"""

import win32com.client

import fme

import fmeobjects

def main(feature):

logger = fmeobjects.FMELogFile()

input = str(feature.getAttribute('filepath'))

sheets = str(feature.getAttribute('sheets'))

sheets = sheets.split(',')

for idx in range(len(sheets)):

sheets[idx] = int(sheets[idx])

def convert(in_wb_path, out_pdf_path):

""" Converts input file to output pdf """

print('Input: ', in_wb_path, '\\nOutput:', out_pdf_path)

excelHandler = win32com.client.Dispatch("Excel.Application")

excelHandler.Visible = 0 # do not show Excel to the user

print('Starting conversion...')

wb = excelHandler.Workbooks.Open(in_wb_path, ReadOnly=1)

print('Workbook opened...')

# Excel sheets to export to the pdf destination.

ws_index_list = sheets

logger.logMessageString('Exporting sheets: {}'.format(str(sheets)))

print('Selecting worksheets {}...'.format(ws_index_list))

wb.Sheets(ws_index_list).Select() # WorkSheets

print('Worksheets opened...')

wb.ActiveSheet.ExportAsFixedFormat(0, out_pdf_path)

print('Done.')

# process wrap up

# close the workbook

excelHandler.Workbooks.Close()

# quit the Excel process

excelHandler.Application.Quit()

convert(input, input.rstrip('.xlsx') + '.pdf')'

Factory proxy not initialized

ExcelToPDFWriter_ConvertPDF (PythonFactory): PythonFactory failed to process feature

ExcelToPDFWriter_ConvertPDF (PythonFactory): A fatal error has occurred. Check the logfile above for details

Excel Reader: Closing dataset 'D:\\Projekte\\R796_Excel\\JULY_OP\\BGU\\PA7\\08_Labor\\x_Probedaten\\Probenlisten\\PA7_BK-Lager_Münnerstadt_Probenliste_gesamt_20220624.xlsx'...

Styles created: 303

Excel Reader: Closing dataset 'D:\\Projekte\\R796_Excel\\JULY_OP\\BGU\\PA7\\08_Labor\\x_Probedaten\\Probenlisten\\PA7_BK-Lager_Münnerstadt_Probenliste_gesamt_20220624.xlsx'...

A fatal error has occurred. Check the logfile above for details

Translation FAILED with 6 error(s) and 0 warning(s) (0 feature(s) output)

FME Session Duration: 3.3 seconds. (CPU: 0.7s user, 0.5s system)

END - ProcessID: 2284, peak process memory usage: 100972 kB, current process memory usage: 76128 kB

A fatal error has occurred. Check the logfile above for details

Program Terminating

Translation FAILED.