search for: loadworkbook

...[11] "Oil Dly YTD1204 v01.xlsx" "R OG SBCD 1205v01 sCt.lnk" [13] "R setwd to C Prog R sCt OtDt.lnk" So apparently "Oil Dly YTD1204 v01.xlsx" exists in my working directory. SO WHY DOES THE FOLLOWING BEHAVE THE WAY IT DOES? > OlPrcFl <- loadWorkbook(“Oil Dly YTD1204 v01.xlsx”, create = FALSE) Error: unexpected input in "OlPrcFl <- loadWorkbook(“" I can read an xlsx file in when I do: > OlPrcFl <- loadWorkbook(file.choose()) That is not a real, long-term solution. Have same problem installing packages -- Can't g...

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

...33,433,2005,2005,2005,2005, 2005,2005,3939,3939,3939,3939,3939,3939),nrow=18, ncol=3,byrow=FALSE,dimnames=list(c(1,2,3,4,5,6,7,8,9, 10,11,12,13,14,15,16,17,18),c("date","value","code")))) dados2 <- split(dados, dados$code) dados2 library(XLConnect) wb <- loadWorkbook("Teste.xlsx", create = TRUE) createSheet(wb, name = "Teste1") writeWorksheet(wb, dados2, sheet = "Teste1") saveWorkbook(wb) With this code I only get the "433" series. How could I fix my code? How could I include the other series? Many thanks in advance, He...

Hi experts, I want to read data from an excel data like this: for the fifth column, from first row until 140 but only 1,3,5,7,.....139 (only 70 values), How can I do it in R? thanks [[alternative HTML version deleted]]

...seindia.com/content/fo/fii_stats_12-Oct-2012.xls> I tried this --------------------------------------------------------------- library(XLConnect) url = "http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls" local.xls.file = tempfile() download.file(url, local.xls.file) wb = loadWorkbook(local.xls.file, create=F) data = readWorksheet(wb, sheet=1) View(data) --------------------------------------------------------------- no results ... kindly help me thanks veepsirtt -- View this message in context: http://r.789695.n4.nabble.com/Download-a-file-from-url-tp4642985p4646215.html Se...

..., I would like to convert some characters to numeric. However, my code doesn?t work. When I write data to worksheets in an Excel file, some numbers in the cells are stored as text (instead of numeric). Here is my code (the Excel file is attached): rm(list=ls(all=TRUE)) library(XLConnect) tab <- loadWorkbook("C:/Users/Downloads/File.xlsx", create = TRUE) set <- readWorksheet(tab, sheet = "settings") setNum <- readWorksheet(tab, sheet = "settings", colTypes="numeric") index <- which((!is.na(setNum)), arr.ind=TRUE) if(length(index)!=0){ set[index] <-...

...t tell whether the methods cover what you need though. B. On Apr 17, 2016, at 5:36 PM, Val <valkremk at gmail.com> wrote: > Thank you very much Boris. > Worked fine. My aim is to read the last sheet and the sheet preceding to it > > What I did is > L = length(getSheets(loadWorkbook("las.xlsx")) > > K1 =read.xlsx("las.xlsx", sheetIndex = L) > K2 =read.xlsx("las.xlsx", sheetIndex = L-1) > > Is it possible to in one step instead of reading the file three times? > > > Val > > > > > > On Sun, Apr 17,...

...engo un problema al intentar cargar datos de Excel con el r commander con los comandos datos->importar conjunto de datos->desde un archivo de Excel Tengo instalada la última versión de r la 3.0.1 y el mensaje de error que me sale es el siguiente: ERROR: no se pudo encontrar la función "loadWorkbook" Puede ser que necesite cargar algún paquete extra. Gracias! Un saludo. -- Heribert Valero Lapaz [[alternative HTML version deleted]]

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

...adrid.xls') df = read.xls (xlsfile) df = read.xls (xlsfile, sheet = 1, header = TRUE) df = read.xls ("madrid.xls", sheet = 1, header = TRUE) df = read.xls ("madrid.xls") require(xlsx) read.xlsx("madrid.xls", sheetName = "Sheet1") library(XLConnect) wk = loadWorkbook("madrid.xls") df = readWorksheet(wk, sheet="Sheet1") -- también he probado directamente read.table ya que el fichero es tipo xml por dentro: df = read.table("madrid.xls", header = TRUE) -- ejemplo del fichero: $ head -c 500 madrid.xls <table border="1"...

...is attached): Nope. No file was attached in what was circulated. The list-server scrubs potentially malicious files (including zip, csv, or xls files). You could send a "csv" file with extension of ".txt". > > rm(list=ls(all=TRUE)) > library(XLConnect) > tab <- loadWorkbook("C:/Users/Downloads/File.xlsx", create = TRUE) > set <- readWorksheet(tab, sheet = "settings") > setNum <- readWorksheet(tab, sheet = "settings", colTypes="numeric") Presumably you could also send the results of dput(setNum) .. either as a .tx...

Buenos días a todos! Estoy trabajando con una base de datos que directamente he descargado de internet y después de prepararla un poco necesito exportarla a Excel he intentando con las dos opciones que mencionaré al final pero ninguna funciona, de qué otra manera puedo exportar esos datos a Excel... muchas gracias por su ayuda y pronta respuesta! 1) library(xlsx) library(rJava)

