Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Export data depuis R vers Excel

ayi

I am writing code to export database from R into Excel, I have been trying others code including:
<pre><code class="lang-auto">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>
Other users of this forum advised me this:
<pre><code class="lang-auto">write.csv2(ALBERTA1, "ALBERTA1.csv")
write.table(kt, "D:/kt.txt", sep="\t", row.names=FALSE)

</code></pre>
You can see on the pictures the outcome I have got from the code 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?
<hr>
Source : <a href="https://cran.r-project.org/web/packages/openxlsx/index.html" rel="noopener nofollow ugc">Stack Overflow</a>,)

ayi_2

Another option is the <code>openxlsx</code>-package (<a href="https://cran.r-project.org/web/packages/openxlsx/index.html">CRAN</a>, <a href="https://ycphs.github.io/openxlsx/index.html">website</a>, <a href="https://github.com/ycphs/openxlsx">GitHub</a>). It doesn’t depend on <a href="/questions/tagged/java">java</a> and can read, edit and write Excel-files. From the description from the package:
<blockquote></blockquote>
openxlsx simplifies the the process of writing and styling Excel xlsx files from R and removes the dependency on Java
Example usage:
<pre><code class="lang-auto">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')

</code></pre>
Besides these two basic functions, the <code>openxlsx</code>-package has a host of other functions for manipulating Excel-files.
For example, with the <code>writeDataTable</code>-function you can create formatted tables in an Excel-file.