Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Excel Template Question

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Excel Template Question
 Login/Join
 
DeniseH
Member
posted
I have a report that I am creating using an Excel Template. This report needs a new worksheet for each sort break. I get the following error if there are more reports to create than worksheets defined in the template:

(FOC3292) TEMPLATE FILE: Sheet/Slide number does not exist in template

If I add another worksheet to the template that error goes away. I searched the forum for this error, but did not find any posts about it. My question is do I need to create many blank worksheets in the template to hold all the reports or is there a way to create the worksheets on the fly? I am using the Auto_open macro to reformat each worksheet, so I could delete unused ones. But if the template has too few of them, then the users will get the above error.


WF 7.1.7 Win 2003
SQL Server
Self Service/ReportCaster
Output: HTML, Excel, PDF
 
Posts: 6 | Location: St. Louis, Mo | Registered: October 24, 2006Report This Post
nubi
Guru
posted Hide Post
SEARCH THE FORUM FOR .XHT

if i remember rightly you have to define multiple templates and use the previous template as the basis for the next...

you define a template per report/hold file but look it up- its explained in a previous post...


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Report This Post
DeniseH
Member
posted Hide Post
That was what I was thought I had to do. I did search the forum for the answer to my question before posting, but did not find it.

Also, I did not have to define multiple templates, only 1 was needed. Each report uses the previous report's output hold file that has been APP FI as an .mht file. But I wanted to know if there was a way to dynamically create the worksheets as a variable number will be produced or if I needed to have a max number of worksheets predefined in the template for each possible report.

I could not have gotten the report as far as I did without all the posts that explain excel templates and how to use them. This is a fabulous resource to use.

Thanks for the quick response.

Denise


WF 7.1.7 Win 2003
SQL Server
Self Service/ReportCaster
Output: HTML, Excel, PDF
 
Posts: 6 | Location: St. Louis, Mo | Registered: October 24, 2006Report This Post
Tony A
Expert
posted Hide Post
Denise,

I tried this many moons ago and did not find a way to dynamicaly add sheets. So what I do now is to create the template with the maximum number of worksheets that the process is likely to require and then have a deletion process in the macro to remove those that are not used. I also have a variable called &max_sheets (or similar) within the WF code to ensure that the incoming reports do not exceed the maximum number of worksheets I have prepared in the mht.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
nubi
Guru
posted Hide Post
quote:
Originally posted by DeniseH:
That was what I was thought I had to do. I did search the forum for the answer to my question before posting, but did not find it.

Also, I did not have to define multiple templates, only 1 was needed. Each report uses the previous report's output hold file that has been APP FI as an .mht file. But I wanted to know if there was a way to dynamically create the worksheets as a variable number will be produced or if I needed to have a max number of worksheets predefined in the template for each possible report.

I could not have gotten the report as far as I did without all the posts that explain excel templates and how to use them. This is a fabulous resource to use.

Thanks for the quick response.

Denise


Souns like you are more than familiar with the process- and sorry i should have said do a search for .mht - lukjcily you know what i meant-
sorry i can't be anymore help- i think Tony A probably has the best solution for this


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Report This Post
DeniseH
Member
posted Hide Post
Tony - I had not thought about checking for the max sheets in my fex. I will incorporate that to put out a nicer message to the users. Currently the report would create up to 17 worksheets. Yesterday I set up the template with 40 worksheets, so I am protected for a while. Thanks for suggesting that.

Denise


WF 7.1.7 Win 2003
SQL Server
Self Service/ReportCaster
Output: HTML, Excel, PDF
 
Posts: 6 | Location: St. Louis, Mo | Registered: October 24, 2006Report This Post
Tony A
Expert
posted Hide Post
No problem Denise, one of the great things about this forum is that when we've had a problem such as this, there is always a way forward that someone has found.

The template I developed had to deal with a max. 60 worksheets - or so the end user declared - so when it only ever contained 60 and they said "there's quite a few missing" they actually when away, did some analysis and came up with a max of 67. Nice to add a bit of comfort zone though Wink. It now produces about 20 versions (project related) with between 30 and 70 worksheets.

Good luck

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
PBrightwell
Master
posted Hide Post
I had always created my template with only the sheets with the formulas and created my WebFocus worksheets behind them and started numbering them with the next sheet number. I named my sheets so that my formulas were pulling from the sheets by name.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Excel Template Question

Copyright © 1996-2020 Information Builders