R_dataimport

#Change working directory
> setwd("C:/Users/Freddie/Documents/R")

#convert table to data frame
> as.data.frame.matrix(mytable) 

#Import xcel file (gdata package needed) 1. read data (Perl runtime needed)
> library(gdata)                   # load gdata package 
> help(read.xls)                   # documentation 
> mydata = read.xls("mydata.xls")  # read from first sheet 

#or 2. load workbook (java needed)
> library(gdata)                   # load gdata package 
> help(read.xls)                   # documentation 
> mydata = read.xls("mydata.xls")  # read from first sheet 

#Import table file -  no headers
> mydata = read.table("mydata.txt")  # read text file 
> mydata                             # print data frame 

#Import CSV file - with headers
> mydata = read.csv("mydata.csv")  # read csv file 
> mydata 				# print data frame 
#Example: stringsAsFactors is a logical that indicates whether strings in a data frame should be treated as factor variables or as just plain strings.
> songs <- read.csv ("songs.csv", stringsAsFactors = FALSE) 
> str(songs)

#example: getting, adding,renaming and removing worksheets in excel
>fish <- loadWorkbook("fish.xlsx")
>createSheet(fish, "fish_page3")
>renameSheet(fish,2, "newname")
>removeSheet(fish,3)
>getSheets(fish)