Re: [R] Import excel file
Hello, According to manual R Data Import/Excel, xlsreadWrite package and RODBC package are used for 32-bit version (tests confirmed this observation) I used XLConnect package but it returned this error : Erreur dans new(J(com.miraisolutions.xlconnect.integration.r.RWorkbookWrapper), : erreur d'évaluation de l'argument 'Class' lors de la sélection d'une méthode pour la fonction 'new' : Erreur dans .jfindClass(as.character(class)) : class not found Thanks for your help Best regards, Cyril Hervy -Message d'origine- De : Uwe Ligges [mailto:lig...@statistik.tu-dortmund.de] Envoyé : dimanche 18 novembre 2012 19:10 À : Rui Barradas Cc : Hervy Cyril; r-help@r-project.org Objet : Re: [R] Import excel file On 16.11.2012 16:59, Rui Barradas wrote: Hello, I believe it is, but see package XLConnect. The vignette is very helpfull, with lots of examples. ... and many other ways. Please see the manual R Data Import/Excel that ships with R and has a whole section devoted to Excel. Best, Uwe Ligges Hope this helps, Rui Barradas Em 16-11-2012 15:27, Hervy Cyril escreveu: Hello, Is it possible to import an Excel 2000 file (32-bit version) into R 2.15.1 64-bit version? Thanks. Best regards, Cyril Hervy [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] Import excel file
Hello, Is it possible to import an Excel 2000 file (32-bit version) into R 2.15.1 64-bit version? Thanks. Best regards, Cyril Hervy [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] How to limit memory on a server
I think R keeps all the data in RAM ? The function memory.limit() refers to the RAM size ? I will try to configure the OS. Thanks. Best regards Cyril Hervy -Message d'origine- De : Prof Brian Ripley [mailto:rip...@stats.ox.ac.uk] Envoyé : mercredi 3 octobre 2012 17:22 À : Hervy Cyril Cc : R-help (r-help@r-project.org) Objet : Re: [R] How to limit memory on a server On 03/10/2012 16:12, Hervy Cyril wrote: My OS is a 64-bit Windows Server 2008 SP2 and I would like to limit RAM usage on the server. Ask your sysadmins, as Duncan Murdoch advised. R only know about virtual memory usage, not RAM usage. Thank you. Best regards Cyril Hervy -Message d'origine- De : Prof Brian Ripley [mailto:rip...@stats.ox.ac.uk] Envoyé : mercredi 3 octobre 2012 15:43 À : Hervy Cyril Cc : R-help (r-help@r-project.org) Objet : Re: [R] How to limit memory on a server And your OS is? See the footer and the 'at a minimum' information the posting guide asks for. I think you are confusing 'memory' and 'RAM': the two concepts are distinct. But R is not a special case, and you do it the same way as you do this for any other process, by your OS facilities. On 03/10/2012 10:12, Hervy Cyril wrote: Hello, In our structure, users connect to a server (64GB of memory) where they launch R. How can I limit the amount of RAM that could use a user. The function memory.limit(size=...) can limit the amount of memory but I would like users can't change this option in R. Is it possible? Thank you. Cyril Hervy [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- Brian D. Ripley, rip...@stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UKFax: +44 1865 272595 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
[R] How to limit memory on a server
Hello, In our structure, users connect to a server (64GB of memory) where they launch R. How can I limit the amount of RAM that could use a user. The function memory.limit(size=...) can limit the amount of memory but I would like users can't change this option in R. Is it possible? Thank you. Cyril Hervy [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] How to limit memory on a server
My OS is a 64-bit Windows Server 2008 SP2 and I would like to limit RAM usage on the server. Thank you. Best regards Cyril Hervy -Message d'origine- De : Prof Brian Ripley [mailto:rip...@stats.ox.ac.uk] Envoyé : mercredi 3 octobre 2012 15:43 À : Hervy Cyril Cc : R-help (r-help@r-project.org) Objet : Re: [R] How to limit memory on a server And your OS is? See the footer and the 'at a minimum' information the posting guide asks for. I think you are confusing 'memory' and 'RAM': the two concepts are distinct. But R is not a special case, and you do it the same way as you do this for any other process, by your OS facilities. On 03/10/2012 10:12, Hervy Cyril wrote: Hello, In our structure, users connect to a server (64GB of memory) where they launch R. How can I limit the amount of RAM that could use a user. The function memory.limit(size=...) can limit the amount of memory but I would like users can't change this option in R. Is it possible? Thank you. Cyril Hervy [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- Brian D. Ripley, rip...@stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UKFax: +44 1865 272595 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] How to limit memory on a server
My OS is a 64-bit Windows Server 2008 SP2 and I have a sysadmin account on the server. Thank you. Best regards Cyril Hervy -Message d'origine- De : Duncan Murdoch [mailto:murdoch.dun...@gmail.com] Envoyé : mercredi 3 octobre 2012 15:39 À : Hervy Cyril Cc : R-help (r-help@r-project.org) Objet : Re: [R] How to limit memory on a server On 03/10/2012 5:12 AM, Hervy Cyril wrote: Hello, In our structure, users connect to a server (64GB of memory) where they launch R. How can I limit the amount of RAM that could use a user. The function memory.limit(size=...) can limit the amount of memory but I would like users can't change this option in R. Is it possible? Generally speaking, that's something that the operating system needs to enforce. If you don't know how to do it with your OS, you might get some advice here by saying which one it is, but you may have to ask a sysadmin at your site. Duncan Murdoch __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.