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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
PCHOLD FORMAT EXCEL
 Login/Join
 
Stan
Gold member
posted
I know that there are all sorts of version issues with WebFOCUS and EXCEL so before my question here are the specs:
WebFOCUS 5.2.5
EXCEL 97 SR-2(n)

I need to have my report come up in Excel without the title line (In other words I need data to appear in line 1 instead of titles). THere are some other macros dependent on this so I'm forced to find a way to eliminate the titles. I've tried the old standard of saying AS '' but that isn't doing the trick...Any ideas out there?

Thanks,
stan
 
Posts: 90 | Registered: April 15, 2004Report This Post
Steve C
Silver Member
posted Hide Post
Well, I don't think you can get Focus to do this. There are always titles, even if you don't want them, they are just set to blanks. I can think of only one workaround:

Create the sheet as Focus wants to. Also create a new workbook that has a reference to the workbook that is/will be created from Focus, and select the range to point to that is below the headings. This reference book should update each time you open it by refreshing the data from the sheet created by Focus.

A Rube Goldberg solution, but it should work.
 
Posts: 44 | Location: New York City | Registered: May 23, 2004Report This Post
Stan
Gold member
posted Hide Post
Unfortunately we have an application that automatically takes this report's data and performs the next function...I'm trying to talk them into looking for data starting in row 2, but in the meantime I told them I'd keep checking for possibilities.

Thanks for the input, however.

Stan
 
Posts: 90 | Registered: April 15, 2004Report This Post
susannah
Expert
posted Hide Post
and you've tried exporting as a csv file
and having your next application import that file with a macro? no headers that way.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Piipster
Guru
posted Hide Post
You can try FORMAT LOTUS for your hold file. It generates a comma-delimited file with no column-titles. You have to import it into Excel.

Another question I would ask is ... what do the subsequent macros do? Can you do any of the work they do from within WebFOCUS so the macros are not required and you can do more with the formatting of the output?
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Report This Post
<WFUser>
posted
Why not use a Web Query instead?
 
Report This Post
<Pietro De Santis>
posted
Web Query?

Details please.
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders