| forum.alglib.net http://forum.alglib.net/ |
|
| Do we have Sparsecreate (crs) functions in Excel format? http://forum.alglib.net/viewtopic.php?f=2&t=863 |
Page 1 of 1 |
| Author: | hippofun [ Tue Jun 04, 2013 7:45 am ] |
| Post subject: | Do we have Sparsecreate (crs) functions in Excel format? |
Dear all, Still not sure how to add these functions into my Excel VBA after surfing the internet for a whole day in this forum or Google. I have got a matix of 30,000 x 50,000 approximately 95% are zeros trying to test some of the association algorithms. Do alglibnet2.dll capable to store my matix? If yes, is the following codes sufficient to link it up? Code: Public Declare Sub name Lib "D:\alglib-3.7.0.vbnet\vbnet\alglibnet2.dll" Alias "alglib" Regards Kevin |
|
| Author: | Sergey.Bochkanov [ Tue Jun 04, 2013 12:41 pm ] |
| Post subject: | Re: Do we have Sparsecreate (crs) functions in Excel format? |
VBA version of ALGLIB is quite old and does not include sparse matrix functionality. You may try calling NET version of ALGLIB from Excel, it is possible, but in this case you should implement Excel-NET interface yourself. |
|
| Author: | hippofun [ Thu Jun 06, 2013 3:46 pm ] |
| Post subject: | Re: Do we have Sparsecreate (crs) functions in Excel format? |
Thank your for giving me the right direction. I am good in vba but dont have any basic skills for linking the .net library after surfing the web for two day. Appreciate if you manage to help me more hy making a linked execl 2007 so that I can start to test sparsecreatecrs function and pouring my matrix data there. |
|
| Author: | Doug Jenkins [ Thu Jun 20, 2013 4:13 am ] |
| Post subject: | Re: Do we have Sparsecreate (crs) functions in Excel format? |
hippofun - have a look here: http://newtonexcelbach.wordpress.com/2013/01/22/new-release-alglib-library/ You will find open source VBA code linking to the Alglib C# sparse solver. |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|