search for: sheetindex

...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, 2016 at 9:26 AM, Boris Steipe <boris.steipe at utoronto.ca> wrote: > Doe...

Hi all, I have a property, defined in an external stylesheet: .my_class { background-color: #FF0000; } I want to retrieve the value of this background-color of the class my_class. How can I do that with prototype/scriptaculous ? Thanks in advance, Nicolas Terray

Hey All, I'm trying to use the xlsx package to read a series of excel spreadsheets into R, but my code is failing at the first step. I setwd into my the directory with the spreadsheets, and, as a test ask for the first one: read.xlsx(file = "Argentina Final.xls", sheetIndex = 1) I promptly get an error message: Error in .jcall(row[[ir]], "Lorg/apache/poi/xssf/usermodel/XSSFCell;", : method getCell with signature (I)Lorg/apache/poi/xssf/usermodel/XSSFCell; not found Anyone have any idea how to fix this issue? Thanks, Andrew Winterman [[alternat...

Hi all, I am trying to read data from a particular excel sheet. library(xlsx) dat1=read.xlsx("las.xlsx", sheetIndex = 5) I know that this is sheet is the last one and this number grows over time When I run my script to read the last sheet then I have to change this number every time manually. Is it possible to read the last sheet of an excel file? Thank yo in advance Val [[alternative HTML version deleted]]

All - How can I read in a column of alphanumeric values without including ".0" on the numeric values? Original column: TeamLeaderID 258 342 316 U8 331 279 D1 116 235 296 ... [truncated] leaders = read.xlsx2('FILE', sheetIndex = 1, header = T) Column after it's been read in: leaders$TeamLeaderID 258.0 342.0 316.0 U8 331.0 279.0 D1 116.0 235.0 296.0 ... [truncated] If I try as.numeric(leaders$TeamLeaderID), everything gets converted: leaders$TeamLeaderID 11 27 19 54 23 13 28 2 8 15 ... [truncated] as.character()...

Hola. En un cierto directorio tengo archivos excel y de otros tipos. Cada uno de ellos corresponde a una encuesta a una empresa X. Me gustaria importar los datos de ciertas celdas de ciertas hojas de todos los archivos excel en una sola pasada. ¿Hay alguna forma de hacerlo? Yo se que la variable Z está siempre en la celda X de la hora tanto. Me gustaría ingresarlo todo en una matriz en que