similar to: excel parser (preferably perl)?

I have Excel files containing data that I would like to move to R. They are in the standard form of a one row header followed by rows of data, one record per row EXCEPT that there are a few rows of comments before the header. The number of rows of comments varies. For Excel files of this form without comments I have had success with: require(RODBC) z <-

I need to install VICIDIAL (cause is a free outbound call solution) and vicidial wants the following perl modules: MD5 Digest::MD5 Digest::SHA1 readline Bundle::CPAN DBI (found the rpm perl-DBI) DBD::mysql (found the RPM perl-DBD-Mysql) Net::Telnet Time::HiRes Net::Server OLE::Storage_Lite Spreadsheet::ParseExcel I do not want to taint the installation if an RPM is available on the DVD or in

Hi folks, I have been tormented for some time by Excel's habit of exporting dates to CSV files as mm/dd/yyyy format even if the dates are formatted dd/mm/yyyy in the display. What's worse, if there are dates that are of ambiguous (6/6/2011) and unambiguous (16/6/2011) format in the same column, Excel reformats the unambiguous dates and leaves the ambiguous ones as they were! Yesterday

I've created a Perl script that translates Microsoft Excel (.xls) files into comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel module. Usage ----- perl xls2csv.pl <excel file> [<output file>] [<worksheet number>] Translate the Microsoft Excel spreadsheet file contained in <excel file> into comma separated value format (CSV) and store in

I gather from reading the back-issues of r-help that it should be possible (modulo a number of caveats) to read an excel (yuck!) file into R using RODBC. I have obtained and installed ODBC and the RODBC package, but cannot for the life of me figure out how to go about it. Can anyone give me a simple recipe? I have an excel file on cdrom, say: /mnt/cdrom/melvin.xls I have started R and loaded

When I read excel files using the read.xlsx() command any cells that have formulas in them come up as NA. Is there a way to read just the numeric value of the cell without using the "paste value" command in Excel? I need to read in hundreds of Excel spreadsheets and compile them into one large super spreadsheet automatically. Hence the reason I cannot reformat each sheet manually.

Hi, Does anyone know of a package that will help with generation of spreadsheets? (xls files, not csv) Thanks, Fredrik --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe

Dear all, I am interested in reading Excel spreadsheets (*.xls) directly into R (I am using version 1.1.1 at the moment). I have not had much luck so far. For the time being, I have been converting Excel files to comma delimited files (*.csv) and reading these into R (using commands such as "read.csv"). This works well, but it would be more efficient if I could read the Excel files

Dear Rxperts, Through Windows OS, I created shortcuts (paste as shortcut) to excel spreadsheets ( with "xlsx" as the file extension). I wasn't able to read the shortcuts through R and using "read" functions of "xlsx" package. exf <- "a1.xlsx.lnk" > read.xlsx(exf,1) Error in .jcall("RJavaTools", "Ljava/lang/Object;",

A client of mine has a ton of data stored in Excel spreadsheets. I''m building a web application for her (backed by a real db of course) and want to import all that data. Is there a library available to read data from Excel? Is there an easy way to upload the spreadsheets and then read the data? Thanks, Ken Kousen -- Kenneth A. Kousen, Ph.D. President Kousen IT, Inc.

Dear members of the R Development Team, I am looking for people with a deep understanding of R internals to assist in bridging R to OpenOffice. While R is a state of the art statistical environment, less experienced users often find it difficult to work with R. Therefore, I believe that a bridge between R and a spreadsheet program will make this transition less painful. I sincerely believe

Hi list, By the entire last 2 weeks I was looking for a way to directly import xlsx files to R in a Linux OS (Ubuntu 9.04). I already read the R Import/Export guide, and I know how to use gdata to import xls files and read.table to import .csv. My problem is that all data that I receive is in the xlsx format, and I have to convert all the files to xls. Well, when I was using Windows Vista OS,

Hello, On 16 Okt., 20:02, "AN@S" <anas.marr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > Hello, > > I''m running into a project where a client has large Excel files > (60.000+ records per file) and he needs an application to import them > into a database to use this data for useful operations (reporting, > calculations .. etc). > > I know

Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =

Hans-Peter and other R developers, How are you? Have you made any progess with embedding Url's in Excel? Well, I have been busy thinking of more things for you to do;) My colleagues in the lab are not R literate, and some are barely computer literate, so I give them everything in Excel workbooks. I have gradually evolved a system such that these workbooks have become compendia of my

What is the syntax for this? If you have: vector = c(1,2,3,4), how would you output this to column A of an excel spreadsheet? -- View this message in context: http://r.789695.n4.nabble.com/how-to-you-output-a-vector-to-a-column-in-excel-tp2530470p2530470.html Sent from the R help mailing list archive at Nabble.com.

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

A colleague has a dozen of excel sheets and also expects to get updates regularly. He could open these in M$-Excel and export as *.csv manually, "bring back to Unix" and then read into R. Of course there must be options to start programming this in something like visual basic, but we wouldn't to really want to... We also know that probably Gnumeric could do the job (since the xls

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

Hi List, just to know if the issue is only a problem of mine or if it is a general issue due to the new MS Office pack. I'm using R 2.11.1 32 bits in a Windows 7 x64 with the MS office 2010 x64 installed. I can import .xls files normally (the same way I did with my Excel 2007 32 bits). But the function odbcConnectExcel2007 isn't able to import .xlsx files now that I have the new version of