Getting the following error from OAscheduler log: 3/20/20 2:07:36 AM - OAExec. • Export into Excel failed. COAExcel: CloseExcel SaveAs method of Workbook class failed Probably the output file C:\BRIGHTSTOR SRM DATA\DATABASE\Doc\FHB Storage Groups GT 85%.XLSX is locked for editing by another application or there is security problem.
Release : 14.0
Component : CA Vantage Storage Resource Manager
Microsoft Excel component that WC uses, exporting data into .XLSX (Excel Workbook) file cannot be made reliable when WC Scheduler is running as a service. Unfortunately, Microsoft changed their restriction in Excel.
With respect to this fact we recommend the following circumvention:
You should update your scheduled tasks to export data into CSV format, not xlsx format. The recipient then will import the CSV format as an excel file
To make it more easier for you, we recommend to update windows setting (list separator) to character ";" List separator settings is under settings -> region $ language -> additional date, time, & regional settings -> change date, time, or number formats -> additional settings
Permanent fix for this limitation is planned for future release of WebUI. This solution is for the Scheduler running as a Service.
Otherwise, if you just need the excel file, you still can use scheduler as application but then there is a need of a logged in user on the machine.