RinAction - R Importing Data - Excel

gistfile1.r

#################################################
#     Import data from Excel                    #
#################################################

# the best way to read an Excel file is to export it to a comma-delimted file from
# within Excel and import it to R using the method described earlier

# RODBC on Windows
install.packages("RODBC")
library(RODBC)
channel <- odbcConnectExcel("C:/RinAction/data/data.xls")
mydataframe <- sqlFetch(channel,"data")
odbcClose(channel)

# Reading XLSX file
install.packages("xlsx")
library(xlsx)
workbook <- "C:/RinAction/data/data.xlsx"
mydataframe <- read.xlsx(workbook,"data")

mydataframe