similar to: Dates and times from Excel

Hi R users, I am using xlsReadWrite to read a particular excel file. In one of the columns I have dates ( say col=5). Now date column is read by default as numeric. So I used dateTimeAs= "isodatetime". This enables reading in the date format. However in the earlier column (say col=1) I have data which however starts from row 10. So to read data from column one I use

Hi, i'm trying to read some data from excel files but it seems that neither xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0). When i open the file in Excel and save it in a new format Excel 97 -2003 everything works fine. Is it possible to use ODBC connection to open old format files, or i guess i will have to open and save every file in Excel in new format, which

Dear all,   I was using older version of R (installed early). I install new version of R (R.2.9.0) but i could not find package "xlsReadWrite" to read Excel file. Is there any alternatives to read Excel file ? I hope it should be. I need help although it is minor querry. Thanks in advance.   Sincerely, Ram Kumar Basnet Wageningen University, The Netherlands   [[alternative HTML

Hello, I have got the following problem: > setwd("C:/temp") > library(xlsReadWrite) > MyData <- read.xls(file="Mappe1.xls", colNames = TRUE,dateTimeAs = "isodatetime") > attach(MyData) > MyData name value times 1 A1 2 2006-05-12 2 A2 3 2006-05-16 3 A3 1 2006-05-12 4 A4 4 2006-05-12 5 A5 2

Hello!!! I have been read a much about as read data from Excel File, but I haven?t found the necesary information to read the data. Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but I don?t know as read the data?? I hope that you could help me. Thank you very much. -- View this message in context:

A naive question: what happened to the xlsReadWrite package? http://cran.r-project.org/web/packages/xlsReadWrite/ It says that it was removed from the CRAN repository. Are there any plans for it be available again? Thanks, Andrew [[alternative HTML version deleted]]

Dear R-experts, It is a quite stupid question but please help me. I am very confuced. I am able to import normal txt ant mat-files to R but unable to import .xls-file I do not understand the online help. Can please anyone send me the corresponding command lines? The .xls-file is attached. In my file we use commas for the decimal format (example: 0,712), changes might be needed. Thanks, Corinna

Dear R users, I've just posted a similar question about Illustrator. This time I would like to export the results of my statistic tables and my dataframes into Excel files. Up to now I've used write.csv(), but I have to resave every file in .xls in Excel. I would like to know if there is a function or package to export directly into *.xls. I have found xlsReadWrite which would be

I'm an R newbie and had a question about the read.xls function. I've heard that this is often not a reliable function to use for importing data. However, I have created numerous xls files which contain information about voter turnout and macroeconomic indicators in India. I'm writing a paper on the relationship between economic growth and voter turnout. This is the command I use:

Good morning to everybody, I have a problem : how can I import excel files in R??? thank you very much Dr.sa. Erika Frigo Università degli Studi di Milano Facoltà di Medicina Veterinaria Dipartimento di Scienze e Tecnologie Veterinarie per la Sicurezza Alimentare (VSA) Via Grasselli, 7 20137 Milano Tel. 02/50318515 Fax 02/50318501 [[alternative HTML version deleted]]

I'd like to be able to read multiple sheets from an excel workbook and use the sheet name to name the resulting dataframe using RODBC. at the moment i've figured out how to do it the long way (see below) but feel sure that there is a speedier & possibly automatic way to do it in R. i've tried to run a loop using sqlTables but it seemed to break the connection. unless i've

The (*windows only*) xlsReadWrite package has been updated and the new version is available on CRAN. xlsReadWrite natively reads and writes Excel files (v97 - 2003). o Changes from v1.1.1 to v1.3.3 (versions between never really published) - ROWNAMES-support also for matrices (not only for data.frame) - explicit rowNames argument in interface. (stimulated by email Adrian Dusa) -

Dear all, i use the following package/syntax to export data to excel: library(xlsReadWrite) write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = FALSE ) Everything is fine, but the format of the export is not the best. For example, I every time have to adjust the column width. Furthermore there is no possibility to highlight some cell or make them colourful. I create a lot

I am happy to announce that a new version of xlsReadWritePro is available. xlsReadWritePro natively reads and writes Excel files (v97 - 2003) on Windows. The pro version is more powerful than the free version but, beeing a small company, we ask you to support our development and maintenance effort. The following capabilities have been added (compared to xlsReadWrite): ? in-memory objects

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

R I am taking an excel dataset and reading it into R using read.table. (actually I am dumping the data into a .txt file first and then reading data in to R). Here is snippet: > head(data); Date Price Open.Int. Comm.Long Comm.Short net.comm 1 15-Jan-86 673.25 175645 65910 28425 37485 2 31-Jan-86 677.00 167350 54060 27120 26940 3 14-Feb-86 680.25

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

Dear R Professionals, I am currently an intern at the University of Rhode Island and I need to know how to export data from R into an Excel file. As it is my understanding, xlsReadWrite is not available for mac. Is there another package available for mac users to be able to perform this function. Sincerely, Maureen J Hayden University of Rhode Island Class of 2015 Marine Biology Major

Hi useRs, I would like to know what R users are employing to get their images/plots created in R, into Excel sheets. I am aware of the various packages (xlsReadWrite, RODBC) to get data frames into R, but I would like to copy images too. Thank you for any help in solving this problem. Regards, Harsh Singhal

Hi all, I tried to read data from Excel spread sheet with using read.csv(file.choose()) and read.delim(file.choose()) but its showing " *ÐÏ.à.*." and also i tried with read.table(file.choose()) then its showing " * V1 1 ÐÏ\021ࡱ* " can any one suggest how to read data from Excel Spread sheet