search for: startrow

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

...temp_number1.xlsx", they could not be read smoothly. 1. How can I read the datasheet as numbers? 2. How can I treat the notation "-" as (1) "NA" or (2) zero? Thanks, Miao > temp<-readWorksheetFromFile("130502temp.xlsx", sheet=1, header=FALSE, startRow=2, endRow= 11, startCol=2, endCol=5) > temp Col1 Col2 Col3 Col4 1 647,853 1,413 57,662 27,897 2 491,400 1,365 40,919 20,411 3 38,604 - 5,505 985 4 576 - 20 54 5 80,845 21 10,211 4,494 6 36,428 27 1,007 1,953 7 269,915 587 32,988 12...

Dear friends, I need to fill in (duplicate the whole record) the missing days with the same record values as long as AE is the same value (i.e. "1"), once AE value changes, the process of duplication should proceed with the new AE value till it changes again. e.g. I need to fill in records: day 18-day 44, all the records are carried with the new AE value of "0". At the

...urrently working for project OpenElec on a syslinux menu. We would like to know if it's possible to move the menu position to the middle/bottom instead of the top... Currently we simply use the Vesamenu as it doesn't require much more functionality. I saw a post regarding the option MENU STARTROW, but that doesn't seem to work (anymore?). Any suggestions are welcome. - Martijn

