search for: workbook

Displaying 20 results from an estimated 128 matches for "workbook".

2011 Jun 14
3
Read in from multiple Excel wksheets
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...
2009 Jul 09
1
R-help Digest, Vol 77, Issue 9
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;...
2013 Jun 18
2
`require': cannot load such file -- nokogiri (LoadError) in rubyXL
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...
2010 Nov 15
2
Cannot switch between excel files
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
2010 Sep 06
2
WriteXLS problem
...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...
2004 Sep 17
0
Announcing Rpad, a web-based workbook-style interface for R
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...
2004 Sep 17
0
Announcing Rpad, a web-based workbook-style interface for R
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...
2009 Jul 08
1
RDCOMClient: how to close Excel process?
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("...
2012 Dec 22
1
Character Variable in X axis scatter plot
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...
2010 Feb 03
1
odbcConnectExcel2007 connection error
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...
2015 Sep 17
2
Fwd: Creación fichero excel con loadWorkbook
...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...
2007 Feb 08
5
xlsReadWrite Pro and embedding objects and files in Excel worksheets
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...
2008 Nov 07
0
unable to add a new workbook with rcom
[This email is either empty or too large to be displayed at this time]
2007 Dec 14
4
rcom close Excel problem
...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,&...
2007 Oct 16
9
Import from excel 2007
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]]
2018 May 13
0
Dataverse (reading files with .tab and .7z suffixes)
...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...
2012 Oct 30
1
rJava Out of Memory Error
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...
2013 Mar 05
0
Meaning of error message when exporting to MS Excel
...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...
2006 Jun 29
1
RCOM Package
...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...
2009 Jun 15
2
[OT] VBA to save excel as csv
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/