01-14-2015 05:31 PM
I am getting below issues in 9.4 with Excelxp tagsets version v1.130, but not seen these issues in 9.2 by using exactly same excel statements in Stored process
1. Using Stored process Execution result is Stream, disabled %STPBEGIN & %STPEND macros in stored process
2. using below code in stored process
ods listing close;
rc = stpsrv_header('Content-type','application/vnd.ms-excel');
rc = stpsrv_header('Content-disposition','attachment; filename=report.xls');
ods tagsets.ExcelXP file=_WEBOUT options(doc="Help" default_column_width='15, 4, 20, 25, 10' width_fudge='0.75' sheet_name="REP1") style=sansprinter;
proc report data= Final nowd;
ods tagsets.ExcelXP close;
By using above , i am not getting any error while running the stored process from information delivery portal except column adjustment issue in excel, but getting attached popup window and generating HTML code in EG. How to avoid this issue while running from EG also
even I tried with file='a.xls' in ods statement, but still not seeing result in both EG and IDP.
As attached i am seeing more column width than data length, Excel Column width is occupying almost variable length defined in dataset, but real scenario data length is varying in dataset. How to make exact auto_column_width for all character and numeric columns.
Can anyone help me on this.
01-15-2015 03:52 PM
Ah, sorry, did not see that image file. The error message is telling you the problem. The stored process you wrote was set to create STREAMING output results. This will work in the Information Delivery Portal because the web browser can open Excel as a "helper" file to read the contents sent by the stored process. EG on the other hand can only receive certain types of output from a stored process. EG cannot open a "helper" file like a browser can. If you had posted this question in the stored process Forum, you probably would have found more relevant help.
Your STPSRV_HEADER change is telling the receiving application to open use Excel to open the streamed stored process results. So your problem is twofold: 1) EG doesn't use streaming output (specifically, the _WEBOUT file reference is designed only for WEB clients and EG is NOT a web client) and 2) EG can't open Excel in the same way that the Portal can. You might want to work with Tech Support on this.