...e), ncol = 1)) simprof.results <- simprof.body(rawdata = rawdata, num.expected = num.expected, num.simulated = num.simulated, method.cluster = method.cluster, method.distance = method.distance, originaldata = rawdata, alpha = alpha, clust.order = hclust.results$merge, startrow = nrow(hclust.results$merge), pMatrix = pMatrix, const = const, silent = silent, increment = increment) results <- list() results[["numgroups"]] <- length(simprof.results$samples) results[["pval"]] <- simprof.results$pval results[["hclust&qu...

Hallo all, I`ve read a lot of things in this forum about an Excel export via R. It is no problem to export my data frames via write.table or write.xls (xls or csv), but some things are not very convenient for me: I always have to adjust the column with to see all the numbers or the text and there is no frame between the cells. And I missing the possibility to make some headers bold or coloured.

...r2",formula=paste("testdata!",addres2,sep="")) createSheet(wb,"results") # a place to test if the named regions can be used within excel ave="=AVERAGE(Var2)" som="=Sum(Var2)" writeWorksheet(wb, data.frame(ave), sheet = "results", startRow = 2, startCol = 2) writeWorksheet(wb, data.frame(som), sheet = "results", startRow = 4, startCol = 2) saveWorkbook(wb) What I need is: 1. a function to repeat this process of naming the regions over 169 columns, and 2. that the excel formulas in sheet "results" really work. (...

...ting various parts, and I cannot seem to get the nested loop to work as I want it to. I would be very grateful for any suggestions. Below is a brief version of my code: #Code start library(zoo) seed.set(1) Pmat<-matrix(rnorm(1000), nrow=100, ncol=100) maxcol<-ncol(Pmat) maxrow<-nrow(Pmat) startrow<-10 period<-10 wind<-2 #roll window subdiv<-period/wind rollstart<-11 #start roll at period+1 #converting Pmat into ts for rollapply() to work... PmatTS<-ts(Pmat) Preg<-matrix(NA,ncol=maxcol,nrow=2*maxrow) PmatWt<-matrix(NA, nrow=subdi...

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)

..."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, > >> > >> Javier > >> > >> 2016-07-26 12:52 GMT+02:00 Isidro Hidalgo Arellano <ihidalgo en jccm.es>: > >> > >>> Te recomiendo el paquete "...

Otra opción es importar directamente los datos que necesites usando XLConnect (sin llevarlos a CSV). Ese paquete permite hacer cosas muy potentes desde el propio fichero de Excel. https://cran.r-project.org/web/packages/XLConnect/index.html Recomiendo, encarecidamente, la lectura de sus dos vignettes. Un Saludo, -- Miguel Ángel Rodríguez Muíños Dirección Xeral de Saúde Pública Consellería de

...sage I don?t know how to resolve it. > Thanks for your help in advance. > Kind regards, > Amir > > write.table(result, "result.csv", quote=F, row.names = T, sep =",") >> writeWorksheetToFile(output.file, data = result, sheet = "AllSteps", > + startRow = 1, startCol = 1) > Error: IllegalArgumentException (Java): File extension "csv" not supported! Only *.xls and *.xlsx are allowed! > > > --- On Wed, 22/8/12, Rui Barradas <ruipbarradas at sapo.pt> wrote: > > > From: Rui Barradas <ruipbarradas at sapo.pt>...

Hi ! The default start position of the menu box for is the first row of the screen. I'm using the background image option and want to have the menu on the middle of the screen. With the attached patch it's possible to use the new config switch "MENU STARTROW" to define the top row for the menu box. Maybe this could be implemented in on of the next versions. I think it's a useful thing! Would be great to get some feedback ;) Best regards Erik Lehmann -------------- next part -------------- A non-text attachment was scrubbed... Name: start...

hi list sorry my english is not perfect :( im using pxeboot with vesamenu.c32 in default file i load a backgroundpic (*.jpg) but the vesamenu border overlaps pieces of my background picture ^^ my question is an all coders from syslinux can you make a MENU command like topmargin MENU LABEL xxxx MENU WITH xx MENU MARGIN xx (from left) .... MENU TOPMARGIN xx (from top) <- new to

..., I like that R CMD check will actually make sure that all the parameters are documented etc. However, there are still some overflows for methods with many parameters, my worst offender currently being \S4method{readWorksheet}{workbook,numeric,numeric,numeric,numeric,numeric,logical}(object,sheet,startRow,startCol,endRow,endCol,header) where just the type signature alone is too long. I tried various ways of introducing line breaks in the type signature, but they all seem to fail (\cr, \, raw line breaks, double raw line breaks), is there anything that can be done about it? Another PDF ugliness iss...

...ting of "AAA", "AAa", "ABa", "ccc", "Ded", etc, one entry on each line. The listing is likely to change over time and the script will run at least once a day. My initial planning was to do something like f1 <- read.xlsx("LIST.xlsx",1, startRow=2, colNames = F) f1$X2 <- paste('d1$X5 <-f1("',f1$X1,'")', sep='') f1$X3 <- paste('d1$X6 <-f2("',f1$X1,'")', sep='') and I obtain something like X1 X2 X3 1 AAA d1$X5 <-f1("AAA&qu...

I have a data frame consisting of three columns(name of compund,ppm and frequency).Name contains string values .ppm and frequency contains numeric values with decimal points upto four digits. I have an excel sheet which is like a library.The first column contains the name of compounds and remaining column contains the ppm values of the compound which satisfy certain rules.The number of ppm values

Hi, I have two questions on the function "readNamedRegionFromFile" in XLConnect pacakge. 1. In the documentation, # multiregion xlsx file from demoFiles subfolder of package XLConnect demoExcelFile <- system.file("demoFiles/multiregion.xlsx", package = "XLConnect") # Load a single named region into a single data.frame. df

Dear R Users, I have to read data from many excel spreadsheets, all which have some frustrating formatting (lots of titles, headers, etc.). I am trying to work directly from source data and the number of the spreadsheets I would have to go through make reformatting one by one a pain. I have found lots of ways to read excel files, but my question is whether there is a way to only read

I have many xls grade report sheets with the same format XXX High School Grade Report Confidential Yes Math English Science John 90 85 90 Mary 75 88 93 …… Since the reports are prepared on a regular basis, I have many reports with identical format. Without the title “XXX High School Grade Report Confidential Yes”, I can just change the xls to csv and read them via read.csv. How