I have probably an old question. I have R.3.0.1 installed in 64 bit windows 7. The odbcConnectExcel in RODBC library does not work. Tried odbcConnectExcel2007 still does not work. Any ideas. Thanks Melissa<-sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),sqtable = "Sheet3", + na.strings = "NA", as.is = TRUE) Error in

...> > >> Yo utilizo este script, done 'DataFrame' es el df que quieres guardar: > >> > >> library(XLConnect) > >> > >> fileXls <- "newFile.xlsx" > >> unlink(fileXls, recursive = FALSE, force = FALSE) > >> exc <- loadWorkbook(fileXls, create = TRUE) > >> createSheet(exc,'Data') > >> saveWorkbook(exc) > >> writeWorksheet(exc, DataFrame, sheet = "Data", startRow = 1, startCol = > 1) > >> saveWorkbook(exc) > >> > >> Saludos, > >> > >&...

...e is attached): Nope. No file was attached in what was circulated. The list-server scrubs potentially malicious files (including zip, csv, or xls files). You could send a "csv" file with extension of ".txt". > > rm(list=ls(all=TRUE)) > library(XLConnect) > tab <- loadWorkbook("C:/Users/Downloads/File.xlsx", create = TRUE) > set <- readWorksheet(tab, sheet = "settings") > setNum <- readWorksheet(tab, sheet = "settings", colTypes="numeric") Presumably you could also send the results of dput(setNum) .. either as a .txt...

...= 1, header = TRUE) >> df = read.xls ("madrid.xls", sheet = 1, header = TRUE) >> df = read.xls ("madrid.xls") >> >> require(xlsx) >> read.xlsx("madrid.xls", sheetName = "Sheet1") >> >> library(XLConnect) >> wk = loadWorkbook("madrid.xls") >> df = readWorksheet(wk, sheet="Sheet1") >> >> -- >> >> también he probado directamente read.table ya que el fichero es tipo xml >> por dentro: >> df = read.table("madrid.xls", header = TRUE) >> >> &g...

Hola amigos, buenos días Esto sigue avanzando. Estoy ahora tratando de establecer la conectividad de R con Excel y he seguido dos viídeos en YouTube de una profesora llamada Bebilda que se explica muy bien. Con ambos tengo el mismo problema así que planteo uno de ellos, éste es: https://youtu.be/_pSJQO_9I4k?list=PL7DA3FDA21A1A6310 Pero os lo explico brevemente: Cargo el paquete RODBC >

...t;> df = read.xls ("madrid.xls") >>>>>> >>>>>> require(xlsx) >>>>>> read.xlsx("madrid.xls", sheetName = "Sheet1") >>>>>> >>>>>> library(XLConnect) >>>>>> wk = loadWorkbook("madrid.xls") >>>>>> df = readWorksheet(wk, sheet="Sheet1") >>>>>> >>>>>> -- >>>>>> >>>>>> también he probado directamente read.table ya que el fichero es tipo >>>>>> xml...

...the column name? If this is possible one can then also create formulae from R that will just work when opened in Excel without having to figure out the indices in Excel I have figured out how to do that individually for each column but would lie to automate the process library(XLConnect) wb <- loadWorkbook("Testdata.xlsx", create = TRUE) # create a workbook testdata=expand.grid(letters[1:10], 1:10) # create some data createSheet(wb,"testdata") # create sheet writeWorksheet(wb,testdata,sheet="testdata") # write data to sheet # Create named regions named the column n...

Hi all I have about 10 folders in my directory i.e Folder 1 – Folder 10. Each Folder has a single excel file containing data with the following attributes “State”,”lat”,”lon”, “address” i.e State Lat Lon Address Anchorage 45.87576 -12.567 Starbucks, Van dyke road, 33456, USA I would like to write a script in R that