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.
I'm having difficulties getting existing fex's to output with XLSX type. I get this error message from Excel
quote:
Excel cannot open the file 'zcbab.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
I press "ok" and Excel launches, but no file is opened.
We are on WebFOCUS 8; I'm on Windows 10 and Microsoft Office 2016. However, some people on Windows 8 have problems, some do not. I've tried changing the default program for anything that starts with .x to open with Excel.
If I create a brand new fex outputting to XLSX it opens successfully. I thought maybe Excel didn't like something in the formatting section (and we've had this happen for a handful of older fexes outputting to XLSX), but I've commented out all the formatting stuff, and it still fails. Any ideas?This message has been edited. Last edited by: Kevin Patterson,
Kevin Patterson Appalachian State University WebFOCUS 7.7.03 Windows, All Outputs
Can you provide an example of the code that's not working? Also, did you start getting this error on the existing reports after a change in OS, WebFOCUS upgrade? What changed to cause working reports to trigger this error?
Also, double check to see if you have
SET IBIF_excelservurl=''
In your profile or the report.This message has been edited. Last edited by: BabakNYC,
WebFOCUS 8206, Unix, Windows
Posts: 1853 | Location: New York City | Registered: December 30, 2015
Thanks for the responses. My administrator tells me that Java service is active on the reporting server and on the client box.
I've added SET IBIF_excelservurl='' as well. But I might have it in the wrong place. This is not a car file example but it's an example of what is giving me this error:
quote:
-* HTML Tool -* Created by Report Assistant -* FF Line do not change this line! Field Name -* FF Line do not change this line! Alias -* FF Line do not change this line! Format -* FF Line do not change this line! Segment -* FF Line do not change this line! displayTree=0 -* *************************************************************************************************************************************************** -* Author - Rick Presnell -* Replaces a previous version "Tim Burwell download" which only pulled ORG 2 - Academic Affairs, from ASU_OPERATING_LEDGER -* Also replaces next version which replaced "Tim Burwell download" to allow ALL ORGs for Provost Dr. Kruger which was named (continue to next line) -* (continued...) "Academic Affairs -Chart A - All ORGS" which read ASU_OPERATING_LEDGER -* Had to replace because fields used in view would get updated retroactively for some COA changes. -* New view, ASU_OPERATING_LEDGER_ORIG, contains fields that contain original values -* The reason most of the column names are renamed using "AS", is that Tim Burwell has a rather extensive MS-Access/Excel application -* that has queries, etc. which use the former column names. Renaming the new column names should prevent him from having to change -* anything on his side. -* *************************************************************************************************************************************************** -*
-*---- code used to capture usage --------------------- -SET &fexname = 'FinnaceODSORIGView-ChartA-AllOrgs (under Available Budget)'; -MRNOEDIT BEGIN -INCLUDE baseapp/newusagetrack.fex -MRNOEDIT END -*-----------------------------------------------------
That worked... setting SET EXCELSERVURL = '' in the fex itself. I'll try having our administrator set that in the server so we don't have to put it in each report. Thank you Chaudhary, and BabakNYC!
Kevin Patterson Appalachian State University WebFOCUS 7.7.03 Windows, All Outputs
*** &EXCELSERVURL: SET EXCELSERVURL=http://biwfprod:8080/ibi_apps ***
(FOC324) THE PARAMETER TO BE SET IS NOT RECOGNIZED: IBIF_EXCELSERVURL
*** &EXCELSERVURL: SET EXCELSERVURL=http://biwfprod:8080/ibi_apps ***
Read-Only Topic
That worked... setting SET EXCELSERVURL = '' in the fex itself. I'll try having our administrator set that in the server so we don't have to put it in each report. Thank you Chaudhary, and BabakNYC!
