search for: workbooks

I?ve got an Excel workbook with about 30 worksheets. Each worksheet has 10000 rows of data over 30 columns. I?d like to read the data from each worksheet into a dataframe or matrix in R for processing. Normally, I use read.csv when interacting with Excel but I?d rather manipulate a multisheet workbook directly than set about splitting the original workbook and saving down each part as a csv.

Hi, This may be due to several reasons. That I can think about: 1) Ensure you close *all* possibly open workbooks: nBooks <- xl[["Workbooks"]]$Count(); for (i in seq_len(nBooks)) xl[["Workbooks"]]$item(i)$Close(SaveChanges=FALSE); 2) The excel application reference does not seem to be really released until the garbage collector runs. So this may help: xl$Quit(); xl <- NULL;...

Hi All Getting the below error when running the source code My requirement is : I want read / write the excel sheet ( both xls / xlsx ) from Ruby , if you have any other solution also share with me .. *Source Code :* * * * bash-3.2$ cat rubyXL.rb require ''rubyXL'' workbook = RubyXL::Parser.parse("test.xlsx") workbook = RubyXL::Workbook.new sheet_Name =

I have recently installed MS Office 2007 in Wine 1.2 on Ubuntu 10.04 64-bit I have noticed that I cannot switch between two excel workbooks. I can either work on only one excel at a time or do a lot of jugglery to switch between the two. It will be great if anyone can give me a solution as I need to work on multiple excels most of the time. Thanks Prasad

Hi R users: I don't know if you have had the following problem trying to export to an "xls" format file in a non windows platform. I try to use the following packages: 1. dataframes2xls (version 0.4.4) (with phyton 2.7 and 3.1) 2. WriteXLS (version 1.9.0) (with perl and testPerl working) Even "xlsx" package that take too long and do not finish. The data frame I try to

Rpad is an interactive, web-based analysis system. Rpad pages are interactive workbook-type sheets based on R. Rpad is an analysis package, a web-page designer, and a gui designer all wrapped in one. Rpad pages are run from the browser and connect to R running on the server (the same server that hosts the web pages). Rpad includes the R package "RpadUtils", which adds convenient code

Rpad is an interactive, web-based analysis system. Rpad pages are interactive workbook-type sheets based on R. Rpad is an analysis package, a web-page designer, and a gui designer all wrapped in one. Rpad pages are run from the browser and connect to R running on the server (the same server that hosts the web pages). Rpad includes the R package "RpadUtils", which adds convenient code

...retrieve data from MS Excel workbook. I?m using the code below to count the number of sheets in the workbook and then loop the data from sheets in to a list. ############# R code ################### library(gdata) library(RDCOMClient) xl <- COMCreate("Excel.Application") sh <- xl$Workbooks()$Open(normalizePath("sample_file.xls"))$Sheets()$Count() DF.list <- list() for (i in 1:sh) { DF.list[[i]] <- read.xls("sample_file.xls", sheet=i, stringsAsFactors = FALSE) } ###################################### COMCreate opens Excel process and it can be seen fr...

I am very new to R statistics. Have installed R-2.15.2 ; Rcmdr 1.9-2 ; RStudio 0.97.237 on Debian Squeeze and also windows7 I can Import from Excel File OK .Workbook <- loadWorkbook("/media/4C90-B739/Oct13-Dec21Bsl.xls") JJData <- readWorksheet(.Workbook, "Oct13-Dec21Bsl") remove(.Workbook) have a data frame with following. DATEEVENT

Hi all, Apologies if I violate any posting etiquette - this is my first submission to the R mailing list. I regularly use 'odbcConnectExcel2007' (from package 'RODBC') to read data from named ranges in excel workbooks into R. I recently received the following error message when attempting to set up a connection channel (i.e. ch1 <- odbcConnectExcel2007('path to excel 2007 file.xlsx')): "External table is not in the expected format". The workbook I was attempting to connect to had 15+ sheet...

> > > Hola chic en s, > > sigo intentando crear un archivo de Excel pero no hay manera. Sigo los pasos del documento de ayuda siguiente: > > http://altons.github.io/r/2015/02/13/quick-intro-to-xlconnect/#load > > los pasos que hago son: > > install.packages("XLConnect") > require(XLConnect) > wb <-

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 data, output, and methods. That, in fact, is why I bought the Pro version of xlsReadWritePro. I have been saving graphics as PDF files, then inserting them as object in Excel sheets. What I would like to b...

[This email is either empty or too large to be displayed at this time]

...efuses to die. Thank you very much. S. "You can't kill me, I will not die" Mojo Nixon I also have a problem with saving. It produces a pop-up dialog and does not take my second parameter: x<-comCreateObject("Excel.Application") wb<-comInvoke(comGetProperty(x,"Workbooks"),"Open","G: /MR/Stephen/repo. xls", "0") sh<-comGetProperty(wb,"Worksheets","Market Data") range1 <- comGetProperty(sh,"Range","C10","I11") vals <- comGetProperty(range1,"Value") comInvoke(wb,&q...

Hey Seniors, Really new to R, please has anyone imported a dataset from MS office excel 2007 into R yet? It seem to be giving me hard times which I did not expect as it use to go well with the previous versions. Thanks in advance. arnoldo --------------------------------- [[alternative HTML version deleted]]

Ilio Fornasero writes: > Yet, I am at this point. > > > > > ## 01. Finding the dataverse server and making a search > Sys.setenv("DATAVERSE_SERVER" =3D "dataverse.harvard.edu") > dataverse_search(".Hunger") > > > ## 02. Loading the dataset (in this example, I have chosen the word ".Hunge= > r" to get > # one list and

I'm running XLConnect 0.2-1 that depends on rJava 0.9-3. I am only able to work with 2 workbooks before I get this error... > SppRich = wb["SpeciesRichness"] # This command calls an Excel > spreadsheet Error: OutOfMemoryError (Java): GC overhead limit exceeded I have tried... > rm(list = ls()) ... to clear the workspace, but it doesn't help. I am using RStudio 0....

Hi, I?m attempting to export data (split into multiple files from one large dataset) from R to excel using the excel.link package. The code for export is as follows: for(i in practicesNN){ #Create relevant data for input #Separate out all parts of data ? PracticeName is removed from example data for privacy reasons detailedH<-dataExport2[dataExport1$PracticeName == i &

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

Hi all, This is a little off-topic, but it is on the general topic of getting data in R. I'm looking for a excel macro / vba script that will export all spreadsheets in a directory (with one file per tab) into csv. Does anyone have anything like this? Thanks, Hadley -- http://had.co.nz/