Re: [R] write data using xlsReadWrite

Hi Ive come up with this code to read my file, but receive an error that I ve no idea how to fix. can some one help. > read<-read.xlsx("D:\\FYP\\image\\Cropped > Images\\user227\\user227forger.xlsx", sheetName="Sheet1", rowIndex="1", > colIndex="varLH2y", colClasses="character", row.names=TRUE) >E

Re: [R] write data using xlsReadWrite

Hai, I have change it to these, but error and I couldn't fix it. Do you have any idea why? file <- system.file("D:\\FYP\\image\\Cropped Images\\user61", "forgerUser61.xlsx", package = "xlsx") wb <- loadWorkbook("forgerUser61.xlsx") sheets <- getSheets(wb) sheet <- sheets[["all"]] res <- readRows(s

Re: [R] write data using xlsReadWrite

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

Re: [R] write data using xlsReadWrite

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. Second, how can I read row 1 and only column 1 (V2 value for example). setwd("D:\\FYP\\image\\Cropped Images\\user61") info <-read.x

Re: [R] write data using xlsReadWrite

Thank you, I came up with these. Problem solve. varValue <- data.frame(varLH2x, varLH2y, varHH2x, varHH2y, varLL2x, varLL2y, varHL2x, varHL2y) res<-write.xlsx(varValue, "D:\\FYP\\image\\Cropped Images\\user61\\genuineUser61temp.xlsx", sheetName="Sheet1",col.names=TRUE, row.names=TRUE, append=FALS

Re: [R] write data using xlsReadWrite

You're trying to write an object that you've never created. If you want to write `varHL2y`, which it appears you do, you would replace that for `mydata` in your command. Best, Ethan On Sun, May 13, 2012 at 1:33 AM, diyanah wrote: > Hai, I'm trying to write these var output data from these codes

[R] write data using xlsReadWrite

Hai, I'm trying to write these var output data from these codes inside excel file. My directory to store the data is /D:\FYP\image / but receive an error message : /Error in write.xls(mydata, "D:\\FYP\\image.mydata.xls") : object 'mydata' not found/ these are my codes, can you help give an ad