exsting Excel sheet

March 21, 2006, 12:55 PM

Lloyd

exsting Excel sheet

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

March 21, 2006, 05:08 PM

Lloyd

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?

March 23, 2006, 01:47 PM

<JG>

Lloyd

There is absolutely no way for a web browser to save a file to a client PC hard disk
WITHOUT user intervention.

The ability to do that, is the dream of hackers world wide.

The only viable option you have is to HOLD the file server side to a location mapped by both
the server and the client if that is possible.

March 23, 2006, 09:01 PM

susannah

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,

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

March 24, 2006, 10:24 AM

TexasStingray

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

March 24, 2006, 02:23 PM

Lloyd

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.