将数据从R导出到Excel

问题描述:

我试图将从R获取的一些结果导出到Excel失败。我尝试了以下代码:

I'm trying to export some results obtained from R into Excel unsuccesfully. I have tried the following codes:

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").

但是我从excel文件的数据仍然搞乱了,因此我不能操作任何计算。这两个数据在同一列中。您可以向我建议一些其他功能吗?

But my data from excel file is still messed up togheter and consequently i can't operate any computations. the two data are inside the same colums. the Please can you suggest me some other functions?

我在Excel中管理CSV数据的工作:

What I did to manage the CSV data in Excel:


  1. 在顶部菜单中找到数据

  2. 在菜单中间选择文字到列...。

  3. 指令,然后您获取列中的数据

http://superuser.com/questions/364555/how-to-break-a-spreadsheet-containing-csv-into-multiple-栏