STRPCCMD

[kaw]

How to open excel by clicking a button?

Thank you!

[Scott Klement]

If your spreadsheet is on IBM i, consider using the pui.download() JavaScript API from an onclick event in a button.

Here's the docs:
http://www.profoundlogic.com/docs/displ ... 8config%29

In Genie, you'd want to set your onclick to something like:

Code: Select all

pui.download({ "id":  "/ifs/path/to/spreadsheet.xls", "inline": true, "contentType": "application/vnd.ms-excel" });

You'd also need to set up your PUIDNLEXIT program to allow the download. (See link, above, for more info.)

It's also possible to do this with STRPCCMD... But, with STRPCCMD, the spreadsheet needs to be accessible to the PC already (i.e. available via Windows Networking or something)

Code: Select all

strpccmd pccmd('X:\Path\To\spreadsheet.xls')

But, again, that'll only work if the pathname is already something accessible to windows, whereas with pui.download() it's transferred over HTTP the same as the web page. I personally find that more elegant.

[kaw]

I'm Genie. I have an RPG program on green screen allows you to create files and places them in the IFS and opens automatically with to command STRPCCMD and I would do the same on Genie.
I tried a button

STRPCCMD pccmd ('L: \ www \ kaw \ toto.pdf')

but I have the following error message:OnClick Error: Unexepected identifier

[Scott Klement]

STRPCCMD would need to be called from a CL program, the QCMDEXC API, or another similar API. You can't run it directly from a Genie button, since that button actually runs on your PC's browser, it doesn't run on IBM i -- and therefore can't run IBM i commands.

However, there's a JavaScript API named runPCCommand that you can call from a Genie button. It does the same thing as STRPCCMD -- basically, just a JavaScript implementation of STRPCCMD.
http://www.profoundlogic.com/docs/displ ... ommand+%29

But, beware of backslashes. in the CL environment, backslash is just a normal character. But with JavaScript, it has a special meaning, so you need to be sure you escape it. This is described in the preceding link as well.