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.macroValues["ExcelAuswahl"] #$(FME_SHAREDRESOURCE_TEMP)\\gemeinde.xls is the content of parameter ExcelAuswahl
Is this correct or I'm totally wrong?
Best Regard
