[問題] 輸出xlsx問題

看板R_Language作者hotyigirl (yiju)時間8年前 (2017/02/21 20:48)推噓1(1推 0噓 4→)

留言5則, 3人參與討論串1/1

[問題類型]: 經驗諮詢(我想用R 連接某些資料庫，請問大家的經驗) [軟體熟悉度]: 入門(寫過其他程式，只是對語法不熟悉) [問題敘述]: 想輸出xlsx檔案，但R顯示錯誤，不知道是哪裡錯誤? [程式範例]: > library(xlsx) > camerasData <-read.xlsx("cameras.xlsx",sheetIndex=1,header=T) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream 程式碼可貼於以下網站： http://ideone.com/ http://codepad.org http://pastie.org/ http://nopaste.info/ http://pastebin.com/ http://paste.plurk.com http://gist.github.com/ http://nopaste.csie.org/ [環境敘述]: R version 3.3.2 (2016-10-31) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows 10 x64 (build 14393) locale: [1] LC_COLLATE=Chinese (Traditional)_Taiwan.950 [2] LC_CTYPE=Chinese (Traditional)_Taiwan.950 [3] LC_MONETARY=Chinese (Traditional)_Taiwan.950 [4] LC_NUMERIC=C [5] LC_TIME=Chinese (Traditional)_Taiwan.950 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] xlsx_0.5.7 xlsxjars_0.6.1 rJava_0.9-8 loaded via a namespace (and not attached): [1] tools_3.3.2 [關鍵字]: -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 1.34.160.33 ※ 文章網址: https://www.ptt.cc/bbs/R_Language/M.1487681289.A.8C9.html