title: Export data from R to Excel
body: <p>I am writing codes to export database from R into Excel, I have been trying others codes including:</p>
  
  <pre><code>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").
  </code></pre>
  
  <p>Other users of this forum advised me this:</p>
  
  <pre><code>write.csv2(ALBERTA1, "ALBERTA1.csv")
  write.table(kt, "D:/kt.txt", sep="\t", row.names=FALSE)
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/69zFS.jpg" alt="enter image description here"></p>
  
  <p>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. </p>
  
  <p>Has someone experienced this kind of problems?</p>