I want to access to an excel file, which is on the FMEServer Resouces Folder. Because i have to read out some values from this excel i put into an pythonscript, which build an XML Filter for a WFS Reader. The pythonscript is in a private Parameter. I have the following code:

import fme

import xlrd

list_gemeinden = ]

#loc = ("C:\\Temp\\gemeinde.xlsx") 

loc = fme.macroValuesu"ExcelAuswahl"] #$(FME_SHAREDRESOURCE_TEMP)\\gemeinde.xls is the content of parameter ExcelAuswahl

Is this correct or I'm totally wrong?

Best Regard