search for: spreadsheet_002dlike

...39;, I still can not see how to read multiple sheets from one Excle file or one csv file and put them into one R data.frame. Or does anyone ever used any packages in part 8 shown in the following link that can help to do the job I mentioned here?? http://cran.r-project.org/doc/manuals/R-data.html#Spreadsheet_002dlike-data Many thanks in advance! HJ I know how to import one single worksheet in one file but would like to know how to import data from .csv file containning multiple worksheets. [[alternative HTML version deleted]]

I have a file named "test.csv" with the following 3 lines: %y-%m-%d;VALUE 1999-01-01;100 2000-12-31;999 > read.table("test.csv", header = TRUE, sep = ";") delivers: X.y..m..d VALUE 1 1999-01-01 100 2 2000-12-31 999 I would like to see the following ... %y-%m-%d VALUE 1 1999-01-01 100 2 2000-12-31 999 Note, >