Hi,
Please use URL of report which is created under report witter and add &DataFormat=XLS with URL, you will get the report in excel format,
or you can make a scheduler and select the URL instead of report at a time when you are creating a scheduler.
Localhost/.../Report.aspx&DataFormat=XLS
Thanks
K