Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Output Format Exl2k using Repeat command
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Output Format Exl2k using Repeat command
 Login/Join
 
Member
posted
-DEFAULT &NUM_RECORDS=0;
-SET &NUM_RECORDS = IF &NUM_RECORDS EQ 0 THEN 1 ELSE &NUM_RECORDS;
-REPEAT LAB1 &NUM_RECORDS TIMES
-TYPE Hello World
-LAB1

I need the output in Excel format.

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS version 8.0.09
Windows 8.0
 
Posts: 13 | Registered: November 28, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
jsn,
Do you want to output "Hello World" to XL?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1932 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Yes.

If I passed the parameters for example 2 times means Hello World should display in Excel 2 times.


WebFOCUS version 8.0.09
Windows 8.0
 
Posts: 13 | Registered: November 28, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Ok.
Well in order to output to XL you have to use a TABLE command with the option ON TABLE PCHOLD FORMAT EXL2K. This means that first you have to write your HELLO WORLDs into a file, then create a MASTER for this file, and lastly use the TABLE command to read the file and output to XL.
Need help for that?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1932 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Member
posted Hide Post
quote:
ON TABLE PCHOLD FORMAT EXL2K.

Yes Please. Please give me a sample


WebFOCUS version 8.0.09
Windows 8.0
 
Posts: 13 | Registered: November 28, 2007Reply With QuoteReport This Post
Master
posted Hide Post
How about this:

TABLE FILE SYSCOLUM
	PRINT COMPUTE THEROW/A13 = 'Hello world';
	BY	TBNAME	NOPRINT
WHERE RECORDLIMIT EQ 1
ON TABLE HOLD AS HOLD_ROW
END

-SET &COUNTER = 0;

TABLE FILE HOLD_ROW
	PRINT THEROW	AS 'Column name'
ON TABLE PCHOLD FORMAT EXL2K

-START_LOOP
MORE
FILE HOLD_ROW
-SET &COUNTER = &COUNTER + 1;
-IF &COUNTER GE 99 THEN CONTINUE ELSE GOTO START_LOOP
END


G'luck


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 669 | Location: Veghel, The Netherlands | Registered: February 16, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
That's pretty slick Dave.


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
 
Posts: 149 | Location: Dallas, TX | Registered: June 08, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Output Format Exl2k using Repeat command

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.