Similar story with gene names.
I have a few genes such as SEP7, SEP10... if the file is touched by
Excel, they're gone!
I can avoid using Excel, but I can't be sure that when I receive a
file from somebody else it will not contain that sort of errors.
The first thing I do when I get a new
Quoting Robert A LaBudde [EMAIL PROTECTED]:
If you format the column as Text, you won't have this problem. By
leaving the cells as General, you leave it up to Excel to guess at
the correct interpretation.
You will note that the conversion to a date occurs immediately in
Excel when you enter
Quoting J Dougherty [EMAIL PROTECTED]:
On Monday 27 August 2007 22:21, David Scott wrote:
On Tue, 28 Aug 2007, Robert A LaBudde wrote:
If you format the column as Text, you won't have this problem. By
leaving the cells as General, you leave it up to Excel to guess at
the correct
On my version of Excel (Excel 2007 under Vista) using
File | Open on a file, a.txt such as:
a b
sep7 10
sep10 11
causes it to enter a wizard where it asks you for the delimiters and
column types so you can change it from what it offers as the default.
In particular, if you leave it at General it
Yes, and then you save it, you open it again... same behaviour.
The only way I found around it was to insert a character at the
beginning of every element in such columns. An apostrophe works, but
it looks ugly. Yes, when loading the data in R you could easily clean
it up automatically...
That is not what happens in Excel 2007 when I tried it just now. I tried
saving the same file I displayed in my prior message as an .xls file and
as an .xlsx file and in both cases the first column came back as text,
as I had specified to the Wizard on the initial import. I guess they fixed
the
[Apologies if you sometime get this twice. The first mailing
has not been delivered to the list after more than 10 hours]
On 31-Aug-07 10:38:07, Jim Lemon wrote:
Rolf Turner wrote:
On 31/08/2007, at 9:10 AM, Antony Unwin wrote:
Erich's more important point
is that you need to speak the
On 2007-August-31 , at 00:13 , David Scott wrote:
On Thu, 30 Aug 2007, Duncan Murdoch wrote:
On 8/28/2007 3:16 AM, J Dougherty wrote:
On Monday 27 August 2007 22:21, David Scott wrote:
On Tue, 28 Aug 2007, Robert A LaBudde wrote:
If you format the column as Text, you won't have this
There is a hack to get around the problem.
It is definitely not a good solution, just a hack.
Open the .csv file in a text editor and select everything.
Paste it into an empty Excel sheet.
Then use Data - Text to Columns
The third dialog box (at least it is the third one in Excel 2003)
allows
The quickest solution is to additionally install the package rcom from CRAN.
A more detailed account can be found on our wiki at
http://rcom.univie.ac.at
especially on
http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=version_information_and_links
Greg Snow wrote:
Erich,
I just
Rolf Turner wrote:
On 31/08/2007, at 9:10 AM, Antony Unwin wrote:
Erich's more important point
is that you need to speak the language of the people you cooperate
with and often that language includes Excel.
So if the people you have to deal with are into astrology you should
learn
On 30/8/07 6:42 AM, Erich Neuwirth wrote:
There is one feature in Excel which is extremely convenient, Pivot
tables. Anybody doing any work as statistical consultant really ought to
know about Pivot tables, and I am still surprised how many statisticians
do not know about it. Neither Gnumeric
or Erlang) to do what
you describe.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of François Pinard
Sent: Wednesday, August 29, 2007 11:36 AM
To: Alberto Monteiro
Cc: r-help@stat.math.ethz.ch
Subject: Re: [R] Excel (off-topic, sort of)
[Alberto
On Wed, 29 Aug 2007, Alberto Monteiro wrote:
Do you know what's in my wish list?
I wish spreadsheets and computer languages had gone one
step further.
I mean, it's nice to define Cell X to be equal to
Cell Y + 10, and then when we change Cell Y, magically we
see Cell X change.
But why
On 8/28/2007 3:16 AM, J Dougherty wrote:
On Monday 27 August 2007 22:21, David Scott wrote:
On Tue, 28 Aug 2007, Robert A LaBudde wrote:
If you format the column as Text, you won't have this problem. By
leaving the cells as General, you leave it up to Excel to guess at
the correct
On 8/30/2007 10:43 AM, Thomas Lumley wrote:
On Wed, 29 Aug 2007, Alberto Monteiro wrote:
Do you know what's in my wish list?
I wish spreadsheets and computer languages had gone one
step further.
I mean, it's nice to define Cell X to be equal to
Cell Y + 10, and then when we change Cell Y,
generally works better).
Erich Neuwirth wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Wednesday, August 29, 2007 4:46 PM
To: r-help
Subject: Re: [R] Excel
Greg Snow wrote:
Or do you trust all of your clients to know
On 30-Aug-07 14:43:12, Thomas Lumley wrote:
On Wed, 29 Aug 2007, Alberto Monteiro wrote:
Do you know what's in my wish list?
I wish spreadsheets and computer languages had gone one
step further.
I mean, it's nice to define Cell X to be equal to
Cell Y + 10, and then when we change Cell Y,
, August 30, 2007 12:14 PM
To: Erich Neuwirth; r-help
Subject: Re: [R] Excel
Earlier this week I was doing some work at our house and since my wife was
at the dentist office our 3 year old son was helping me. He really wanted
to use the hammer, so I showed him where to tap and he was excited
Matt Austin wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Austin, Matt
Sent: Thursday, August 30, 2007 1:25 PM
To: r-help
Subject: Re: [R] Excel
Ah . . . the hammer analogy. In a conversation like this
it's not a question
On Thu, 2007-08-30 at 13:38 -0600, Greg Snow wrote:
Matt Austin wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Austin, Matt
Sent: Thursday, August 30, 2007 1:25 PM
To: r-help
Subject: Re: [R] Excel
Ah . . . the hammer
Flame wars are usually vituperative, often entertaining, and
occasionally productive. Excel is good for accounts and for taking
notes, sometimes for back-of-the-envelope calculations. It is not so
suitable for statistics and its formulae can be incomprehensible when
you try to understand
On 31/08/2007, at 9:10 AM, Antony Unwin wrote:
Erich's more important point
is that you need to speak the language of the people you cooperate
with and often that language includes Excel.
So if the people you have to deal with are into astrology you should
learn astrology?
On 30/08/2007 5:27 PM, Rolf Turner wrote:
On 31/08/2007, at 9:10 AM, Antony Unwin wrote:
Erich's more important point
is that you need to speak the language of the people you cooperate
with and often that language includes Excel.
So if the people you have to deal with are into astrology
On Thu, 30 Aug 2007, Duncan Murdoch wrote:
On 8/28/2007 3:16 AM, J Dougherty wrote:
On Monday 27 August 2007 22:21, David Scott wrote:
On Tue, 28 Aug 2007, Robert A LaBudde wrote:
If you format the column as Text, you won't have this problem. By
leaving the cells as General, you leave it up
Dougherty
Cc: r-help@stat.math.ethz.ch
Subject: Re: [R] Excel
On 28/08/2007, at 7:16 PM, J Dougherty wrote:
snip
PS, I quit using Excel for most important work after it returned a
negative
variance on some data I was collecting descriptive statistics on.
Those of you who have
Chris wrote:
Typically, people in the R community are not used to the spreadsheet
paradigm and need some time to be able to take advantage of
automatic recalculation, (...)
Do you know what's in my wish list?
I wish spreadsheets and computer languages had gone one
step further.
I mean,
--- Rolf Turner [EMAIL PROTECTED] wrote:
On 28/08/2007, at 7:16 PM, J Dougherty wrote:
snip
PS, I quit using Excel for most important work
after it returned a
negative
variance on some data I was collecting descriptive
statistics on.
Those of you who have not seen it
Take a look at Mathematica or Maple. This is the kind of thing you do
with these languages.
Best,
Philippe Grosjean
Alberto Monteiro wrote:
Chris wrote:
Typically, people in the R community are not used to the spreadsheet
paradigm and need some time to be able to take advantage of
[EMAIL PROTECTED] wrote:
...
Here are a few additional comments related to the representation issue in
.csv files:
What is said about the .csv files with respect to rounding also holds for the
windows clipboard but not for the office clipboard. If you format data in an
excel range,
[Alberto Monteiro]
Maybe I'll write a letter to Santa Claus [there are people
who write to congressman; they must have more faith than me].
:-) :-)
I wish a language where I can write
a = b + 10
and then when I write
a = 20
the language automatically assigns b = 10.
METAFONT does
PROTECTED] On Behalf Of François Pinard
Sent: Wednesday, August 29, 2007 11:36 AM
To: Alberto Monteiro
Cc: r-help@stat.math.ethz.ch
Subject: Re: [R] Excel (off-topic, sort of)
[Alberto Monteiro]
Maybe I'll write a letter to Santa Claus [there are people
who write to congressman; they must have more
Excel bashing can be fun but also can be dangerous because
you are makeing your life harder than necessary.
Statisticians meanwhile know that the numerics of statistical
computation can be quite bad, therefore one should not use them.
But using our (we = Thomas Baier + Erich Neuwirth) RExcel addin
Statistics
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Wednesday, August 29, 2007 11:43 AM
To: r-help
Subject: Re: [R] Excel
Excel bashing can be fun but also can be dangerous because
you are makeing your life harder than necessary
Genentech Nonclinical Statistics
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Wednesday, August 29, 2007 11:43 AM
To: r-help
Subject: Re: [R] Excel
Excel bashing can be fun but also can be dangerous because
you are makeing your
Erich Neuwirth said:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Wednesday, August 29, 2007 12:43 PM
To: r-help
Subject: Re: [R] Excel
Excel bashing can be fun but also can be dangerous because
you are makeing your
On 30/08/2007, at 8:49 AM, Greg Snow wrote:
Erich Neuwirth said:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Wednesday, August 29, 2007 12:43 PM
To: r-help
Subject: Re: [R] Excel
Excel bashing can be fun but also can
Greg Snow wrote:
Or do you trust all of your clients to know to use R(D)COM as well as
how to install and use it?
Do you trust your clients to be fluent enough in R to use it?
For most of my clients, that is not true.
For this kind of users, the following strategy works.
They have their
Rolf Turner wrote:
On 30/08/2007, at 8:49 AM, Greg Snow wrote:
Erich Neuwirth said:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Wednesday, August 29, 2007 12:43 PM
To: r-help
Subject: Re: [R] Excel
Excel bashing can
, Greg Snow wrote:
Erich Neuwirth said:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Wednesday, August 29, 2007 12:43 PM
To: r-help
Subject: Re: [R] Excel
Excel bashing can be fun but also can be dangerous because
you
On Monday 27 August 2007 22:21, David Scott wrote:
On Tue, 28 Aug 2007, Robert A LaBudde wrote:
If you format the column as Text, you won't have this problem. By
leaving the cells as General, you leave it up to Excel to guess at
the correct interpretation.
Not true actually. I had
At 01:21 AM 8/28/2007, David wrote:
On Tue, 28 Aug 2007, Robert A LaBudde wrote:
If you format the column as Text, you won't have this problem. By
leaving the cells as General, you leave it up to Excel to guess at
the correct interpretation.
Not true actually. I had converted the column to Text
Subject: [R] Excel
A common process when data is obtained in an Excel
spreadsheet is to save
the spreadsheet as a .csv file then read it into R. Experienced users
might have learned to be wary of dates (as I have) but
possibly have not
experienced what just happened to me. I thought I might just
On 28/08/2007, at 7:16 PM, J Dougherty wrote:
snip
PS, I quit using Excel for most important work after it returned a
negative
variance on some data I was collecting descriptive statistics on.
Those of you who have not seen it should have a look at Jonathan
Cryer's commentary
on
A common process when data is obtained in an Excel spreadsheet is to save
the spreadsheet as a .csv file then read it into R. Experienced users
might have learned to be wary of dates (as I have) but possibly have not
experienced what just happened to me. I thought I might just share it with
If you format the column as Text, you won't have this problem. By
leaving the cells as General, you leave it up to Excel to guess at
the correct interpretation.
You will note that the conversion to a date occurs immediately in
Excel when you enter the value. There are many formats to enter
On Tue, 28 Aug 2007, Robert A LaBudde wrote:
If you format the column as Text, you won't have this problem. By
leaving the cells as General, you leave it up to Excel to guess at
the correct interpretation.
Not true actually. I had converted the column to Text because I saw the
As far as I understand, changing the format changes
the way data is displayed by Excel but this does not
change the data itself - if while reading the data
Excel decided that it was a date, it is being
converted to an integer (the number of days since
January 1, 1900 - and they mistakenly think
On Fri, 10 Aug 2007, Peter Wickham wrote:
I am running R 2.5.1 using Mac OSX 10.4.10. xlsReadWrite is a Windows
binary. Instead, install and load packages: (1) gtools:(2) gdata. These
are both Windows and Mac binaries. gdata depends on gtools, so be sure
to load gtools first or set the
-help@stat.math.ethz.ch 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.
--
View this message in context:
http://www.nabble.com/R-excel
cf. R Data Import/Export
file:///tmp/RtmpnFqONj/.R/doc/manual/R-data.htmlin the standard
documentation.
Christophe
On 6/25/07, Erika Frigo [EMAIL PROTECTED] wrote:
Good morning to everybody,
I have a problem : how can I import excel files in R???
thank you very much
Dr.sa. Erika Frigo
Good morning to everybody,
I have a problem : how can I import excel files in R???
thank you very much
Dr.sa. Erika Frigo
Università degli Studi di Milano
Facoltà di Medicina Veterinaria
Dipartimento di Scienze e Tecnologie Veterinarie per la Sicurezza Alimentare
(VSA)
Via Grasselli, 7
http://cran.r-project.org/doc/manuals/R-data.html#Reading-Excel-spreadsheets
plus there is a package xlsReadWrite that might be of your interest.
Stefan
Original Message
Subject: [R] R-excel
From: Erika Frigo [EMAIL PROTECTED]
To: r-help@stat.math.ethz.ch
Date: 25.06.2007 14
Hi,
Directly import from Excel files should be possible using the RODBC
package. Yu may want to read the R data import/export manual about the
RODBC package for further details.
Another solution is to save each of your Excel sheets as *.csv file and
import the data in R using the read.table
Also try xlsReadWrite package on CRAN.
--- Erika Frigo [EMAIL PROTECTED] wrote:
Good morning to everybody,
I have a problem : how can I import excel files in
R???
thank you very much
Dr.sa. Erika Frigo
Università degli Studi di Milano
Facoltà di Medicina Veterinaria
Dipartimento
The R(D)COM server (contaiong the RExcel Excel addin) and/or the rcom
package allow (among other things) to select a range in Excel and
directly transfer it to R as an array or as a dataframe.
It only works on Windows with Excel and R installed.
More information on these packages is available at
There are also some notes about this in the R Data Import/Export manual:
http://cran.r-project.org/doc/manuals/R-data.html#Reading-Excel-spreadsheets
But I've gathered the following examples from the R-help mailing list
archives [in addition to the option of saving the spreadsheet as a .csv file
Hi folks,
Is it possible to have Excel call a R function. If not, how about making Excel
send off a command to call a R script and then read the result back into Excel.
I know, I know, this should belong to some Excel forum, but i just try my luck
here.
Thanks in advance.
Horace W. Tso
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Horace Tso
Sent: Friday, June 01, 2007 11:51 AM
To: r-help@stat.math.ethz.ch
Subject: [R] Excel calling R functions
Hi folks,
Is it possible to have Excel call a R function. If not, how about making
Excel send off a command to call a R script
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Horace Tso
Sent: Friday, June 01, 2007 11:51 AM
To: r-help@stat.math.ethz.ch
Subject: [R] Excel calling R functions
Hi folks,
Is it possible to have Excel call a R function. If not, how about making
Excel send off
try
my luck here.
Thanks in advance.
Horace W. Tso
See the R-Excel add-in linked from here:
http://www.sciviews.org/_rgui/projects/RDcom.html
HTH,
Marc Schwartz
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r
Horace Tso wrote:
Is it possible to have Excel call a R function. If not, how about
making Excel send off a command to call a R script and then read the
result back into Excel.
I know, I know, this should belong to some Excel forum, but i just
try my luck here.
You can always put R
Excel forum, but i just try
my luck here.
Thanks in advance.
Horace W. Tso
See the R-Excel add-in linked from here:
http://www.sciviews.org/_rgui/projects/RDcom.html
Some of the files listed in the link on that page appear
to be quite outdated. The following link brings you
the
result back into Excel.
I know, I know, this should belong to some Excel forum, but i just try
my luck here.
Thanks in advance.
Horace W. Tso
See the R-Excel add-in linked from here:
http://www.sciviews.org/_rgui/projects/RDcom.html
Some of the files listed in the link
. If not, how about
making Excel send off a command to call a R script and then read the
result back into Excel.
I know, I know, this should belong to some Excel forum, but i just try
my luck here.
Thanks in advance.
Horace W. Tso
See the R-Excel add-in linked from here:
http://www.sciviews.org
Hello to all,
How can I make R read the data from an Excel sheet?
thanks,
ozlem
[[alternative HTML version deleted]]
__
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
library(xlsReadWrite)
?read.xls
KR,
Alin Soare
2007/5/12, Ozlem Ipekci [EMAIL PROTECTED]:
Hello to all,
How can I make R read the data from an Excel sheet?
thanks,
ozlem
[[alternative HTML version deleted]]
__
R-help@stat.math.ethz.ch
library(RODBC);
# 1. READ DATA FROM EXCEL INTO R
xlsConnect-odbcConnectExcel(C:\\temp\\demo.xls);
demo-sqlFetch(xlsConnect, Sheet1);
odbcClose(xlsConnect);
rm(demo);
On 5/12/07, Ozlem Ipekci [EMAIL PROTECTED] wrote:
Hello to all,
How can I make R read the data from an Excel sheet?
thanks,
Hi every one,
I am very very new to R and solicit your kind help
I am trying to use my excel files in R. I used the
Xlread/write package and able to load the a sample
file into console. Then I tried to find the mean of a
column vector for example. But I could not proceed
Here is the problem
ramelan thiagarajah [EMAIL PROTECTED] writes:
Hi every one,
I am very very new to R and solicit your kind help
I am trying to use my excel files in R. I used the
Xlread/write package and able to load the a sample
file into console. Then I tried to find the mean of a
column vector for
at 11:50, Bernardo Rangel tura wrote:
Date sent: Sat, 15 Jul 2006 11:50:14 -0300
To: R-help@stat.math.ethz.ch
From: Bernardo Rangel tura [EMAIL PROTECTED]
Subject:[R] Excel to R
Hi peolple!
I have a many excel tables
Bernardo == Bernardo Rangel tura [EMAIL PROTECTED] writes:
Well I use this scripts to import the database
require(RODBC)
channel - odbcConnectExcel(f:/teste.xls)
data - sqlFetch(channel, Sheet1)
Just convert qw to a factor:
require(RODBC)
channel -
Hi peolple!
I have a many excel tables with mode than 100 variables. And I want
use R to analize that.
But I have a problem, a group of this variables (more than 50) in any
table is a factor and other part is a number.
Tha factors variables have tha values enconde this form (1=Yes,2=No and
hi,
i am using the RODBC package to read excel files using
odbcConnectExcel and susequently sqlFetch to read the contents of the
file.
the file that i use is just a matrix of numbers thats all. no headers
and column names. what happens is that the sqlFetch is not reading my
first row of numbers.
hi,
the specifications for my application call that the input file be in
excel only in the format i previously mentioned.
now if the approach you mention has to be used then the part of
converting has to be done automatically. this i found to be too
complex.
an alternative to that was to use MS
Subramanian
Sent: Thursday, 16 June 2005 19:01
To: ronggui; rhelp
Subject: Re: [R] Excel files first row not being read
hi,
the specifications for my application call that the input file be in
excel only in the format i previously mentioned.
now if the approach you mention has to be used
Subject: Re: [R] Excel files first row not being read
hi,
the specifications for my application call that the input file be in
excel only in the format i previously mentioned.
now if the approach you mention has to be used then the part of
converting has to be done automatically. this i
If you would post your R code and explain how a simple Excel matrix is set
up, we might be able to help more.
khobson at odot.org
Kenneth Ray Hobson, P.E.
Oklahoma DOT - QA IAS Manager
200 N.E. 21st Street
Oklahoma City, OK 73105-3204
(405) 522-4985, (405) 522-0552 fax
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Vivek
Subramanian
Sent: Thursday, 16 June 2005 19:01
To: ronggui; rhelp
Subject: Re: [R] Excel files first row not being read
hi,
the specifications for my application call that the input file
I read excel spreadsheats into R often using the RODBC package. I like
being able to manipulate my data in excel then import it directly into R
without saving as text. I use a windows xp machine and an older version of
R (1.9.1). Assuming you have a worksheet in melvin.xls named data, here
is
04, 2004 7:10 AM
To: Rolf Turner
Cc: [EMAIL PROTECTED]
Subject: Re: [R] Excel *.xls files, RODBC
The following works for me under WinXP Pro to create
myframe as a
data frame:
library(RODBC)
z - odbcConnectExcel(c:/myfolder/mydata.xls)
myframe - sqlFetch(z, Sheet1)
close(z
There is also a perl module that converts excel files to .csv on CPAN.
It works fine for everything I've ever used it for, which is really
simple stuff, i.e. no cells defined by functions.
steps involved:
1. go to www.cpan.org and find the package, download it
2. ensure you have the necessary
On Tue, 2004-12-07 at 04:09 +1100, James Muller wrote:
There is also a perl module that converts excel files to .csv on CPAN.
It works fine for everything I've ever used it for, which is really
simple stuff, i.e. no cells defined by functions.
steps involved:
1. go to www.cpan.org and
Rolf Turner rolf at math.unb.ca writes:
:
: I gather from reading the back-issues of r-help that it should be
: possible (modulo a number of caveats) to read an excel (yuck!) file
: into R using RODBC. I have obtained and installed ODBC and the RODBC
: package, but cannot for the life of me
On Sun, Dec 05, 2004 at 12:58:19PM +, Gabor Grothendieck wrote:
Rolf Turner rolf at math.unb.ca writes:
:
: I gather from reading the back-issues of r-help that it should be
: possible (modulo a number of caveats) to read an excel (yuck!) file
: into R using RODBC. I have obtained and
: Date: Sun, 5 Dec 2004 10:35:46 -0600
: From: Dirk Eddelbuettel [EMAIL PROTECTED]
: To: Gabor Grothendieck [EMAIL PROTECTED]
: Cc: [EMAIL PROTECTED]
: Subject: Re: [R] Excel *.xls files, RODBC
:
:
: On Sun, Dec 05, 2004 at 12:58:19PM +, Gabor Grothendieck wrote:
: Rolf
I gather from reading the back-issues of r-help that it should be
possible (modulo a number of caveats) to read an excel (yuck!) file
into R using RODBC. I have obtained and installed ODBC and the RODBC
package, but cannot for the life of me figure out how to go about
it. Can anyone give me a
library(RODBC)
z - odbcConnectExcel(c:/myfolder/mydata.xls)
myframe - sqlFetch(z, Sheet1)
close(z)
I found the reading of whole sheets somewhat unsafe, so I always create a named
range (here: data) including header and do the following.
Never had problems with this.
channel =
Chuck Cleland wrote:
The following works for me under WinXP Pro to create myframe as a
data frame:
library(RODBC)
z - odbcConnectExcel(c:/myfolder/mydata.xls)
myframe - sqlFetch(z, Sheet1)
close(z)
I tried that and got the error message:
Error: couldn't find function odbcConnectExcel
On Sat, 2004-12-04 at 14:32 -0400, Rolf Turner wrote:
Chuck Cleland wrote:
The following works for me under WinXP Pro to create myframe as a
data frame:
library(RODBC)
z - odbcConnectExcel(c:/myfolder/mydata.xls)
myframe - sqlFetch(z, Sheet1)
close(z)
It would appear then,
On Sat, 4 Dec 2004 14:32:24 -0400 (AST)
Rolf Turner [EMAIL PROTECTED] wrote:
Chuck Cleland wrote:
The following works for me under WinXP Pro to create myframe as a
data frame:
library(RODBC)
z - odbcConnectExcel(c:/myfolder/mydata.xls)
myframe - sqlFetch(z, Sheet1)
close(z)
Success! Tobias Verbeke's kind suggestion of read.xls from the
gdata package (from the gregmisc bundle) works like a charm.
It's perl based, so no problema on Linux.
The R community is wonderful!
cheers,
off list and I'll send a copy.
http://jakarta.apache.org/poi/index.html
Regards,
Whit
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rolf Turner
Sent: Saturday, December 04, 2004 2:43 PM
To: [EMAIL PROTECTED]
Subject: Re: [R] Excel *.xls files, RODBC
Dear all,
I am quite new to R and for preofessional reasons I was interested in the
R/excel interface by Baier and Neuwirth. After setup I see the Rexcel and the
Rhelp on the Menu bar of Microsoft Excel XP. However, after putting the formula
=RApply(pchisqr, 30, 1) Excel returns the message
On Sun, 14 Nov 2004, Andreas Betz wrote:
I am quite new to R and for preofessional reasons I was interested in
the R/excel interface by Baier and Neuwirth. After setup I see the
Rexcel and the Rhelp on the Menu bar of Microsoft Excel XP. However,
after putting the formula =RApply(pchisqr, 30, 1
Hello all...
I am really new to statistics and I am trying to figure out a way to
apply Chauvenet's criterion using the t-distribution on a set of numbers
in perl. I was unable to find a TDIST and TINV function for perl. I am
getting these functions from Excel. So, I figured that I
We are hardly likely to know what those are in Excel. Possibly pt and qt,
but see help.search(Student t distribution) for where to look for what R
provides.
I also do not know what Chauvenet's criterion has to do with Student's t,
and
Brian Ripley wrote:
We are hardly likely to know what those are in Excel. Possibly pt
and qt, but see help.search(Student t distribution) for where to
look for what R provides.
I also do not know what Chauvenet's criterion has to do with
Student's t, and
Hi,
How do I open an excel file in R? I have save the excel file in unicode text
format, but it is not possible to open the file in R.
/Pernilla
__
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the
-Ursprüngliche Nachricht-
Von: TEMPL Matthias
Gesendet: Montag, 12. Juli 2004 17:29
An: 'Pernilla Karlsson'
Betreff: Re: [R] Excel file
It is possible to open the file in R.
?read.table
excelfile - read.table(../file.txt, sep=,, header=T)
when you have a komma
1 - 100 of 150 matches
Mail list logo