Hello list,
Thank you Adrian for making it possible to read Excel data tables into R.
I have noticed that read.xlsx2 ignores a headless column while read.xlsx doesn't. The column is included if column indices are specified.
I find it unexpected that columns are ignored. Is this because the very first row is used to define columns
Attached is a test xlsx file, my comment made clear by
read.xlsx("test.xlsx", sheetIndex=1, colClasses=NA)
read.xlsx2("test.xlsx", sheetIndex=1, colClasses=NA)
read.xlsx2("test.xlsx", sheetIndex=1, colClasses=NA, colIndex=c(1,2,3))
Cheers,
Ulrik