forum.alglib.net

ALGLIB forum
It is currently Fri Apr 19, 2024 2:21 am

View unanswered posts | View active topics


Board index » ALGLIB forum » ALGLIB-discuss

All times are UTC


Forum rules


1. This forum can be used for discussion of both ALGLIB-related and general numerical analysis questions
2. This forum is English-only - postings in other languages will be removed.



Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 
  Print view Previous topic | Next topic 
Author Message
hippofun
 Post subject: Do we have Sparsecreate (crs) functions in Excel format?
PostPosted: Tue Jun 04, 2013 7:45 am 
Offline

Joined: Tue Jun 04, 2013 7:19 am
Posts: 2
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
Top
 Profile  
 
Sergey.Bochkanov
 Post subject: Re: Do we have Sparsecreate (crs) functions in Excel format?
PostPosted: Tue Jun 04, 2013 12:41 pm 
Offline
Site Admin

Joined: Fri May 07, 2010 7:06 am
Posts: 906
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.
Top
 Profile  
 
hippofun
 Post subject: Re: Do we have Sparsecreate (crs) functions in Excel format?
PostPosted: Thu Jun 06, 2013 3:46 pm 
Offline

Joined: Tue Jun 04, 2013 7:19 am
Posts: 2
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.
Top
 Profile  
 
Doug Jenkins
 Post subject: Re: Do we have Sparsecreate (crs) functions in Excel format?
PostPosted: Thu Jun 20, 2013 4:13 am 
Offline

Joined: Sun May 16, 2010 11:42 pm
Posts: 63
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.

_________________
Doug Jenkins
http://newtonexcelbach.wordpress.com/
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 

Board index » ALGLIB forum » ALGLIB-discuss

All times are UTC


Who is online

Users browsing this forum: No registered users and 61 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group