EXCEL format in webfocus 5.3

I'm running some webfocus reports using PERL script
The Perl script invokes the webfocus reports and download the file to my PC
In the previous version of webfocus I used to download an EXCEL file and it worked fine
Since version 5.3 the EXCEL file I'm trying to download is not readable by EXCEL (I have tried all EXCEL format) , It seems to contain a lot of HTML tag commands inside.
Any idea how can create in webfocus an EXCEL file that is readable by EXCEL

Posts: 6 | Registered: September 03, 2007

FortuneCookie

Platinum Member

posted

Hide Post

If you're using EXCEL that format hasn't changed for years.

If you're using EXL2K, generally when the extension is .xls Excel would be able to interpret it properly. I believe the format that is being used is a xlshtml.

Posts: 140 | Registered: May 02, 2007

Ignored post by FortuneCookie posted

Show Post

PBrightwell

Master

posted

Hide Post

Are you holding it ON TABLE HOLD FORMAT EXL2K?
Are you sure that you don't have some other error and are not getting the report? Are you running this thru Developers Studio or MRE?
Post your code (between

tags). Also, please update your signature to include the version and operating system.

Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes

Posts: 755 | Location: TX | Registered: September 25, 2007

Ignored post by PBrightwell posted

Show Post

ira

Platinum Member

posted

Hide Post

using aix 533 and wf 5.3.x - no problem dumping out to excel files on my end for a long time now. Can you post your code?
Thanks, Ira

aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0

Posts: 195 | Registered: October 27, 2006

Ignored post by ira posted

Show Post

Glenda

Guru

posted

Hide Post

What version of Excel are you on?

Glenda

In FOCUS Since 1990
Production 8.2 Windows

Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004

Ignored post by Glenda posted

Show Post

And

Member

posted

Hide Post

Hi,

I am working with originator ehudba.

When we invoke the fex, we pass it the parameter: "FORM=EXL97"

The first stage of the execution is as follows (before "pause" is one line):

c:\perl\bin\perl perfapi.pl market MARKET=All FROMMONTH=200805 TOMONTH=200805 PREPAID=N FORM=EXL97 OUTPUT=G:\Performance\Weekly_Report\PerlApi\NewSiteTest\Matket_data.xls
pause

"market" is translated into fex script name called by perfapi, and passing it "MARKET=All FROMMONTH=200805 TOMONTH=200805 PREPAID=N FORM=EXL97" as follows:

my $response = $browser->get($url, ":content_file" => $filename );

"OUTPUT=..." the output filename (becomes "$filename").

Printing $url gives:

http:// dhtupgbl.tdc.cingular.net:9010/ibi_apps/WFServlet?TOMONTH=200805&MARKET=All&IBIMR_random=qra81074536566&IBIF_ex=mktstats&IBIAPP_app=prodfex&PREPAID=N&FORM=EXL97&FROMMONTH=200805

(note: space in "http:// " included to block hyperlink generation.)

In the fex file, the report uses "FORM" as follows:

ON TABLE PCHOLD FORMAT &FORM
ON TABLE SUMMARIZE
ON TABLE SET STYLE *
-INCLUDE stybc4.fex
END
-RUN

The excel output is generated successfully when the same fex is called by an html form, also passing the "FORM=" parameter.

Lastly, from the perl script, only EXL97 successfully returns HTML output. Other Excel formats return an empty file.

This message has been edited. Last edited by: And,

Andrew

WF 53, HPUX 11.23

Posts: 3 | Location: TX | Registered: November 21, 2007

Ignored post by And posted

Show Post

ehudba

Member

posted

Hide Post

We are using WebFOCUS 535 Server on HP-UX B.11.23 32on64 bit 9000/800/SD64A

The FEX file is generating EXCEL file in the following command

ON TABLE PCHOLD FORMAT &FORM

when form can be EXCEL or EXL2K or EXL97
When we are running it from HTML page the EXCEL file is generated correctly
But when we are runing it from PERL program the file cant be read by EXCEL

This FEX is called by a PERL program

my $browser = LWP::UserAgent->new;
my $url =URI ->new('http://dhtupgbl.tdc.cingular.net:9010/ibi_apps/WFServlet');
...
# ** hashv is has all the paramters we are passing to webfocus: parameter=value
$url->query_form(%hashv);

# ** output sets to 1 if one of the parameter we pass is OUTPUT=filename

if ($output == 1)
{
my $response = $browser->get($url, ":content_file" => $filename );
die "$url error: ",$response->status_line unless $response->is_success;
}
else
{
my $response1 = $browser->get($url);
die "$url error: ",$response1->status_line unless $response1->is_success;
print $response1->content;
}

When we run it with EXL97 we get an HTML file with XLS extension

  
 
<HTML>
<HEAD>
<META name="HandheldFriendly" content="True">
<META name="PalmComputingPlatform" content="True">
<TITLE>FOCUS Report</TITLE>
<BASE HREF="http://dhtupgbl.tdc.cingular.net:9010/approot/prodfex/">
</HEAD>
<BODY>

When we run it with EXCEL format we get empty file

HTML>WebFOCUS Report
<script Language="JavaScript">
< !--
function getrep() {
if(parseInt(window.navigator.appVersion,10)<4)
location.assign("http://dhtupgbl.tdc.cingular.net:9010/ibi_apps/WFServlet?PG_REQTYPE=REDIRECT&PG_Func=GETBINARY&PG_File=agbpwuyf.xls");
else
location.replace("http://dhtupgbl.tdc.cingular.net:9010/ibi_apps/WFServlet?PG_REQTYPE=REDIRECT&PG_Func=GETBINARY&PG_File=agbpwuyf.xls");
} //-->

In webfocus 4.2 when we run the same program we get EXCEL 2.1 file

Please help

This message has been edited. Last edited by: ehudba,

Posts: 6 | Registered: September 03, 2007

Ignored post by ehudba posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

EXCEL format in webfocus 5.3

Focal Point | Privacy Statement | Terms of Service