Hi, I have Excel 2007 installed on a Win7 64 bit and when I load the .xla file of imdev I get the followings:
Can't find project or library
Project_Imdev Password
Compile error in hidden module:This workbook
How can I manage to install it? If you have some ideas please tell, thanks a lot
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This problem seems to arise due to a problematic RExcel installations on Win 7 machines.
To make sure this is true: disconnect the imDEV add-in and conduct a test to see if RExcel is actually working. This can be done by trying to connect to R. Also test the server. Set it to foreground, and R GUI visible. Does this initialize R?
If RExcel is not working there are a couple of ways to fix it:
1) Find and delet the RefEdit file for RExcel.
Look for it in //users/AppData/Roaming/Microsoft/Forms
2) Uninstall and then re-install R, statDCOM and RExcel.
This seems to always fix the problem.
Hi, I would like to ask you if there is a workaround for this problem, when I load the plug-in it downloads and installs all the required packages, but when installing the package "PVclust" I get the following error in R console:
In gzfile(file, mode) :
cannot open compressed file 'C:\Users\MASSIM~1\AppData\Local\Temp\Rtmpny59bW/libloc_C%3a%2fUsers%2fMassimiliano%20Manfren%2fAppData%2fRoaming%2fMicrosoft%2fAddIns%2fimDEV%20v1.2%20Excel%202007%2flibraryVersion,Priority,Depends,Imports,LinkingTo,Suggests,Enhances,OS_type,License,Archs,Built.rds', probable reason 'No such file or directory'
It the visualize the subsequent phrase in Excel:
Error -2147220502
in Module REXcel.Rserver
Error running expression
eval(parse(text=”source(\”get packages”)”))
I would like to try all the functionality in this plugin soon (it is very interesting) so if you can help me I really appreciate it,
Cheers
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This error can have a number of sources, try the following to figure out which is the culprit:
1). Try opening R and installing the "pvclust" package manually.If you still can't get it try changing the CRAN mirror or try to down load it first and install from zip. If this works place it in the R library or the library inside imDEV.
If this doesn't fix the problem report back the error or go on to 2?
2). I've updated the script which installs all the packages used in imDEV. Download the newest version and replace the old files with it. Upon start up, any packages which can not be loaded will be ignored and a warning message will appear in the R GUI telling you which packages will need to be manually installed. If this fixes the problem you will still need to download the "pvclust" package somehow if you want to use the iterative hierarchical cluster analysis in imCorrelations.
3). If you are still having an error make sure you can write to the folder where imDEV is stored. On windows 7 you may need to change the folder settings to enable this.
4.) If none of the above works. Report back the error.
-Dmitry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Dimitry,
I realized that after downloading all the needed packages and installing them manually, I get the following errore while activating Imdev:
Carico il pacchetto richiesto: gdata (load the requested package)
gdata: Unable to locate valid perl interpreter
gdata:
gdata: read.xls() will be unable to read Excel XLS and XLSX files
gdata: unless the 'perl=' argument is used to specify the location of a
gdata: valid perl intrpreter.
gdata:
gdata: (To avoid display of this message in the future, please ensure
gdata: perl is installed and available on the executable search path.)
gdata: Unable to load perl libaries needed by read.xls()
gdata: to support 'XLX' (Excel 97-2004) files.
gdata: Unable to load perl libaries needed by read.xls()
gdata: to support 'XLSX' (Excel 2007+) files.
gdata: Run the function 'installXLSXsupport()'
gdata: to automatically download and install the perl
gdata: libaries needed to support Excel XLS and XLSX formats.
I installed Perl, but I don't know how to make R recognize it.
While execute imCORRELATIONS I get the following error:
Errore in set.vba(0, 5) : unused argument(s) (5)
Inoltre: Warning message:
'.readRDS' è deprecata
Usare 'readRDS' al suo posto.
Si veda help("Deprecated")
Errore in set.vba(0, 5) : unused argument(s) (5)
The error type is -2147220502
Thanks a lot for the collaboration and the effort
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry, I reloaded all the files and now both imPCA and imCorrelations work, I get only the following error while using imGraph :
In R console:
Errore in names(x) <- value :
l'attributo 'names' deve essere della stessa lunghezza del vettore
Inoltre: Warning message:
'.readRDS' è deprecata
Usare 'readRDS' al suo posto.
Si veda help("Deprecated")
In the Rexcel interface I have the following error:
Error -2147220502 in Module REXcel.Rserver
Error running expression eval(parse(text=”source(\”set undirected graph objects”)”))
Thank you very much for the help
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
With the next version update (Oct-Nov) I will release a much needed demo for imGraph and enable more functions (i.e. 3D networks). Until then the the biggest difference from other modules inputs is that on the groups tab when selecting groups via the specify button the groups object must be a 2 column matrix with the object names in column 1 and the groups ids in column 2. Every other input should be a single column (note* single rows will cause errors) with length = number of columns in the data.
-Dmitry
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello, I am trying to use imDEV but obtaining the same errors as mentioned above by Massimiliano Manfren - 2011-08-25. I am using Excel 2016, and I understand imDEV is compatible with Excel 2003, 2007 and 2010. Is there anyway around this problem? thank you.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If anyone has an answer it's Rémy. Please keep me in the loop. FYI I just accessed
Site for the first time in a long while so not sure when you sent the message.
John
Hello, I am trying to use imDEV but obtaining the same errors as mentioned above by Massimiliano Manfren - 2011-08-25. I am using Excel 2016, and I understand imDEV is compatible with Excel 2003, 2007 and 2010. Is there anyway around this problem? thank you.
Hello, I have problems to initialize imDEV version 1-4-2 The installation is locked at 21% and the error message is: R error when running: source ("get packages") 'Error in file (filename, "r", encoding = encoding): can not open the connection.
(see picture attached)
I'm working on Windows 7 (OS 64 bits). RExcel version 3.0.19 (20100115-1). R version 3.3.1 (32 bit). R(D)COM server version 3.5-1B2. MS Excel version 12.0 (Office 2017) 32 Bit
How can I fix the problem? Thanks!
Hello, about my previous message: I send an apology for my typographical error: I am using Excel 2007 not 2017. By the way, does it matter that this version of MS Office is in Spanish?
Thanks again.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hm, should work then. I am thinking an recycle issue or the cram mirror
you selected doesn’t have the package being looked for. I am away from the
office today but will give it some thought.
Hello, about my previous message: I send an apology for my typographical
error: I am using Excel 2007 not 2017. By the way, does it matter that this
version of MS Office is in Spanish?
Thanks again.
This electronic message contains information generated by the USDA solely
for the intended recipients. Any unauthorized interception of this message
or the use or disclosure of the information it contains may violate the law
and subject the violator to civil or criminal penalties. If you believe you
have received this message in error, please notify the sender and delete
the email immediately.
--
Dmitry Grapov, PhD
Director of Data Science and Bioinformatics
CDS- Creative Data Solutions http://createdatasol.com/
801-897-6645
Thank you so much Drs. Garpov and Newman:
Now everything is solved.
I installed the newest version of R (i.e. 3.4.4.), I ran it as an administrator (Win 7) and in the console of the program I was guided with the libraries and missing packages. A little advice: "With a little help from my friends" (The Beatles dixit) and reading, reading, and reading (i.e. RFM: Read the F++ Manual). Gracias!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I have Excel 2007 installed on a Win7 64 bit and when I load the .xla file of imdev I get the followings:
Can't find project or library
Project_Imdev Password
Compile error in hidden module:This workbook
How can I manage to install it? If you have some ideas please tell, thanks a lot
Hello,
This problem seems to arise due to a problematic RExcel installations on Win 7 machines.
To make sure this is true: disconnect the imDEV add-in and conduct a test to see if RExcel is actually working. This can be done by trying to connect to R. Also test the server. Set it to foreground, and R GUI visible. Does this initialize R?
If RExcel is not working there are a couple of ways to fix it:
1) Find and delet the RefEdit file for RExcel.
Look for it in //users/AppData/Roaming/Microsoft/Forms
2) Uninstall and then re-install R, statDCOM and RExcel.
This seems to always fix the problem.
This issue is also discussed here: https://sourceforge.net/apps/mediawiki/imdev/index.php?title=Troubleshooting
-Dmitry
Hi, I would like to ask you if there is a workaround for this problem, when I load the plug-in it downloads and installs all the required packages, but when installing the package "PVclust" I get the following error in R console:
In gzfile(file, mode) :
cannot open compressed file 'C:\Users\MASSIM~1\AppData\Local\Temp\Rtmpny59bW/libloc_C%3a%2fUsers%2fMassimiliano%20Manfren%2fAppData%2fRoaming%2fMicrosoft%2fAddIns%2fimDEV%20v1.2%20Excel%202007%2flibraryVersion,Priority,Depends,Imports,LinkingTo,Suggests,Enhances,OS_type,License,Archs,Built.rds', probable reason 'No such file or directory'
It the visualize the subsequent phrase in Excel:
Error -2147220502
in Module REXcel.Rserver
Error running expression
eval(parse(text=”source(\”get packages”)”))
I would like to try all the functionality in this plugin soon (it is very interesting) so if you can help me I really appreciate it,
Cheers
Hi,
This error can have a number of sources, try the following to figure out which is the culprit:
1). Try opening R and installing the "pvclust" package manually.If you still can't get it try changing the CRAN mirror or try to down load it first and install from zip. If this works place it in the R library or the library inside imDEV.
If this doesn't fix the problem report back the error or go on to 2?
2). I've updated the script which installs all the packages used in imDEV. Download the newest version and replace the old files with it. Upon start up, any packages which can not be loaded will be ignored and a warning message will appear in the R GUI telling you which packages will need to be manually installed. If this fixes the problem you will still need to download the "pvclust" package somehow if you want to use the iterative hierarchical cluster analysis in imCorrelations.
3). If you are still having an error make sure you can write to the folder where imDEV is stored. On windows 7 you may need to change the folder settings to enable this.
4.) If none of the above works. Report back the error.
-Dmitry
Hi Dmitry,
I installed it manually and now it works all fine, thanks a lot for the help and for your great work with this plugin!
Hi Dimitry,
I realized that after downloading all the needed packages and installing them manually, I get the following errore while activating Imdev:
Carico il pacchetto richiesto: gdata (load the requested package)
gdata: Unable to locate valid perl interpreter
gdata:
gdata: read.xls() will be unable to read Excel XLS and XLSX files
gdata: unless the 'perl=' argument is used to specify the location of a
gdata: valid perl intrpreter.
gdata:
gdata: (To avoid display of this message in the future, please ensure
gdata: perl is installed and available on the executable search path.)
gdata: Unable to load perl libaries needed by read.xls()
gdata: to support 'XLX' (Excel 97-2004) files.
gdata: Unable to load perl libaries needed by read.xls()
gdata: to support 'XLSX' (Excel 2007+) files.
gdata: Run the function 'installXLSXsupport()'
gdata: to automatically download and install the perl
gdata: libaries needed to support Excel XLS and XLSX formats.
I installed Perl, but I don't know how to make R recognize it.
While execute imCORRELATIONS I get the following error:
Errore in set.vba(0, 5) : unused argument(s) (5)
Inoltre: Warning message:
'.readRDS' è deprecata
Usare 'readRDS' al suo posto.
Si veda help("Deprecated")
Errore in set.vba(0, 5) : unused argument(s) (5)
The error type is -2147220502
Thanks a lot for the collaboration and the effort
Sorry, I reloaded all the files and now both imPCA and imCorrelations work, I get only the following error while using imGraph :
In R console:
Errore in names(x) <- value :
l'attributo 'names' deve essere della stessa lunghezza del vettore
Inoltre: Warning message:
'.readRDS' è deprecata
Usare 'readRDS' al suo posto.
Si veda help("Deprecated")
In the Rexcel interface I have the following error:
Error -2147220502 in Module REXcel.Rserver
Error running expression eval(parse(text=”source(\”set undirected graph objects”)”))
Thank you very much for the help
Hi, This sounds like one of the objects set in excel for imGraph is causing an error. The imGraph module is still very much a work in progress.
What are you doing procedurally in the module that causes this error?
-Dmitry
Maybe I'm simply loading the data in an uncorrect way, I was using the undirected graph command. I will do some more trials, thank you
Hi,
With the next version update (Oct-Nov) I will release a much needed demo for imGraph and enable more functions (i.e. 3D networks). Until then the the biggest difference from other modules inputs is that on the groups tab when selecting groups via the specify button the groups object must be a 2 column matrix with the object names in column 1 and the groups ids in column 2. Every other input should be a single column (note* single rows will cause errors) with length = number of columns in the data.
-Dmitry
Hello, I am trying to use imDEV but obtaining the same errors as mentioned above by Massimiliano Manfren - 2011-08-25. I am using Excel 2016, and I understand imDEV is compatible with Excel 2003, 2007 and 2010. Is there anyway around this problem? thank you.
If anyone has an answer it's Rémy. Please keep me in the loop. FYI I just accessed
Site for the first time in a long while so not sure when you sent the message.
John
Sent from my iPhone
Hello, I have problems to initialize imDEV version 1-4-2 The installation is locked at 21% and the error message is: R error when running: source ("get packages") 'Error in file (filename, "r", encoding = encoding): can not open the connection.
(see picture attached)
I'm working on Windows 7 (OS 64 bits). RExcel version 3.0.19 (20100115-1). R version 3.3.1 (32 bit). R(D)COM server version 3.5-1B2. MS Excel version 12.0 (Office 2017) 32 Bit
How can I fix the problem? Thanks!
Hello, about my previous message: I send an apology for my typographical error: I am using Excel 2007 not 2017. By the way, does it matter that this version of MS Office is in Spanish?
Thanks again.
Hi,
Do you see an R console in the background? Can you copy/paste what is
there. Otherwise you may need to try to manually source that file in R.
-Dmitry
On Fri, Mar 30, 2018 at 3:16 PM, Newman, John - ARS John.Newman@ars.usda.gov wrote:
--
Dmitry Grapov, PhD
Director of Data Science and Bioinformatics
CDS- Creative Data Solutions http://createdatasol.com/
801-897-6645
Thank you so much Drs. Garpov and Newman:
Now everything is solved.
I installed the newest version of R (i.e. 3.4.4.), I ran it as an administrator (Win 7) and in the console of the program I was guided with the libraries and missing packages. A little advice: "With a little help from my friends" (The Beatles dixit) and reading, reading, and reading (i.e. RFM: Read the F++ Manual). Gracias!