I'm working with FME desktop and server 2014.
Desktop :
In order to write an excel file with the Sheet Order correctly set up (the "sheet order" Format Paramters doesn't work correctly), the only solution I found was to :
1/ Copy a template xls file in the destination (with a filecopy transformer)
2/ Re-write this file with an XLS writer.
That works fine !
Server :
Once this workspace uploaded, I'm face the following problem (in data download mode) :
1/ The copied file end up necessarily in a folder (either in a folder named "dataset" or in a folder which corresponds to the name given in the workspace parameters) - There is no way to put it just at the root of the zip file.
2/ The xls file writen can only be placed at the root of the zip. I can not specify a folder.
?Then there is no possibility to do the re-writing operation.
Home i'm clear enough. Any tipps ?
CU