[R] write data using xlsReadWrite

[David Winsemius]

On May 15, 2012, at 10:08 PM, diyanah wrote:

> Hai,
> I use these codes to read my data from the above data that I create,  
> but how
> can I get rid of the first V1, because it is row number, not one of  
> my data
> value.

Why do you want to get rid of it? What harm is it doing? (Dataframes  
need to have rownames, many functions depend on that aspect of  
dataframes,  and if you do not provide them,  then default rownames  
get inserted.)

> Second, how can I read row 1 and only column 1 (V2 value for example).

Use colClasses, nrows
?read.table

>
> setwd("D:\\FYP\\image\\Cropped Images\\user61")
> info
> <- 
> read 
> .xlsx 
> ("forgerUser61.xlsx",sheetName="Sheet1",rowIndex=2:2,header=FALSE)
>
>> V1                  V2             V3             V4         V5
>> V6             V7             V8             V9
>>   1  1 1859.935 12068.61 281.5818 283.75 3330043 3495302 7557.209
>> 1887.269
>
> --


David Winsemius, MD
West Hartford, CT