search for: startcol

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

...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,779 8 224,494 - 3...

...la=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. (I found that i...

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)

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

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

...now 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> > Subject:...

...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 issue is the...

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

...gt;locator = (Rboolean (*)())NULL_Locator; dev->mode = (void (*)())NULL_Mode; dev->hold = (void (*)())NULL_Hold; dev->metricInfo = (void (*)())NULL_MetricInfo; /* * Initial graphical settings */ dev->startfont = 1; dev->startps = 10; dev->startcol = R_RGB(0, 0, 0); dev->startfill = R_TRANWHITE; dev->startlty = LTY_SOLID; dev->startgamma = 1; /* * Start device */ if(!NULL_Open(dev)) { return FALSE; } /* * Device physical characteristics */ dev->left = 0; dev->ri...

Dear all, Good day! I have a problem in reading Excel files in R and appending them to each other. Suppose we have several Excel files in a directory with headers and want to use R to append them in a single file with an additional variable in the final file indicating from which files the data come from. As I have many Excel files and their sizes are very big I should write a loop in R to do

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.

The subject of your email is missing. Perhaps you need to read the Posting Guide (again?) about attachments. Embedding your example directly in the body of the email is generally more accessible in archives than attaching it. -- Sent from my phone. Please excuse my brevity. On April 27, 2016 1:14:17 PM GMT+01:00, G.Maubach at gmx.de wrote: >Hi All, > >I am addressing this post to all

Hi All, I am addressing this post to all who are new to R. When learing R in the last weeks I took some notes for myself to have code snippets ready for the data analysis process. I put these snippets together as a script template for future use. Almost all of the given command prototypes are tested. The template script contains snippets for best practices and leaves out the commands that