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     [CLOSED]Unable to read file popup excel only

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Unable to read file popup excel only
 Login/Join
 
Silver Member
posted
We are experiencing an issue when the report is output to excel. Our reports output to EXL2K in the focexec code. The issue doesn't happen all the time and its totally random. When the report is generating the excel output we receive a small popup from excel "Unable to read file" and it contains a button with the text "Ok". Click Ok and nothing happens. Re-run the report and it outputs just fine, OR you get the popup again. Sometimes it will take 3 - 5 times to get it to output. Seems to never happen the first time I run a report for the given day. We are on Microsoft Excel 2010. Any one ever had this issue?

This message has been edited. Last edited by: <Emily McAllister>,


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML
 
Posts: 32 | Registered: February 28, 2011Report This Post
Platinum Member
posted Hide Post
Just curious, if you set the format to XLSX do you see the same behavior?


JC
WebFOCUS Dev Studio / App Studio
8.2.01
Windows 7
 
Posts: 146 | Registered: November 09, 2015Report This Post
Silver Member
posted Hide Post
It seems to work fine when I change it to EXL07. I cannot remember why I've decided not to use that functionality. Maybe had something to do with Report Caster or with creating compound reports with multi-tab output.


Webfocus 8.1.0.5
Windows 2008
Excel,PDF,HTML
 
Posts: 32 | Registered: February 28, 2011Report This Post
Master
posted Hide Post
It could be most anything, but the primary culprit is that WebFOCUS does not generate true .xls files. Excel 2010 sees that the actual format of the file doesn't conform to the rules of the extension (.xls) and complains in various ways. To fix it can depend on registry settings, excel 2010 security settings, the report using a macro enabled template and a few others.

We use a lot of macro enabled templates. The only issue we've had using XLSX format is multi-worksheet, macro enabled workbooks with lots of data (over 10000 rows). Our issue has to do with how WebFOCUS is zipping the worksheets as the workbook is built. IBI has been able to recreate this and it is supposed to be fixed in some release of 8.2. Other than these cases, we have converted almost all EXL2K output to XLSX.

I would advise converting to XLSX and most certainly doing new reports in XLSX.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 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     [CLOSED]Unable to read file popup excel only

Copyright © 1996-2020 Information Builders