Automatically Downloading XLSX in ODS Excel

[AndyTam]

Hello, is there a way to automatically generate a pre-formatted XLSX?  The reason is that I need to set a timer to generate a XLSX.  Proc export is not useful because it is stripping the formatting; setting up a libref (libname ... xlsx) also seems to be a data-dump only.  Now, ODS has formatting, but I need to manually download the XLSX.  Is there some way to automate the downloading?  Thanks!

ods Excel file="&SASFolder.&FirstReport"
	style=Journal
	options(sheet_name="Data" frozen_headers="1");
proc print data=FirstReport noobs; run;
ods Excel close;

[Reeza · Accepted solution]

What do you mean by manually download? That may be a limitation of your set up unfortunately.

[AndyTam]

Actually ODS is already saving a formatted copy into my destination folder. I was asked to download it if I want to open it via EG. So it's an unrelated step.

[ChrisHemedinger]

You can use the Copy Files task for this and automate in your flow.  Here -- I have a video tutorial (11 minutes within this much larger tutorial) that shows how to do this.