topic Excel multiple sheet output using Stored Process in Developers

Excel multiple sheet output using Stored Process

dipanarya1 — Wed, 19 Sep 2018 17:31:26 GMT

Hi Team, We are trying to provide an options to generate the RTF, PDF and Excel file using STP. We are able to generate an output in RTF and in PDF format, but while trying to generate the Excel file the STP is giving the _webout related error, attached log file and below is the code snippet.

Re: Excel multiple sheet output using Stored Process

dipanarya1 — Wed, 19 Sep 2018 17:32:41 GMT

Attached log file.

Re: Excel multiple sheet output using Stored Process

dipanarya1 — Wed, 19 Sep 2018 17:51:19 GMT

Please note the macro attached in first post is being called up in SAS STP.

Re: Excel multiple sheet output using Stored Process

AllanBowe — Wed, 19 Sep 2018 21:06:55 GMT

How are you calling the STP? From EG, a web browser, Excel?

If you are calling it from a web browser I'd suggest setting to `stream` output and removing the automatic `%STPBEGIN;` / `%STPEND;` macros. This will ensure that any output sent to the `_webout` fileref will be received 'cleanly' by the client. If downloading files then you will also have to set the http headers, eg:

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