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 be
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... do
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
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
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 whe
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 Offi
[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 s
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
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 down
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 yo
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 ha
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",
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 as
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?
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 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
> &g
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
: Thursday, 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 a
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 whe
crewdriver
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:
>
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 whe
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 c
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.
(or LISP 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
> Sub
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 Gnume
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
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, Augus
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 thei
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
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 be
d everyone else know.
>
>
> Bert Gunter
> 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]
nical 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 nece
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
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 mus
[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
[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 ra
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
>>
--- Rolf Turner <[EMAIL PROTECTED]> wrote:
>
> On 28/08/2007, at 7:16 PM, J Dougherty wrote:
>
>
>
> > 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 n
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
2007 10:01 PM
To: J Dougherty
Cc: r-help@stat.math.ethz.ch
Subject: Re: [R] Excel
On 28/08/2007, at 7:16 PM, J Dougherty wrote:
> PS, I quit using Excel for most important work after it returned a
> negative
> variance on some data I was collecting descriptive statistics o
On 28/08/2007, at 7:16 PM, J Dougherty wrote:
> 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 E
r-help@stat.math.ethz.ch
> 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
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 co
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
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 tha
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
interp
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
This is very consistent with Microsoft's philosophy:
they know better than you what you want to do.
--- David Scott <[EMAIL PROTECTED]> wrote:
>
> 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 user
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
r-
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 t
ailman/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-tf3975982.html#a12101349
Sent from the R h
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
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
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
>
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 c
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.0
cf. R Data Import/Export
in 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
> Università degli Studi di Milano
> Fa
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
20137
t;> 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 Exce
g 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.
>>>
>>> H
>>
>> 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.h
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
14-455-3265
http://www.StatisticalEngineering.com
-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
: [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
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
HTH,
Marc Schwartz
__
R-help@stat.math.ethz.
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
_
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?
>
On Mon, May 14, 2007 at 12:15:12PM +0200, Soare Marcian-Alin wrote:
> library(xlsReadWrite)
> ?read.xls
I think this is windows only. If you search the mailing list you can
find a quite recent discussion on the topic:
http://finzi.psych.upenn.edu/R/Rhelp02a/archive/97970.html
Gabor
> KR,
> Alin
Ozlem,
three ways of doing this, AFAIK:
1) save Excel data as tab-delimited values in a .txt file and please see
?read.table (you will need to set 'sep="\t"')
2) check the xlsReadWrite package out, very handy!
3) see the R-DCOM server and related software by Bayer and Neuwirth, but
this is overkil
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.m
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 http://ww
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 vect
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
rfi
> "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 <- odbcC
Hi
based on your output qw is not a factor. What does say
str(data)
If your file is coded 1,2,9 it was imported as numeric and changing 9
to NA inside R does not change its nature to factor. You has to
explicitly convert qw to factor e.g.
data$qw
Subject:[R] Excel to R
>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
u have lots
> of data.
>
> JC Considine
>
> > -Original 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]
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
o:[EMAIL PROTECTED]
> Sent: Thursday, June 16, 2005 7:01 AM
> 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.
&g
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 be in
> excel only in the format i previously mentione
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 a
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.
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 an
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 se
nd
> Sent: Saturday, December 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 <- o
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
>
: 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 +, Gab
On Sun, Dec 05, 2004 at 12:58:19PM +, Gabor Grothendieck wrote:
> Rolf Turner 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
Rolf Turner 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 figure out
contact me
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 *.x
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,
Ro
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, "
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)
>
>
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 "odb
> 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 = odb
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)
Are you indicating the name of the worksheet you want within the
*.xls file? I suspect there could be addi
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 si
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
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 t
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
>
> http://www.me.umn.edu
1 - 100 of 162 matches
Mail list logo