2 ms·
For the ones that aren't formatted randomly in Excel: library(RODBC) channel <- odbcConnectExcel("myExcelFile.xls") myDataFrame <- sqlFetch(channel, "Sheet1"
by hessenwolf 15y ago
For the ones that aren't formatted randomly in Excel:
library(RODBC)
channel <- odbcConnectExcel("myExcelFile.xls")
myDataFrame <- sqlFetch(channel, "Sheet1")
odbcCloseAll()
write.csv(
file = paste("myExcelFile", "Sheet1.csv"),
myDataFrame,
row.names = F
)