similar to: Import data from Excel to R

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]]

Hello I have been searching for almost 2 hours for a certain plug-in/package, so im making this thread as i hope you can help me find it. I had my first lesson in "Statistics in use" today, and when we worked on the school computers, we could do this to import data from excel: Data > Import Data > Import from excel or "something else" Now i downloaded it for my

Hi, I would like to know if there is a special package that could help me Import/Export excel files to/from R, without changing the file type (*.csv ...) ? I have tried several packages and non of them worked on my computer .... If someone have a clue how to do it I would be grateful... Thanks for the help! -- View this message in context:

Hi I want to import Excel data into R I have used this code data<-read.table("C:\Total_Art_Policies.xls",header=TRUE,sep=";") i have an error msg: Erreur dans file(file, "r") : impossible d'ouvrir la connexion De plus : Warning message: In file(file, "r") : impossible d'ouvrir le fichier 'C:\Total_Art_Policies.xls' : No such file or

Hi every one ,,,, i have problem in R program to import the data from excel , I have done the following: 1. install.packages("xlsReadWrite") 2. library(xlsReadWrite) 3. z<- read.xls("ReadXls",LTS,colNames=FALSE,sheet,type,form,rowNames=FALSE) and i got on the result: Error in read.xls("ReadXls", LTS, colNames = FALSE, rowNames = FALSE) : object

hi!, i'm starting using R and i'd like to know how to import data from an excel format Thank you! ___________________________________________________________ -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in

Dear all, I want to import just part of an excel data file into R. I would like to have the data imported without rownames or colume names. I used read.delim("clipboard", header=F). Somehow even though I added the argument "header=F", I still have the row names V1, V2, ..., Does anyone know how to fix this? Thanks very much in advance. Hannah [[alternative

Hello everyone, What is the simplest, most RELIABLE way to import data from MS EXCEL (.xls) format to R? In the past I have used the read.xls() function from the xlsReadWrite package, however, I have been wrestling with it all afternoon long with no success. I continue to receive the following error message: > {widge<-read.xls("F:\\Classes\\Z1.Data\\stat.3010\\WidgeOne.xls", +

Hi Every one, I have a problem with Reading Excel file into R 2.9.0 version. In older versions it is working with "xlsReadWrite" package. But in 2.9.0 version there is no package like that. so help me out in this aspect. Thanks in Advance. -- View this message in context: http://www.nabble.com/How-to-Import-Excel-file-into-R-2.9.0-version-tp24914638p24914638.html Sent from the R help

The first column in my Excel sheet has mostly numbers but I need to treat it as character data: > library(RODBC) > channel <- odbcConnectExcel("U:/efg/lab/R/Plasmid/construct list.xls") > plasmid <- sqlFetch(channel,"Sheet1", as.is=TRUE) > odbcClose(channel) > names(plasmid) [1] "Plasmid Number" "Plasmid"

Hi, I am using R and I want to know how data can be transferred from Excel Spread sheet to R for analyzing. I have done like this mydata<-read.table("C:\Documents and Settings\admin\Desktop\data.txt"); but its not working how can i do it regards Sarath Sankar V

I have created an S4 object type for conducting fire department data analysis. The object includes validity check that ensures certain fields are present and that duplicate records don't exist for certain combinations of columns (e.g. no duplicate incident number / incident data / unit ID ensures that the data does not show the same fire engine responding twice on the same call). I am

Hi, All i want is to export my list into c: drive and save it as csv file and manually import into Excel. I have the read the article but i am having issues http://pbil.univ-lyon1.fr/library/base/html/write.table.html > excel<-write.table(probe_gene, file = "c:\foo.csv", sep = ",", col.names = > NA) Error in file(file, ifelse(append, "a", "w"))

Hi, I used RODBC to import data from an Excel spreadsheet "*.xls", but some columns were returned as zeros. When I looked at these columns in Excel, I found that thery are results of formula calculations and not entry. My question is: Is there any parameter or command I need to use in order to overcome this problem? Thank you Ahmad Abu Hammour

One can import data from Excel ODBC source, but of course it is user's responsibility to ensure that the data are consistent. Each worksheet in the Excel workbook can be accessed as a table (for example, for Sheet1, you should type "select * from [Sheet1$]". The worksheet should have first row containing the column names, and the data rows should follow (the

Hello I am importing data from Excel to R using RODBC and I am ending up with the following data frame: names(AbioRep) [1] "Date" "US0001W Index" "US0002W Index" "US0001M Index" "US0002M Index" "US0003M Index" "US0004M Index" "US0005M Index" "US0006M Index" [10] "US0007M Index"

Hi, I'd like to import a 154x1 vector of a stock monthly returns from a text (or excel spreadsheet) into R. I need to work on this vector by calculating mean, variance and use it for more complex operations. What is the best function to do so? There are no headers, just 154 decimale numbers (so there also negative numbers). Thanks, Claudio -- View this message in context:

Dear all, I would like to import a range of cells (e.g. F10:K234) from an Excel worksheet to R. I have looked for documentation on RODBC and RDCOMClient but I was not able to find enough information to solve my problem and all the examples I have seen were dealing with an entire worksheet, not a range of cells. Thanks, Jean-Noel Jean-Noel Candau INRA - Unit? de Recherches Foresti?res

Hi, is there any possibility to import excel or lotus 123 (.wk1) files to R without using Excel to export as ASCII itself? Any external converter for unix will also do the job, but i do not know about one. Thanks chris -- Christoph M. Friedrich | mailto:friedrich at computer.org University of Witten/Herdecke | http://www.tussy.uni-wh.de/~chris Institut fuer Angewandte Biotechnik und

Hello! I am trying import data into R and im running into a snag. GOAL: Import a 4 column, 8,000 row table into R including headers. WHAT I'VE ATTEMPTED: Original data was in Excel format. Converted data to both a .txt and .csv (to see which worked better) Imported data into R via commands as object "demand" (see below) Please excuse the long file path.