search for: endcol

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

...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 - 30,554 9,1...

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

...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 index - the S...

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