Dear R-experts,
I have got an excel file as attached. I imported it successful with the
commands:
library(RODBC)
channel <- odbcConnectExcel("data2.xls")
tables <- sqlTables(channel) # list the names of the spreadsheets
name1 <- tables[1, "TABLE_NAME"] # get the name of the 1st spreadsheet
plan1 <- sqlQuery(channel, sprintf("select * from [%s]", name1))
odbcClose(channel) # close it
Now I want to store each row in variable. Additionally the result should
be a list again so that I can handle each entry for itself. Ideas?
Perhaps a list again?
Now I want to find on the one hand in each row one special entry and on
the other hand I need to get the maximum entry of each row. How can I
realize this?
Thanks, Corinna
______________________________________________
[email protected] 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.
