 |
|||||
|
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
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 TopicGo | Search | Notify | Tools |
| exsting Excel sheet | Login/Join |
| Platinum Member |
Hi all, I'm back with silly questions..... First, when using PCHOLD to a EXL2K file, is it possible to write to file WITHOUT replacing it? IE, just updating the specific sheet using the proper syntax? Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7 Windows Server 2005 Windows Server 2008 Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0 | ||
|
| <JG> |
No not when it's driven by WebFocus Yes when it's driven by an Excel web query | ||
|
| Platinum Member |
OK, since writing to an existing excel file is out, is there to have the report get automatically saved to a speciied filename? I looked up 'ON PCHOLD' and it says it should do just that, but it still prompts you for a location. I want the fex th generate the filename based on a feild data WITHOUTprompting the user, and ALSO display the report in the browser (but I think can accoplish that final part with SAVEMATRIX). Any suggestions? Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7 Windows Server 2005 Windows Server 2008 Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0 | |||
|
| Expert |
Lloyd, if you filedef your output excel file to some network location that all your users can access, it might work for you. We do that here using caster in a batch job, using HOLD not PCHOLD, (although that begins to create agita in v 529 w/ pivots. ) also the template feature in 7 does some cool sheet-related thing, you might consider upgrading, for the replace a sheet option.This message has been edited. Last edited by: susannah,
| |||||
|
| Master |
Here is another option if the WebFOCUS Reporting Server and the Web Server are on the same box or if you can access the the web server some way (FTP, Network Drive) you can have the excel file saved to it. Then at the end of your process (focexec) have a -HTMLFORM and use java script to redirect the user to the excel file on the web server. Hope this give you some ideas. Scott  | |||
|
| Platinum Member |
Yeah, those are all great ideas, but since this was only a request by one salesman who thought it was too much work to 1) select a dir to save the sheet, 2)open excel and activete his formattedsheet, 3) cut and paste new sheet data into active sheet. At first I thought it would be a simple and slick project, but if it's going to be troublesome, he'll just have to wait until such time that we upgrade to ver 7. But thanks to you all, it helped. Lloyd Prendergast Michael Kors (USA), Inc. Phone: 201-453-5076 Fax: 646-354-4776 Lloyd.Prendergast@Michaelkors.com WebFOCUS 523 WebFOCUS 7.6 WebFOCUS 7.7 Windows Server 2005 Windows Server 2008 Iseries V5R3M0 Iseries V5R5M0 Iseries V6R1M0 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |