search for: sheeted

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

Dear R experts, I am trying to import some data from some Excle files into R. My Excle file contains about 50 sheets. One solution I can think about is to convert my Excle file into csv file first and then load data into R using 'read.csv'. But it seems to me that 'read.csv' only supports reading one sheet (or 'one file') each time, so that seems I have to create 50 csv

Dear useRs, i want to open an excel file having 59 sheets in r and GOD knows the number of command i tried. unfortunately none worked, obviously error will be on my part. All the sheets contain 1 kind of data and the data starts from A12:M12 (which contains the header of the data), the line immediately under the header is blank. The number of columns of data in each sheet are same while the

Suppose I want the output as "Trial and a sheet" without quotes x=c("a", "b", "c") print("Trial and x[1] sheet") Getting "Trial and x[1] sheet" Can anyone help? Notice: The information contained in this electronic mail message is intended only for the use of the designated recipient. This message is privileged and confidential. and the

R-helpers I have 120 small Excel sheets to read and I am using library(xlsReadWrite): one example below. I had hoped to read sheets by looping over a list of numbers in their name (eg Book1.xls, Book2.xls, etc). I thought I had seen examples which used eval-parse-paste in this way. However, I have not been able to get it to work.. 1. is this a feasible approach? 2. if not

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'm trying to read several Excel sheets from an Excel file into a list. I'm using read.xls from package 'gdata'. I would like to know how I can check the number of sheets before the loop (in the example below) so that I could adjust the loop counter? Any suggestions? DF.list <- list() for (i in 1:4) { DF.list[[i]] <- read.xls("sample_file.xls", sheet=i,

Hello R-users, Checking the archives, I recently came across this topic: "export tables to Excel files" (http://r.789695.n4.nabble.com/export-tables-to-Excel-files-td1565679.html#a1565679), and the following interesting references have been proposed: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows

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

HI, I have large dataset of many countries. I have written the program to run through each country to generate one output for each country. I want to put the output like this: one sheet has output for one country. How do I achieve it by r. I have tried this: library(xlsx) write.xlsx(nnn, "vn.xlsx", sheetName="Sheet1") [1] but when I change sheetName="Sheet2"

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

I may have asked this before, but either I didn't, or I've inadvertently discarded the message containing the answer, so pardon please if this is a repeat. Wil EZStream ever support cue sheets--a companion file containing metadata information normally inserted into the stream from that contained in the multimedia file itself? More play-out software is including the ability to produce

At the end of a printerjob in my HP-DJ895Cxi and HP-1100A in my samba-server (SuSE Linux 8.1) an extra -blank- sheet is comming out of the printers. >From the server if printing direct there's no extra paper sheet. I know the problem has been on the list before, and can also see how to solve it, but there's a problem. From default the SuSE 8.1 is installed with cups, and I wanted to

I'm trying ot get Windows 2K off line folders to work but it fails when writing a file back to the Samba share reporting that access is denied on the share. But I can copy and replace the file manually without a proplem. Running Samba 2.2.7-security-rollup-fix on Redhat 8 (upto date) Samba Logfile for Machine account is below. Any ideas? Thanks Nick Gale [2003/11/20 09:18:04, 3]

Hi list, I just installed the rcom package and tried to read/give out some values from/to Excel. Altogether it works great... but nevertheless I don't know how the syntax works or in other words: "Which command needs which parameters?" Is there somwhere a manual about this package with good examples? I've read the Package description... but there are not really good

Dear Listers: I have a couple of data frames to report and each corresponds to different condtions, e.g. conditions=c(10, 15, 20, 25). In this examples, four data frames need to be exported in a "pretty" report. I knew Perl has some module for exporting data to Excel and after googling, I found R does not. So I am wondering if there is a package in R for generating good reports. I

--oP8mQFO4PT Content-Type: text/plain; charset=us-ascii Content-Description: message body text Content-Transfer-Encoding: 7bit GNU a2ps is a fairly versatile text-to-anything processor. It is useful for typsetting source code from a wide variety of programming languages. As R (ie S) wasn't supported yet, I quickly cobbled a style sheet for the S language together. Stylesheets are

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") >

Dear List, I am having trouble with a tricky merging task. I have one data sheet that has dates (continuous) that radio collared individuals were monitored via telemetry. I have a different sheet containing data from instances where individuals were recaptured and associated body condition data was recorded (sheet 2). I would like to merge the two sheets by individual and date (I can do this

Hola, Pensé que esto iba a ser trivial en R, pero me estoy encontrado muchos con mi problema en internet, y que las soluciones ofrecidas no terminan de funcionar. Estoy intentando leer un fichero .xls en ubuntu con los siguientes paquetes y nada: require(RODBC) conn = odbcConnectExcel("madrid.xls") # open a connection to the Excel file sqlTables(conn)$TABLE_NAME # show all sheets df =