search for: sheet

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

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 files and do ...

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

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

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

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 the error occurs when the excel sheet is open while R tries to write to it. But now, cl...

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]] &l...

...rt 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 http://www.r-bloggers.com/export-data-frames-to-multi-worksheet-excel-file-2/ but my problem is somehow a small extension to what has been discussed, and although i have a solution, i seek something more elegant. I want to export multiple dataframes (on multiple sheets), but i also want each of them to have its own title that is to be written also in Excel....

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

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" to add up another country into one sheet. it autimatically deleted which I have down on [1...

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 su...

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 these files, so I'm thinking, hoping, that the streamer companion to the Icecast stream server will...

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 install it with...

...18:04, 3] smbd/trans2.c:call_trans2findfirst(898) call_trans2findfirst: dirtype = 22, maxentries = 1366, close_after_first=1, close_if_end = 1 requires_resume_key = 1 level = 260, max_data_bytes = 16384 [2003/11/20 09:18:04, 3] lib/util.c:unix_clean_name(387) unix_clean_name [/DBA Reports/Stock Sheet (nickgale v1).xls] [2003/11/20 09:18:04, 3] lib/util.c:unix_clean_name(387) unix_clean_name [DBA Reports/Stock Sheet (nickgale v1).xls] [2003/11/20 09:18:04, 3] lib/util.c:unix_clean_name(387) unix_clean_name [DBA Reports] [2003/11/20 09:18:04, 3] smbd/dir.c:dptr_create(488) creating new dirp...

...mwhere a manual about this package with good examples? I've read the Package description... but there are not really good descriptions/examples. I know the following parameters/commands: #Connect to the active Workbook excel <- comGetObject("Excel.Application") #Set the active sheet sheet <- comGetProperty(excel,"ActiveSheet") #Set a specific sheet sheet <- comGetProperty(excel,"Worksheets","WorksheetXY") #Create a new Worksheet comInvoke(comGetProperty(excel,"Worksheets"),"Add") #Define a range in a defined sheet rang...

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

...harset=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 documented in the texinfo docs for a2ps, and examples can be found in /usr/share/a2ps/sheets (on Debian at least, others distros or unices probably have similar locations). IIRC a2ps exists for NT but might require Cygwin. I typeset on Linux and only pri...

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") > sqlClear(xlsx,"newsheet2",errors=...

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 da...

...lema 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 = sqlFetch(conn, "Sheet1") # read a sheet df = sqlQuery(conn, "select * from [Sheet1 $]") # read a sheet (alternative SQL sintax) close(conn) # close the connection to the file require(gdata) xlsfile <- file.path(path.package('gdata'),'xls','madrid.xl...