__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Another, not very nice but quite practical possibility
would be to put all your Excel files into a single
directory, convert one such file into CSV or any other
text file while recording a macro doing this (Record
Macro in Excel), then edit the recording macro making
it run over all the files in th
1. read.xls in the gdata package has a pattern= argument that
will skip everything before the first cell containing that pattern.
It calls xls2csv from the same package which in turn uses
perl so it works on all platforms and does not require a copy
of Excel.
2. If that is not good enough you cou
I think the issue here is that the Excel spreadsheets as described do not
contain simple tables of the form that the various .xls readers described
in 'R Data Import/Export' handle. Your example is not applicable (and if
it were there are several alternatives in that manual).
I would look int
Hello,
I'm not a guru but we have to do reporting with data in Excel files. We use
"xlsReadWrite" package.
Below an exemple, with an "Excel.R" file which import "MySheet" sheet from a
"MyFile.xls" workbook. First column are numeric, Second are integer. Third
character and so on.
library(xlsReadW
Dear R gurus, particularly those of generous M$ tolerance and diverse
gifts and knowledge!
I have an interesting challenge that I will end up crunching in R
involving service usage by patients. Maybe I can do all of it in R but
I can't see how yet.
My situation is that our IT Department can
6 matches
Mail list logo
