search for: workbook

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

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 = workbook.worksheets[0] puts sheet_Name * * * *ERROR* rubyXL.rb /usr/local/Cellar/ruby/2.0.0-p195/lib/ruby/site_ruby/2.0.0/rubygems/core_ext/kernel_require.rb:45:in *`require'': cannot load such f...

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

...ack (most recent call last): File "C:/PROGRA~2/R/R-211~1.1PA/library/dataframes2xls/python/csv2xls.py", line 18, in <module> import pyexcelerator File "C:\PROGRA~2\R\R-211~1.1PA\library\dataframes2xls\python\pyexcelerator \__init__.py", line 12, in <module> from Workbook import Workbook File "C:\PROGRA~2\R\R-211~1.1PA\library\dataframes2xls\python\pyexcelerator \Workbook.py", line 526 boundsheets_len += len(BIFFRecords.BoundSheetRecord(0x00L, sheet.hidden, sheet.name).get()) ^ SyntaxError: in...

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

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

Hi, I?m using R package RDCOMClient (http://www.omegahat.org/RDCOMClient/) to 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("...

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 AdjDateTime TIMESLOT EVENTTYPE KEY0 BSLmmol/L 411...

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

...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 <- loadWorkbook("C:/Users/r2753/Desktop/R/test1.xlsx",create=T) > > y la info de mi ordenador es: > > Tipo de sistema: Windows7, 64Bit > Java (32-Bit) > RGui (32-Bit) > > Cuando entro wb <- la primera vez se queda como pensando, acaba de pensar, pero no aparece nada en la...

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

[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,&...

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

...le format is clear. You need to figure out the 001_AppendixC.tab file format. On first glance it looks to me like a spreadsheet. $ file /tmp/001_AppendixC.tab /tmp/001_AppendixC.tab: Zip archive data, at least v2.0 to extract $ cd /tmp && unzip 001_AppendixC.tab $ head -n2 /tmp/xl/workbook.xml | cut -c 1-75 <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" Once you figure out the format manually, write an R function that figures out the format, and a...

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

...dataExport1$PracticeName == i & dataExport1$RISK_LEVEL == 'Medium',] detailedL<-dataExport2[dataExport1$PracticeName == i & dataExport1$RISK_LEVEL == 'Low',] print(paste(i,"2")) x<-paste(i,".xls",sep="") #Open excel template xl.workbook.open("Template.xls") #Create practice specific file xl.workbook.save(x) #Activate detailed High risk sheet xl.sheet.activate("High Risk detailed") #Update detailed High risk spreadsheet xlrc[a1]<-detailedH #Activate detailed Medium risk sheet xl.sheet.activate...

...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 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,&q...

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/