On Thursday 05 October 2006 04:05, bryan rasmussen wrote: > Hi, > > I have a project to analyse the various Web server statistics for a > server on a weekly basis for the past year using data maintained in > about 20 excel files per week. I need to go through these files and > aggregate the data, obviously the excel files are pretty simple 2 > column affairs (I say obviously because otherwise why was the data > maintained in 20 files for web site usage per week if the files > themselves were not very simple) I am looking for examples of going > over a bunch of excel files with R, extracting the data and then > aggregating for analysis.
You probably want to write to the R-help list, not the R-devel list. That said, you probably want to look at the dir() command and read.xls() from the gdata/gtools/gplots packages (you need to install all three). Alternatively, you can look at using ODBC to connect to the files. Sean ______________________________________________ R-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
