Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Export data from R to Excel

Tags:

r

r-faq

excel

I am writing codes to export database from R into Excel, I have been trying others codes including:

write.table(ALBERTA1, "D:/ALBERTA1.txt", sep="\t") write.csv(ALBERTA1,":\ALBERTA1.csv") your_filename_in_R = read.csv("ALBERTA1.csv") your_filename_in_R = read.csv("ALBERTA1.csv") write.csv(df, file = "ALBERTA1.csv") your_filename_in_R = read.csv("ALBERTA1.csv") write.csv(ALBERTA1, "ALBERTA1.csv") write.table(ALBERTA1, 'clipboard', sep='\t') write.table(ALBERTA1,"ALBERTA1.txt") write.table(as.matrix(ALBERTA2),"ALBERTA2.txt") write.table(as.matrix(vecm.pred$fcst$Alberta_Females[,1]), "vecm.pred$fcst$Alberta_Females[,1].txt") write.table(as.matrix(foo),"foo.txt") write.xlsx(ALBERTA2, "/ALBERTA2.xlsx") write.table(ALBERTA1, "D:/ALBERTA1.txt", sep="\t"). 

Other users of this forum advised me this:

write.csv2(ALBERTA1, "ALBERTA1.csv") write.table(kt, "D:/kt.txt", sep="\t", row.names=FALSE) 

enter image description here

You can see on the pictures the outcome I have got from this codes above. But this numbers can't be used to make any further operations such as addition with other matrices.

Has someone experienced this kind of problems?

like image 486
ntamjo achille Avatar asked Oct 16 '13 21:10

ntamjo achille


People also ask

Can I export data from R?

There are two ways of exporting data into text files through R. One is using the base R functions and another one is using the functions from the readr package to export data into text/CSV format.

How do I export output from R?

You can use the sink() function in R. It will divert all R console output between the first and second call of sink() to a file that you specify. Here is an example using a linear model fitted to the iris data set. This will create a file lm_output.


1 Answers

Another option is the openxlsx-package. It doesn't depend on java and can read, edit and write Excel-files. From the description from the package:

openxlsx simplifies the the process of writing and styling Excel xlsx files from R and removes the dependency on Java

Example usage:

library(openxlsx)  # read data from an Excel file or Workbook object into a data.frame df <- read.xlsx('name-of-your-excel-file.xlsx')  # for writing a data.frame or list of data.frames to an xlsx file write.xlsx(df, 'name-of-your-excel-file.xlsx') 

Besides these two basic functions, the openxlsx-package has a host of other functions for manipulating Excel-files.

For example, with the writeDataTable-function you can create formatted tables in an Excel-file.

like image 169
Jaap Avatar answered Oct 03 '22 02:10

Jaap