topic Accessing Excel file from server and generate the same as an output to the stored process. in Developers

Accessing Excel file from server and generate the same as an output to the stored process.

Micheal_S — Mon, 08 Aug 2016 13:20:46 GMT

Hello..

I am trying to create a stored process, in which i have to just grab already created excel report from the server and produce the same (without any changes) as an output of the stored process execution. i am trying to do this using stpsrv_header but its not working.

data _null_;
rc= stpsrv_header('Content-type', 'application/vnd.ms-excel');
rc= stpsrv_header('Content-disposition', 'attachment;
filename=outtest.xls');
run;

Did anyone tried this before? Please let me know.

Thanks,

Mike

Re: Accessing Excel file from server and generate the same as an output to the stored process.

Kurt_Bremser — Mon, 08 Aug 2016 13:55:59 GMT

Have you tried my suggestion I gave you in the other thread about the same issue?

Re: Accessing Excel file from server and generate the same as an output to the stored process.

Micheal_S — Mon, 08 Aug 2016 14:05:49 GMT

Yes Kurt, I tried it.

rc = stpsrv_header('Content-disposition','attachment; filename="test.xls"');

Its not giving me any error message but not doing what i intended for. Its just getting executed successfully and no result is coming out.

Re: Accessing Excel file from server and generate the same as an output to the stored process.

LinusH — Mon, 15 Aug 2016 04:39:08 GMT

Since this doesn't involve any SAS processing the feels a bit unnecessary to use a Stored Process. Consider using other Web aplication server functionality for this.

Re: Accessing Excel file from server and generate the same as an output to the stored process.

boemskats — Wed, 24 Aug 2016 15:46:15 GMT

Michael,

This should work. Have a look at the second half of this post that I wrote ages ago.

You need to use the STP webapp, you need to have Streaming output enabled. Here's the code from the other post.

  filename myFileInput="/myTempFileLocation/&filenameParameter..xml";
  %let RV=%sysfunc(stpsrv_header(Content-type,application/vnd.ms-excel));
  %let RV=%sysfunc(stpsrv_header(Content-disposition,attachment; filename= Histostaffperformance.xml));
  data outmenow;
    length data $1;
    infile myFileInput recfm=n;
    file _webout recfm=n mod;
    input data $char1. @@;
    put data $char1. @@;
  run;

Good luck.

Nik

Re: Accessing Excel file from server and generate the same as an output to the stored process.

Micheal_S — Wed, 31 Aug 2016 10:00:24 GMT

Hi Boemskats,

Thank you,

Greatly appreciate it.