[R] element search

Schmitt, Corinna Corinna.Schmitt at igb.fraunhofer.de
Thu Apr 19 12:45:53 CEST 2007

Sorry, I forgot the attachment. Here it is.

Thanks, Corinna

-----Ursprüngliche Nachricht-----
Von: Schmitt, Corinna 
Gesendet: Donnerstag, 19. April 2007 12:32
An: 'r-help at stat.math.ethz.ch'
Betreff: element search 

Dear R-experts,

I have got an excel file as attached. I imported it successful with the commands:

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

More information about the R-help mailing list