Import and export of data files in R

 1. Import from CSV file

data_wheat<-read.csv("wheat_data.csv",na="***")

2.  Import from Excel file

data_wheat=read_excel("wheat_data.xlsx", sheet = "soil",na="***")

3.  Export as CSV file

write.csv(tuk.s, file="tukey_ms1.csv", quote=F, row.names=F)

4.  Export as Excel file

write.xlsx(dataframe1, file="filename.xlsx", sheetName="sheet1", row.names=FALSE)

4.  Print out as a text file

data_soil=read.csv("data_soil.csv",na="***")

data_soil=data.frame(data_soil)

Summary_1=summary(data_soil)

#-- print output of above commands in text file

sink("data anlysis.text")

print(Summary_1)