similar to: Reading .xlsx files with python?

I'm getting tired of converting spreadsheets that someone else updates to csv so my perl scripts can push the data into a mysql database. Is there a better way? I haven't had much luck with perl-Spreadsheet-ParseExcel (and find it odd that yum prefers the .32 version from epel over .57 from rpmforge anyway). Is the current CPAN version better? Or the equivalent java tools? Or

Hi, I tried to read a (small) xlsx file by "readWorksheetFromFile" function of "XLConnect" package and "read.xlsx" function in "xlsx" package, but I got this error message: Error: OutOfMemoryError (Java): Java heap space I tried to follow the solution on the web

Hi, I am using this script to read a xlsx file to a data frame: library(xlsx) File <- file.path("d:", "car ", "car95-99.xlsx") B_car <- read.xlsx(File, "raw_data") Car2x <- data.frame(month = B_car$Date,Ch = B_car$Ch.des, lat=B_car$Latitude) The last row in the data.frame is always NA, how can I remove it? Thx. -- View this message in

Hi, I keep getting the below error regarding rJava which is required by package xlsx (I have used it in the past to directly import data from Excel 2010). I was on R version 2.15.0 when I was getting this error this morning. So I upgraded to 2.15.1 but still the same problem. I tried unstalling and reinstalling xlsx and even rJava directly from the source as indicated here:

Hi! I'm manipulating XLSX data using RODBC, however a limitation which appears to be driver based is that you can't clear or drop sheets from the XLSX files, as per the following example: > library(RODBC) > xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx; ReadOnly=False") >

Hello, How can I read a xlsx file using xlsx package? Thanks Albert [[alternative HTML version deleted]]

Hi Adrian, dat=data.frame(matrix(0,3,3)) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet1",append=F) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=F) The above code works and creates new worksheets. But if I want to append to an existing worksheet I seem to get an error.

Hello, I have a number of Excel .xlsx files that aren't indexed properly. To illustrate, I have a file called "this is a test.xlsx". It consists of four cells: | this | | is | | a | | test | It gets indexed but I am unable to search for it. I was able to determine the index number and use delve to see the term list: #delve users -r 16496 Term List for record #16496:

I have spent hours on R in Windows 7. Just installed 2 days ago so the R package should be current. Currently I am using the RGui (64-bit) for Windows. I can not read an Excel file into R from my computer. Have hours on this. Completely crazy!! I have the XLConnect package loaded. I think it is loaded because when I enter: > loadedNamespaces() [1] "base"

Dear R users, Im trying to load *"xlsx"* package which depends on *"xlsxjars"* and * "rJava"* packages. All the 3 packages (zipped files) are installed successfully in windows. I have added "C:\Program Files\Java\jre1.6.0_03\bin\client" to the PATH variable to get rJava working. However, the following error message results after inputting

Dear r helpers; I'm interested in reading from and writing to large .xlsx files fairly regularly. (Why, the naysayers may ask - and the answer is basically colleagues and clients who prefer that format). I've tried out the XLConnect and xlsx libraries, but the java implementation they use just takes too much RAM for the files I'm working with. gdata leverages perl and works really

Dear all, How can I read .xlsx files in R Regards Nico [[alternative HTML version deleted]]

Good morning , i want to read in a file with the xlsx package... the documentation says, that i could define the desired destination with an absolute path. the argument 'file' in the function-call should be: quote : "file->the absolute path to the file which the data are to be read from" (http://cran.r-project.org/web/packages/xlsx/xlsx.pdf ; pagina 14) But it doesn?t work.

I think remember this error from trying to write an Excel file that already existed. If this file already exists, try to delete it and see, if this solves the issue. Besides that you're writing that you are "Using write.xlsx to extract data from an Excel file", write.xlsx() is to write an Excel file, not to read from it. Should be read.xlsx() then iirc. ? ? Gesendet:?Freitag, 15.

Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to Excel sheets. Since recently we get the following error, when trying to write the data frames to the excel sheets: Error in ls(envir = envir, all.names = private) : invalid 'envir' argument We figured out that

HI, I was trying to install xlsx package for reading in Excel 2007 files. The installation went smoothly. But when I tried to load the library, I got the following error message: > library(xlsx) Loading required package: xlsxjars Loading required package: rJava Error : .onLoad failed in loadNamespace() for 'xlsxjars', details: call: .jinit() error: cannot obtain

I am trying to read an xlsx spreadsheet (1506 rows, 501columns) all populated but getting the following error: Please advise as to how to get around this issue. > res <- read.xlsx("c:\\BSE_v2.xlsx",1) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: Java heap space Here is the session info:

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,

Dear list, I'm running windows xp with R 2.12.0. I'm trying to load a excel spreadsheet into R using the xlsx package. I posted my code below with the error I get. > res <- read.xlsx("Copy of test_excel_input_data.xlsx", 6) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.IllegalStateException: Cannot get

Hi, Could anyone help me with this error? I have no idea what that is about... > file <- system.file("DADOSCASUMCCORMICK.xlsx", package = "xlsx") ­> data <- read.xlsx(file, 1) Error in .jnew("java/io/FileInputStream", file) : java.io.FileNotFoundException: (No such file or directory) Thanks! -- Regards, || ------ || Sergio Henrique Bento de Mira