Focal Point
[CLOSED] Populating multiple Excel tabs in webfocus

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2977060096

May 01, 2018, 02:39 PM
PO
[CLOSED] Populating multiple Excel tabs in webfocus
Is there a limit as to the number of worksheets that could be populated with a webfocus report?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8105
Windows, Excel
May 01, 2018, 06:04 PM
FP Mod Chuck
PO

I am not aware of any limit, I assume you are using the Table of Contents option to force the creation of multiple tabs (worksheets).


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
May 02, 2018, 05:27 AM
Frans
Note the number of worksheets is
limited by available memory on the user's machine.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
May 02, 2018, 10:10 AM
jgelona
I have a job that creates over 100 worksheet in one workbook.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
May 02, 2018, 12:48 PM
PO
quote:
Originally posted by jgelona:
I have a job that creates over 100 worksheet in one workbook.

Do you use only COMPOUND ON?


WebFOCUS 8105
Windows, Excel
May 03, 2018, 08:35 AM
PO
No I am not using a table of content to create multiple tabs. Should I be using that?


WebFOCUS 8105
Windows, Excel
May 03, 2018, 08:49 AM
Francis Mariani
PO, may I suggest you tell us what you're attempting to accomplish?

If WebFOCUS could create a spreadsheet with 5000 tabs, how does that help?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 03, 2018, 01:07 PM
jgelona
In my report the sheets are looping through the code. I have an & variable name &OPEN. On the first pass the value is OPEN. On the last pass the value is CLOSE. All the passes in between the value is blank.

ON TABLE PCHOLD FORMAT XLSX &OPEN

This is a summary report. The first pass is a state wide summary. The next 5 passes are Region Summaries. The rest of the passes are for each County.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.