[ExcelDna] ExcelDna tutorial

724 views
Skip to first unread message

Ed Parcell

unread,
Apr 23, 2010, 7:28:30 AM4/23/10
to ExcelDna
Hello,

I have written a short tutorial on using ExcelDna to expose numerical
algorithms to Excel from the AlgLib numerical library. I think it
might be interesting to people looking for a simple how-to guide to
getting started with ExcelDna, or to those looking for high-quality
numerical libraries to use in Excel.

The tutorial is available on my blog at
http://edparcell.posterous.com/tutorial-numerical-analysis-in-excel-using-c

Any feedback gratefully received.

Best regards,
Ed.

--
You received this message because you are subscribed to the Google Groups "ExcelDna" group.
To post to this group, send email to exce...@googlegroups.com.
To unsubscribe from this group, send email to exceldna+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/exceldna?hl=en.

Chris Spicer

unread,
Apr 29, 2010, 10:50:41 AM4/29/10
to ExcelDna
Nice tutorial Ed. It's awesome to see all these great developers
helping others get started with ExcelDna. Also, I wasn't aware of
AlgLib up until now... I'll be adding that to my toolbox!

Chris

Ed Parcell

unread,
Apr 30, 2010, 4:52:18 AM4/30/10
to ExcelDna
Hi Chris.

Thanks very much. I hope it helps the project and others who want to
use it. I will probably be writing more on ExcelDna in the future, so
I'll make sure to let this group know when I do.

Yup, AlgLib seems very cool. It's nice to have numerical routines in a
modern language so you can see what's going on inside, and make tweaks
if necessary.

Best regards,
Ed.

Govert van Drimmelen

unread,
Nov 18, 2012, 10:16:25 AM11/18/12
to Excel-DNA
Hi Nick,

* Did other functions you are exporting work OK?

* What have you tried for the random numbers, what goes wrong?

* Do you need to mark your functions as 'Volatile' to make then
recalculate every time - like this:
[ExcelFunction(IsVolatile=true)]
public static double GetRandom() {....}

Regards,
Govert


On Nov 18, 5:00 pm, n <nick.vandenabe...@gmail.com> wrote:
> Hi,
>
> I was trying to expose some of these ALGLIB functions myself to a Excel dna
> interface.
> Unfortunately, I got stuck with the random numbers, could post a few hints
> on this issue.
>
> thx
> Nick
>
>
>
>
>
>
>
> On Friday, April 30, 2010 10:52:18 AM UTC+2, Ed Parcell wrote:
>
> > Hi Chris.
>
> > Thanks very much. I hope it helps the project and others who want to
> > use it. I will probably be writing more on ExcelDna in the future, so
> > I'll make sure to let this group know when I do.
>
> > Yup, AlgLib seems very cool. It's nice to have numerical routines in a
> > modern language so you can see what's going on inside, and make tweaks
> > if necessary.
>
> > Best regards,
> > Ed.
>
> > On Apr 29, 3:50 pm, Chris Spicer <chris.spi...@technicana.com> wrote:
> > > Nice tutorial Ed.  It's awesome to see all these great developers
> > > helping others get started with ExcelDna.  Also, I wasn't aware of
> > > AlgLib up until now... I'll be adding that to my toolbox!
>
> > > Chris
>
> > > --
> > > You received this message because you are subscribed to the Google
> > Groups "ExcelDna" group.
> > > To post to this group, send email to exce...@googlegroups.com<javascript:>.
>
> > > To unsubscribe from this group, send email to
> > exceldna+u...@googlegroups.com <javascript:>.
> > > For more options, visit this group athttp://
> > groups.google.com/group/exceldna?hl=en.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "ExcelDna" group.
> > To post to this group, send email to exce...@googlegroups.com<javascript:>.
>
> > To unsubscribe from this group, send email to
> > exceldna+u...@googlegroups.com <javascript:>.
Reply all
Reply to author
Forward
0 new messages