ODS Excel file webout in SAS Viya

[harshpatel]

Hello Folks,

I am trying to run the below code in SAS Studio in SAS Viya

data _null_;
rc = appsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
rc = appsrv_header('Content-disposition','attachment; filename=test.xlsx');
run;

ods excel file = _webout ;

title "&title";
proc print data=sashelp.class;
run;
ods excel close;

But it is showing error that 

Program error.
68-185: The function APPSRV_HEADER is unknown, or cannot be accessed.

Actually i want to link this code with my graphs to download the excel file.

Please help

Regards,

Harsh Patel

[Kurt_Bremser]

The APPSRV_ functions are part of the Application Dispatcher, which is a SAS/IntrNet 9.4 component, and not available in Viya.

See https://documentation.sas.com/?docsetId=dispatch&docsetTarget=require.htm&docsetVersion=9.4&locale=e... 

[harshpatel]

Thank You for your answer.

But what is the solution of my question whether i could download the excel file with this code or any alternate code?