search for: sheets

...low 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 a numeric value from a text cell There are 6 sheets in that file. 5 of them are read into a dataframe without problem. For the 6th one(the one I actually need) I get this error message. There is obviously something in the format of the sheet wrong. Has anyone an idea whats going wrong and what I have to change in the sheet? Thanks in advance, Chri...

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

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

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

...ku.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. The packages/functions that i have checked, cannot accommodate a title that is to be written on the sheet, along with the actual dataframe of interest. I can do something similar to what i need, but withou...

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

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

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]

...scriptions/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 range1 <- comGetProperty(sheet,"Range","A1","A20") #Read out this range from Excel val1 <- as.doub...

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

...sage 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 print on NT :) Well, as I still don't r...

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

...ask. 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 with the merge function) but I would also like to copy the body condition data ahead and behind 15 days (or less if the individual was recorded fewer than 15 days in either direction) from the date it was recorded (this is where I'm stuck). Thank you very...

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