similar to: exportData(foo,"foo.xls","EXCEL") for R ?

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

exportData(MU.Cost,paste("C:/RAUDSL/S",as.character(MU.Cost$Run.Id[1])," .",as.character(MU.Cost$MU.Id[1]),".MU.PRICE.OUTPUT.txt",sep=""),append = FALSE,type="ASCII",quote=FALSE) [[alternative HTML version deleted]]

Hello, This may sound crazy, but I have a large number of Multiplan data files I'm in the process of recuperating, and I'm hoping to avoid having to open them one by one to convert them into a modern, directly usable format. So I was wondering if someone somewhere had encountered this and maybe had a way to read Multiplan files in R, or, at least, a way to read SYLK files directly in R.

Hi, I am having problem with the read.xls function. I am trying to read a .xls file but it's giving me error. > read.xls("XXX.xls") Error parsing file 'XXX.xls'. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file '/tmp/Rtmp5QQjSI/file1665315c.csv' missing! In addition: Warning message: running command

I can currently append an entire worksheet with write.xls, but would also like to be able to append within the same worksheet. Is this possible? It doesn't seem to work if I use append = T Thanks, Mark -- Mark W. Kimpel MD Neuroinformatics Department of Psychiatry Indiana University School of Medicine

I am wanting to read EXCEL files into R. In the past I have saved EXCEL files as csv files without difficulty. Recently, when I have saved the files in this format I am then unable to open them again in EXCEL or though windows (XP). I receive a message stating - SYLK: file format not valid. R will read the file, but I cannot open it in windows. Csv files created and saved in the past (on

Can anyone help me how to read xls file into R. I have tried following library(gdata) xlsfile <- file.path(.path.package('gdata'),'xls','iris.xls') read.xls(xlsfile) I got following error: Converting xls file to csv file... Error in system(cmd, intern = !verbose) : perl not found Error in file.exists(tfn) : invalid 'file' argument Question *1) What is the way

Hi, I encountered a problem of not being able to read in an excel spreadsheet using read.xls() in the xlsReadWrite package. can anyone help? Here is an example code write.xls(matrix(1:9,nrow=3),"ttt.xls") read.xls("ttt.xls") Error in read.xls("ttt.xls") : Unexpected error. Message: Can't find the file "ttt.xls" The "ttt.xls" file was

in order to export a data.frame to sheet.xls i try: write(df,file="file_name.xls") but when i open it a message appears: "impossible to oppen this file. her format is unvalid" knowen that i work with excel_2007 what is the solution ? -- View this message in context: http://www.nabble.com/i-want-to-export-a-data.frame-to-file.xls-tp17326119p17326119.html Sent from the R

I've suddenly started seeing a consistent problem with read.xls. No matter what xls file I try I always get an error message of this type: Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file '/var/folders/cb/vvshkpm90lx_y2n69qlyw4z40000gn/T//RtmpK50r4g/file546a2722.csv' missing! In addition: Warning message: running command

I have attached a file downloaded from database mirWalk. Apparently it is in XLS format (this is the extension of the downloaded file). However, I cannot open it with OpenOffife spreadsheet program and Excel itself cannot separate the columns as it does when a true XLS file is loaded. I tried to read the attached downloaded file through R function "read.xls" and got the following

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:

Hello there, In gdata package, read.xls is to be used for reading excel data (from windows). The following is my code:('C:/session/sampledata.xls' is where the file is stored) data1<-read.xls('C:/session/sampledata.xls',sheet=1) and I got the following error message: Error in system(cmd, intern = !verbose) : perl not found Could you please tell me what I have done wrong and

Using gdata on windows and im having trouble to retrieve an excel file from a folder on my computer. This is my dummy: R > download.file("http://people.su.se/~lundh/data/cpi_kpix.rda", + "cpi_kpix.rda") R > URL <- "http://people.su.se/" R > PATH <- "~lundh/data/" R > FILE <- "cpi_kpix.rda" R >

Hi all, I read data from *.xls file and i did some caliculations on that data and now i have to create a column in the same .xls file and i have to insert the data in to the consicutive rows related to the previous data i tried it with *write.xls() *but the thing is it deleted all the columns previously presented in that file and it created a column and inserted data can any one suggest what to do

I am using read.xls command from the gdata package. I get the following error when I try to read a work sheet from an excel sheet. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file 'C:\Tmp\RtmpYvLnAu\file7f06650f.csv' missing! In addition: Warning message: running command '"C:\Apps\Perl\bin\perl.exe" "C:/Program

Dear List, I am trying to solve a problem: I have approximately 100 Excel spreadsheets each with approximately 4 sheet each that I would like to download and import in R for analysis. Unfortunately i realized (i also sent an email to the author or xlsReadWrite() ) that the read.xls() doesn't allow to import the file in R from internet. Here it is the the code:

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, i want to import data from .ods and .xls files in R on a linux system. Seems it was a faq in the past, but i found only solutions for Windows. Is there a handy solution for linux? The best would be something like mytab <-read.ods(...) Any hints? Thanks a lot for reading so far, -- Jonas Stein <news at jonasstein.de>

library(xlsReadWrite) mydata<-read.xls("file path", header=TRUE) however if I change xls to csv it works just fine. Any ideas what I'm doing wrong? I have have also using the package gdata with the exact same error. Below is the error that pops up. Error in findPerl(verbose = verbose) : perl executable not found. Use perl= argument to specify the correct path. Error in