RからODBCでExcelを読む。(書くのも出来るらしいけど、やったことなし)
odbc.r
library(RODBC)
con <- odbcConnectExcel2007("odbc.xlsx")
## テーブル名 = [<シート名>$]
sql <- "select * from [Sheet1$]"
sqlQuery(con, sql)
odbcClose(con)
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme
List of users who liked
22