→ cywhale: 有些建議是options(java.parameters = "-Xmx1000m") 02/22 09:04
推 f496328mm: 這個是輸入xlsx吧？ 02/22 17:59
→ f496328mm: 我之前讀xlsx可以成功耶 02/22 17:59
→ locka: 原po要不要改用read.xlsx2看看? 02/22 18:02
[問題類型]:
經驗諮詢(我想用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