similar to: Any R packages support conversion from PDF to XLS ?

Frequently I need to convert a .xls to a .csv (for import into R) and I do this by opening the file in excel and saving it as a csv. I would rather do this using WinXP's context menu (right click the xls, choose "convert to csv") but I don't know of a utility that does this. Any ideas? Thanks, Mark

Does anyone have experience with linux tools to parse the text from common non-text file formats for searching? I'm trying to use the kinosearch add-on for twiki which is fine as far as the search goes, but it takes forever to generate the index. It uses xpdf to extract strings from pdf's, antiword for .doc, and since it is perl, the Spreadsheet::ParseExcel module for .xls. Some

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

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

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

My installation is R version 2.4.0 on Mac OS X version 10.4.8 (the latest release in both cases). I've recently had to restore my hard drive after a crash, and fear that this may have screwed up my Perl installation slightly. Whenever I run the read.xls function from library(gtools) I get the following errors: ###################### > file =

Dear R list, I am trying to read in .xls files. I have tried using package 'gdata', I get the following error. > dataset <- read.xls("June.xls") Wide character in print at /Library/Frameworks/R.framework/Versions/2.14/Resources/library/gdata/perl/ xls2csv.pl line 262. Seems like this is a problem coming from Perl? I tried to install package 'xlsReadWrite', it

Jorge was kind enough to point out that I made a mistake in referencing gabor's solution. See below. Thanks Jorge. -------- Begin forwarded message -------- Subject: Re: [R] Writing xls - multiple sheets Date: 3/12/2009 6:03:13 PM From: Jorge Ivan Velez To: markleeds@verizon.net Hi Mark, Yes, he did (as always), but it is not what Ferry needed. Here is Gabor's post:

Hi, I try to use write.xls from dataframes2xls inside a function. The write.xls work normally in console, but inside a function it dont find the object. Look this example: > library(dataframes2xls) > test <- function(x){ + a <- data.frame(A=c(1,2),B=c(10,11)) + write.xls(a,file="a.xls") + } > test() Erro em get(s[i]) : objeto 'a' não encontrado Why the

Dear All, When I use read.xls() in gdata package to read xls files, I noticed an issue and couldn't find any solutions after I serched all previous posts. In the excel file, the number value, for example, is actually 2.3456789 but formatted as 2.3 (Format Cells ---> Decimal places:1). After I use read.xls() to import the excel file, I found that, in R, this number is read as the formatted

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

Hi, i'm using read.xls, and it counts more rows in my Excel than I really have. i've used both: especie26 <- read.xls("especie26cargar.xls") datos26 <- read.xls("especie26cargar.xls", header = TRUE, as.is = FALSE, na.strings = "NA", skip = 0, check.names = TRUE, fill = FALSE, strip.white = FALSE, blank.lines.skip = TRUE) when i

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

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 >

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

Dear list, I used read.xls to read in an excel file, which has both character and numeric columns. Everything seems fine except in the last column, I have this character value "ng/ml". When reading in, read.xls seems to add a space at the end of it, became "ng/ml ". How can I prevent read.xls doing so? Thanks. >read.xls(data, header=T, as.is=T) Jun [[alternative HTML

I am woking on Windows and using read.xls to read Excel.xls file. But it needs to install perl on my machine first, and then give the following until it can work: read.xls(file,sheet=i,perl="E:\\Perl\\bin\\bin\\perl.exe"); I am wondering if there is other way to read Excel.xls file without needing do this? jlm [[alternative HTML version deleted]]

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:

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