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     Visual Discovery Data Grid Output to Excel

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Visual Discovery Data Grid Output to Excel
 Login/Join
 
Jenn McMaster
Member
posted
Does anyone have any code to export the Visdis data grid contents to an excel file without doing a drill through report?


WF 7.1.4
Windows 2003
 
Posts: 22 | Location: Pittsburgh | Registered: December 22, 2003Report This Post
Kerry
Expert
posted Hide Post
Hi Jenn,

I checked with product manager and here is his response:


I was not able to produce this.

I created a Visual Discovery Data Sheet in the HTML Layout Painter. I then pointed this to the VZSales.txt file in ibisamp and added fields at random. I ran the HTML Layout page and it was not presented with any design issues. I then activated, Active Report, right-clicked and selected Export.

The dialogue window presented allows the options to save as a text or as All*.* files. When All*.* is selected and the file name entered is given a xls extension, the excel output created is placed on the Desktop and fully functional.

Can we get a reproduction, is the customer presented with any errors? If other troublesome Visual Discovery charts are removed, does the problem persist?


Please let us know the above. Thank you in advance for sharing. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Jenn McMaster
Member
posted Hide Post
Kerry,

It's not that we can't export. That does work. We would just like to automatically open the exported file for the user into Excel without them having to save it on their PC first.

Is there anyway that we can copy the contents of the grid to the clipboard or something instead of saving to a file so we can open an Excel object in Javascript and paste it in there for the user?

Thanks,
Jen


WF 7.1.4
Windows 2003
 
Posts: 22 | Location: Pittsburgh | Registered: December 22, 2003Report This Post
Kerry
Expert
posted Hide Post
Hi Jen,

Here is the suggestion from our product manager:

If you know how to open the Excel object from JavaScript, then all you need to do is pass the Excel object there data. You can do this by using the Visual Discovery enumerator object. Youcan enumerate through all the data in the data pool and build an HTML table that can be opened by (or passed to) the Excel object. You will need to review the VzEnumAccess object in the Visual Discovery online help files, specifically the DataEnumerator method.

Hope this helps. Big Grin

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
Jenn McMaster
Member
posted Hide Post
This is what I am trying right now. Although I haven't been able to get the enumerator to work right. Do you have some example code on how to do this?


WF 7.1.4
Windows 2003
 
Posts: 22 | Location: Pittsburgh | Registered: December 22, 2003Report This Post
Kerry
Expert
posted Hide Post
Hi Jenn,

Another approach would be to iterate through the Data Pool like you are doing. However, rather than create the Excel file and open it from memory, perhaps create the Excel file like you are or build an HTML table, but instead, save the file to the server and provide a link to open the file.

The suggestion now is to contact Information Builders' Customer Support Services and open a case, so someone can help you make the code work better. To open a case, you may either call at 1-800-736-6130, or access the online system InfoResponse. Here is a list of information to be ready when you call: http://techsupport.ibi.com/before_you_call.jsp.

Hope this helps. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report 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     Visual Discovery Data Grid Output to Excel

Copyright © 1996-2020 Information Builders