ODS EXCEL

[Ronein]

Hello

I am working at my work with SAS enterprise guide 5.1

I am trying to work with ODS excel (to learn it).

When I run a code I get en error

ERROR: Unable to load module 'SpreadsheetML' from template store!
ERROR: No body file. EXCEL output will not be created.

Maybe This SAS version doesn't support ODS excel?

or maybe there is an error in the code?

ods excel file="/My path/example1.xlsx"
options(embedded_titles='yes'
embedded_footnotes='yes'
tab_color='purple' 
start_at='2,4');
title 'This title will appear in the worksheet';
footnote 'This footnote will appear in the worksheet';
proc report data=sashelp.class;run;
ods excel close;

[SASKiwi]

What SAS version are you using? ODS Excel was introduced in 9.4 TS1M3 I'm pretty sure.

In the EG Server List, right click on your SAS App server (called maybe SASApp), select Properties, then select the Software tab. This will tell you what version of SAS you are using.  

[Jagadishkatam]

please use the below code to know the sas version

this will give the sas version in sas log.

proc setinit;
run;