I am having trouble using R routines from the RExcel add-in, that use lapack.dll. As an example if I start the R kernel from within Excel and execute "x<-rbind(c(1,2),c(1,-1)) z<-solve(x)", I get the following error: "Error in solve.default(x): lapack routines could not be loaded. In addition: Warning message: unable to load shared library "C:\Program Files\R\rw1070/modules/lapack.dll"; Load library failure. The specified module could not be found." I have the file lapack.dll in the correct directory. I am not sure why the forward slash "/" characters are not back slash's "\" in this error message. However, I do not know if this is important. I have installed R 1.7.0 on my system running windows 2000 and I have installed RExcel 1.0 with RDCOM server 1.2. Any help would be appreciated. I think the RExcel add-in is fantastic and I would like to be able to use the lapack.dll routines. Regards, Tony MacKenzie
Unable to load lapack.dll when using RExcel add-in
2 messages · Tony Mackenzie, Roger Bivand
On Fri, 16 May 2003, Tony Mackenzie wrote:
I am having trouble using R routines from the RExcel add-in, that use lapack.dll. As an example if I start the R kernel from within Excel and execute "x<-rbind(c(1,2),c(1,-1)) z<-solve(x)", I get the following error: "Error in solve.default(x): lapack routines could not be loaded. In addition: Warning message: unable to load shared library "C:\Program Files\R\rw1070/modules/lapack.dll"; Load library failure. The specified module could not be found." I have the file lapack.dll in the correct directory. I am not sure why the forward slash "/" characters are not back slash's "\" in this error message. However, I do not know if this is important. I have installed R 1.7.0 on my system running windows 2000 and I have installed RExcel 1.0 with RDCOM server 1.2. Any help would be appreciated. I think the RExcel add-in is fantastic and I would like to be able to use the lapack.dll routines.
For the time being, do: solve(..., LINPACK=TRUE) This uses the older, built-in functions rather than lapack.dll. I believe a patch has been made to the R windows release, but we'll have to wait until 1.7.1, perhaps, for the path to work correctly. This has been discussed several times on the "Rcom" special interest list, which is certainly worth joining for users of the software.
Roger Bivand Economic Geography Section, Department of Economics, Norwegian School of Economics and Business Administration, Breiviksveien 40, N-5045 Bergen, Norway. voice: +47 55 95 93 55; fax +47 55 95 93 93 e-mail: Roger.Bivand at nhh.no