Focal Point
[CLOSED] EXL07 Template WF8 errors

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

April 15, 2015, 01:57 PM
gregv
[CLOSED] EXL07 Template WF8 errors
Hi FOCUSed developers,
I've done the searches, read the docs and tested many possibilities with no success.
I used Excel templates extensively about 10 years ago but things have changed.

I'm looking for an example of a excel template which is pre-designed (I can create one on the fly with BYTOC and then load the sheets but I need a pre-designed output). I need Sheet 1 with multiple reports and Sheet 2 through Sheet n that Sheet 1 links to.
In other words, there are links (references) in the cells of Sheet 1 that link to cells in either Sheet 2 or Sheet n.

Output is EXL07 using WF 8.009

I'm getting the following error from a template I created in Excel07 using several extensions in my tests: xlsx, xltm, xlsm, and mht.
(FOC3289) TEMPLATE FILE: Error opening file
(FOC3317) Error processing template file.

PS.I checked WF Admin console to verify that these extensions do exist.

Thanks for any guidance or guesses.

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



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
April 16, 2015, 03:15 AM
Tony A
Hi Greg,

At which point do you get the error, at the first template, the second ....?

I posted the following code last August, it might trigger some thoughts?
-* File exl07_template.fex
SET EMPTYREPORT = ON

TABLE FILE CAR
  SUM RCOST
      DCOST
   BY COUNTRY
   BY CAR
   BY MODEL
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE HOLD AS CAR1 FORMAT EXL07 TEMPLATE 'exl07_template.xltm' SHEETNUMBER 1
END
-RUN

TABLE FILE CAR
  SUM RCOST
      DCOST
   BY COUNTRY
   BY CAR
   BY MODEL
WHERE COUNTRY EQ 'ITALY'
ON TABLE HOLD AS CAR2 FORMAT EXL07 TEMPLATE 'car1.xlsm' SHEETNUMBER 2
END
-RUN

TABLE FILE CAR
  SUM RCOST
      DCOST
   BY COUNTRY
   BY CAR
   BY MODEL
WHERE COUNTRY EQ 'W GERMANY'
ON TABLE PCHOLD FORMAT EXL07 TEMPLATE 'car2.xlsm' SHEETNUMBER 3
END
-RUN

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 
April 16, 2015, 12:40 PM
Rifaz
Hi Tony,

Ran your code and I got the error at the first point itself.

0 NUMBER OF RECORDS IN TABLE= 4 LINES= 4
(FOC3289) TEMPLATE FILE: Error opening file
(FOC3289) TEMPLATE FILE: Error opening file
(FOC3317) Failed to unzip EXL07 template file

Recently, i had to use macro in one of my requirement but with no luck. But, i too remember sometime back, was succeed on this.I don't know where I'm going wrong now.
Merging cells using CSS - Excel


-Rifaz

WebFOCUS 7.7.x and 8.x
April 16, 2015, 01:52 PM
gregv
I saw your code, Tony, and ran it.
It runs fine with a simple CAR file report.

My report has 4 sections on sheet 1 that is populated from sheet 2 through sheet 5 with links in the cells.
As soon as I try to populate this I get the template error.
I appreciate you code and it did verify that the basics work.

Thanks and keep the ideas coming.

PS: I've opened a case on this and will report back when this is solved.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
April 20, 2015, 11:24 AM
Kevin W
In webFocus 8 I would consider going with FORMAT XLSX instead of FORMAT EXL07.


WebFOCUS 7.7.05 (Someday 8)
Windows 7, All Outputs
In Focus since 1983.
April 20, 2015, 11:37 AM
gregv
Kevin W,
From the documentation, they should be the same:
"FORMAT EXL07 and FORMAT XLSX are synonyms and can be used interchangeably. The FILE
SAVED message will always display "XLSX FILE SAVED", regardless of the syntax specified."

Thanks.



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8
April 21, 2015, 09:40 AM
Kevin W
It was explained to me that EXL07 didn't do the full XML that comes with XLSX. But perhaps that is comparing our 7.7.05 system to our 8.1.03. Maybe they made them synonomous in 8.1.0.3. Still I see a lot of caveats in the 8.1.0.3 doc that XLSX still doesn't have quite all the features that were in EXL07. So I wonder. Here is the most recent XLSX document that I have: http://documentation.informati...f_wf_8009/TM4690.pdf


WebFOCUS 7.7.05 (Someday 8)
Windows 7, All Outputs
In Focus since 1983.