Hi > > In Excel, make sure that your data has a format that corresponds to an R
> data frame (first row with column names, consistent column size and data type). > Export your .XLS worksheet as .CSV file (mydata.csv). > In R, read it into a data frame with > > > read.csv( "mydata.csv" ) Another option is simple copy/paste way. In Excel select the data area you want to transfer (preferably formatted like stated above. Press Ctrl-C Change to R In R command window write my.data.frame <- read.delim("clipboard",...further options according to your locale...) Regards Petr > > >From here, you shold be able to reshapte the data in a way that you can > draw your boxplot. > > Rgds, > Rainer > > > On Thursday 11 August 2011 11:29:23 Blessy chemmannur Francis wrote: > > Sir, > > I am a beginner in R language. I want to import data from excel to > > R. My data contains not only numeric values but also string values.I want to > > draw a boxplot graph . I can't import or write this string data. it is > > essential for my graph.Please give me a suggestion for This. > > Thanking You, > > > > > > BLESSY.C.F. > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > 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. > > ______________________________________________ > 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. ______________________________________________ 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.