On Sep 15, 2009, at 4:58 AM, filip rendel 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 ex
Hi Filip,
Try also:
write.table(object, "yourpath_with_xls_extension",sep="\t", quote = FALSE)
HTH,
Jorge
On Tue, Sep 15, 2009 at 5:58 AM, filip rendel <> 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
ish & Wildlife Service
California, USA
--- On Tue, 9/15/09, jim holtman wrote:
> From: jim holtman
> Subject: Re: [R] Reading a data frame from R to excel
> To: "filip rendel"
> Cc: r-help@r-project.org
> Date: Tuesday, September 15, 2009, 3:32 AM
> 'write.csv&#
There is a package called 'xlsReadWrite', which has functions like
read.xls & write.xls that might be helpful for you. You can also use
write.table to produce .csv files, but you'll have to use it in the
following manner:
write.table(DataFrame, 'ExcelFile.csv', sep=",", col.names=T,
row.names=F)
'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 wrote:
>
> Hello! I've generated multiple data frames that I wish to export to excel
> using the function write.table.
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 th
6 matches
Mail list logo
