Interfacing with Excel

Discussions about design and architecture principles, including native JADE systems and JADE interoperating with other technologies
ConvertFromOldNGs
Posts: 5321
Joined: Wed Aug 05, 2009 5:19 pm

Re: Interfacing with Excel

Postby ConvertFromOldNGs » Fri Aug 07, 2009 11:11 am

by Grant Samuels >> Wed, 24 Feb 1999 20:29:48 GMT

By popular demand here is the shell32 posting (originally posted by Geoff Davies)...
------------------------------------------------------------------------------------------------------------------ Pretty straightforward. Here are the instructions for setting up an external function.

1. From the Schema Browser or Class Browser, select the Browse | External Functions menu command.

2. Select the Library | Add Library command.

3. Type shell32 in the Name textbox and click OK.

4. Select the Functions | Add... menu command.

5. Type shellExecute in the Name textbox and press Tab.

6. Type ShellExecuteA in the Entry Point textbox and click OK.

7. Alter the signature of the shellExecute external function to:

shellExecute( hwnd:Integer; lpOperation:String; lpFile:String; lpParameters:String; lpDirectory : String; nShowHow : Integer) : Integer is ShellExecuteA in shell32;

8. Press F8 to compile.

Now all you have to do is call the external function in a JADE method. The following instruction opens your e-mail program and prefill the mailto: field

call shellExecute (hwnd, "open", "mailto:JADESupport@cardinal.co.nz", null, null, 1);

The following instruction opens your internet browser and load the appropriate URL

call shellExecute (hwnd, "open", "http://www.jade.co.nz", null, null, 1);

ConvertFromOldNGs
Posts: 5321
Joined: Wed Aug 05, 2009 5:19 pm

Re: Interfacing with Excel

Postby ConvertFromOldNGs » Fri Aug 07, 2009 11:11 am

by Robert Barr >> Thu, 15 Jul 1999 21:23:03 GMT

I'd be interested to learn if anyone has gone to the trouble of reading or writing XLS format data in JADE?

If so, would you be willing to (a) share your code, or (b) share your experience - was it straighforward, or fraught with hidden complexities and documentation ommissions?

Cheers,
Rob


Return to “Design and Architecture”

Who is online

Users browsing this forum: No registered users and 4 guests