I'm creating a new excel file nightly and some nights there will be no data to populate the excel file, but I need the file to be created anyways. Is there a step in the Excel writer that I'm missing to do this?
Solved
Always create excel file even if data is empty
Best answer by erik_jan
FME will create a file when the first feature is written. So when no features are written, no file will be created. I see two ways of bypassing this issue:
- Always create an empty record by writing a feature with no values (but that leave you with a XLS file with an empty line, even if data is written).
- Use the option not to write Filed Names first and create (using Creator and AttributeCreator) a feature with the field names as the first feature to write. That will create the file using the field names as first line.
Hope this is useful.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.