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     Does WebFocus support excel 2013 output ?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Does WebFocus support excel 2013 output ?
 Login/Join
 
Platinum Member
posted
One of my requirement from customers is set the output file to Excel 2013. I checked and saw that it just support until Excel 2007. My WF version is 7703.


WebFOCUS 7.7.03
Windows, All Outputs
 
Posts: 125 | Registered: June 17, 2013Report This Post
Expert
posted Hide Post
EXL2K works fine Excel 2010 / 76x. Not sure what Excel 2013 is (yet). Have you tried to open an EXL2K formatted output in Excel 2013?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Platinum Member
posted Hide Post
My customers's desktop use Excel 2013. Whenever they do export to Excel2K, they got the message box said the file is in the incorrect format. Then it open back to Excel 2007. I don't know if WF have the option to let report only be exported to Excel 2013 or Excel 2000.


WebFOCUS 7.7.03
Windows, All Outputs
 
Posts: 125 | Registered: June 17, 2013Report This Post
Gold member
posted Hide Post
We are attempting to export to format EXL2K and the clients have Excel 2013 installed. WebFOCUS release 7.7.03. We get the Microsoft Excel message box 'Unable to read file' but when OK is clicked the file is opened just fine.

This only happens if the resulting Excel file is MULTIPLE tabs. Single TAB files open fine.
The clicking of the OK button is a large annoyance to my customers. Does anyone know how to either avoid the message box, or perhaps suppress it from appearing? BTW we use EXL2K format for the FORMULA option that is not available with EXL07. Sample code follows:



-*-------------------------- issue is related to multiple tab excel output file
SET COMPOUND=BYTOC
-*
TABLE FILE CAR
PRINT *
BY COUNTRY
BY MODEL
ON TABLE NOTOTAL
-*----------------- both EXL2K and EXL2K FORMULA result in message box from Excel.
-*ON TABLE PCHOLD FORMAT EXL2K
-*ON TABLE PCHOLD FORMAT EXL2K FORMULA
-*----------------- EXL07 works without issue
-*ON TABLE PCHOLD FORMAT EXL07
END


Laure


Prod: WebFOCUS 7.7.03 - MRE, BID, - WindowsXP - Oracle 9i, SQLServer, DevStudio 7.7.3 - Apache Tomcat , Output: HTML, Excel 2013 and PDF
 
Posts: 78 | Location: Florida | Registered: December 07, 2006Report This Post
Virtuoso
posted Hide Post
This is due to "Extension hardening" in MS Excel.

We currently use Excel 2007 which also complains about the file format used by EXL2K. We made the message go away by a simple change on each user's desktop registry:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
"ExtensionHardening"=dword:00000000


You may want to search about "Extension hardening" and how it is applicable particularly to Excel 2013.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Expert
posted Hide Post
Well, I guess that's OK for a small group; how about over 1000 users at a University???
IBI should add that code to the WebFOCUS THISFOCI.bat file so we "don't" have to manually add to a user's desktop.
OR,
am I barking up the wrong tree???
Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report 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     Does WebFocus support excel 2013 output ?

Copyright © 1996-2020 Information Builders