I use sep="\t" for Excel files and sep="," for csv files. # Save to Excel write.table(objectname, file = "C:/Documents andSettings/Desktop/myfile.xls",sep="\t")
Felipe D. Carrillo Supervisory Fishery Biologist Department of the Interior US Fish & Wildlife Service California, USA --- On Tue, 9/15/09, jim holtman <jholt...@gmail.com> wrote: > From: jim holtman <jholt...@gmail.com> > Subject: Re: [R] Reading a data frame from R to excel > To: "filip rendel" <fili...@hotmail.com> > Cc: r-help@r-project.org > Date: Tuesday, September 15, 2009, 3:32 AM > 'write.csv' works fine for me in > exporting to Excel as a '.csv' file. > Did you specify a separator (sep=',') in your > 'write.table'? > > On Tue, Sep 15, 2009 at 5:58 AM, filip rendel <fili...@hotmail.com> > wrote: > > > > Hello! I've generated multiple data frames that I wish > to export to excel using the function write.table. When I do > so all the data is merged into a single column in excel. I > Would like the columns of my data frame in separate columns > in excel as well but it doesn't work. I tried to download > the package WriteXLS and installed Perl on my computer just > like it was recommended. I also tried downloading > dataframes2xls but none of them work. Is there an easier way > of solving this? > > > > Would be very thankful for a reply! > > > > [[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. > > > > > > -- > Jim Holtman > Cincinnati, OH > +1 513 646 9390 > > What is the problem that you are trying to solve? > > ______________________________________________ > 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.
