Re: [R] Import excel file

2012-11-19 Thread Hervy Cyril

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

2012-11-16 Thread Hervy Cyril
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

2012-10-04 Thread Hervy Cyril

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

2012-10-03 Thread Hervy Cyril
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

2012-10-03 Thread Hervy Cyril

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

2012-10-03 Thread Hervy Cyril

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.