[問題類型]:
程式諮詢(我想用R 做某件事情，但是我不知道要怎麼用R 寫出來)
[軟體熟悉度]:
入門(寫過其他程式，只是對語法不熟悉)
[問題敘述]:
有一個用readlx匯入的.xlsx檔整理後想再匯出到excel
但用write.csv會跑掉 （不同的兩列資料被存在同一列）
https://i.imgur.com/i2eRdWF.jpg
沒有找到解決的辦法 所以想用xlsx匯出成.xlsx試試
但xlsx跟rJava都載不進去 看過一些國外網站 還是沒辦法解決
[程式範例]:
https://i.imgur.com/IW4xhf8.jpg
[環境敘述]:
R version 3.4.2 (2017-09-28)
Platform: x86_64-apple-darwin15.6.0 (64-bit)
Running under: macOS Sierra 10.12.6
Matrix products: default
BLAS:
/System/Library/Frameworks/Accelerate.framework/Versions/A/Frameworks/vecLib.f
r
LAPACK:
/Library/Frameworks/R.framework/Versions/3.4/Resources/lib/libRlapack.dylib
locale:
[1] zh_TW.UTF-8/zh_TW.UTF-8/zh_TW.UTF-8/C/zh_TW.UTF-8/zh_TW.UTF-8
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] rio_0.5.9
loaded via a namespace (and not attached):
[1] compiler_3.4.2 magrittr_1.5 tools_3.4.2
haven_1.1.0
[5] foreign_0.8-69 tibble_1.3.4 curl_2.8.1
Rcpp_0.12.12
[9] cellranger_1.1.0 readxl_1.0.0 data.table_1.10.4-3
forcats_0.2.0
[13] openxlsx_4.0.17 rlang_0.1.2
[關鍵字]:
write.csv格式跑掉, xlsx安裝錯誤