nshoang

Results 4 comments of nshoang

package openxlsx; function read.xlsx does not work on some excel files (there is no problem with read.xlsx from xlsx package)

I made two identical excel files example.xlsx and example1.xlsx. The function can read 'example.xlsx' but it cannot read example1.xlsx. The reported error is 'Error in eval(expr, envir, enclos) : expecting...

package openxlsx; function read.xlsx does not work on some excel files (there is no problem with read.xlsx from xlsx package)

Thanks for your suggestion. I installed the package openxlsx using the command 'install.packages("openxlsx")' (Rstudio for MAC). Maybe the package I have is not the latest one.

package openxlsx; function read.xlsx does not work on some excel files (there is no problem with read.xlsx from xlsx package)

Does any know a possible cause for the error 'Error in eval(expr, envir, enclos) : expecting a single value' with read.xlsx? Thanks!

package openxlsx; function read.xlsx does not work on some excel files (there is no problem with read.xlsx from xlsx package)

Thank you. I will use xlsx or XLconnect package. I have no problem with these packages. I wanted to do conditional formatting with openxlsx but its not worth spending to...