how can I import/export data from ms excel? also is there a way to import/export data of the hdf format? is there a way to import/export hdf format for ms excel as well? thank you very much in advance. /js ###################################################################### This e-mail message has been scanned and cleared by MailMarshal http://www.marshalsoftware.com ###################################################################### -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Jun Sung wrote:> > also is there a way to import/export data of the hdf format?There is a contrib package for hdf5 support written by Marcus Daniels of the Swarm Development Group (SDG: http://www.swarm.org). I built RPM for it and you can get it where R RPMS are found. -- Paul E. Johnson email: pauljohn at ukans.edu Dept. of Political Science http://lark.cc.ukans.edu/~pauljohn University of Kansas Office: (785) 864-9086 Lawrence, Kansas 66045 FAX: (785) 864-5700 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Did you try R-Excel interface ? see http://lib.stat.cmu.edu/R/CRAN/contrib/extra/index.html Le 31 Aug 00 ? 3:09, Jun Sung ?crivait:> From: Jun Sung <JSung at FMCG.com> > To: "'r-help at lists.R-project.org'" <r-help at lists.R-project.org> > Subject: [R] help with data import/export > Date: Thu, 31 Aug 2000 03:09:53 -0400> how can I import/export data from ms excel? > also is there a way to import/export data of the hdf format? > is there a way to import/export hdf format for ms excel as well? > thank you very much in advance. > /js--------------- Charles RAUX, Laboratoire d'Economie des Transports CNRS-Universit? Lumi?re Lyon 2-ENTPE email : charles.raux at let.ish-lyon.cnrs.fr http://www.ish-lyon.cnrs.fr/let -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Depends on the particulars of the data. Here's how I move between R and
Excel for tables of the form
col1 col2 ... colm
row1 # # ... #
row2 # # ... #
. . . .
. . . .
. . . .
rown # # ... #
where 'rowi' and 'colj' are labels (no spaces) and # numbers in
body of table.
Excel -> R
Use 'save as space delimited text (.prn)' in Excel to create a text file
name, say, 'table.txt', and
'data.matrix(read.table("table.txt")) in R to
return as two dimensional array in R with row and column labels.
R -> Excel
Use sink("table"), where 'table' is the name of the R object,
to print to a
text file, then open the file in Excel and follow the import wizard steps.
At 10:42 PM 30/08/2000 -1000, you wrote:>how can I import/export data from ms excel?
>also is there a way to import/export data of the hdf format?
>is there a way to import/export hdf format for ms excel as well?
>thank you very much in advance.
>/js
>######################################################################
>This e-mail message has been scanned and cleared by MailMarshal
>http://www.marshalsoftware.com
>######################################################################
>-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
>r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
>Send "info", "help", or "[un]subscribe"
>(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
>_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
>
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._