When exporting to Excel with template Forecast Studio is looking for a batch file with a static name in the “Scripts” folder. The batch file should have the name "ExcelTemplateExport.bat " in the "%appmaindir%\scripts" . The file is called twice, but with different arguments, once before the export and once after.
Argument before the export:
“PRE” “excel”
Argument after the export:
“POST” “[TemplateName]”
If no Template name is selected Forecast Studio will export the load forecast to an Excel book named "AioProg.xls"