OpenEuphoria

Re: Noob, learning how to use dll's.

• Posted by Mike777 <anon4321 at gmai?.?om> Jun 13, 2008
• 885 views

Since we are on the subject of NOOB's and dll's, I herewith post a link to a
thread I started a few months ago about using a Euphoria DLL from within Excel:

http://www.openeuphoria.org/cgi-bin/esearch.exu?thread=1&fromMonth=C&fromYear=C&toMonth=2&toYear=D&keywords=%22Excel%22

Is there anybody reading this at this time that can extend the discussion a bit?
 Just to clarify, I'm not trying to:

1) write to an Excel sheet from a Euphoria program

2) create something that mimics an ActiveX object that therefore needs a
wrapper.

I'm interested in creating a DLL that exposes a function which can be utilized
within an Excel spreadsheet.

For example, say my DLL has a function which is called specialaverage and it
takes a series of potentially 10 numbers and calculates a "special average" (say,
something like the highest 3 consecutive out of 5, using a floor approach whereby
the next in the series can never be less than 20% beneath what its predecessor
is).  I want to put:

=specialaverage(a1..a10)

in the cell and have the result populated.

I have looked at the notes on MSDN on creating a DLL for use with excel
(referred to as an xll, I believe) but I'm not able to understand whether doing
so in Euphoria is even possible.

Thanks

Mike