Error Generated on Importing Empty Sheet

[GoogleCodeExporter]

Importing an empty Excel sheet does not contain header names on the first row, 
hence resulting in a generated error.  The read.xlsx(2) function should return 
a NULL object for these cases.

Original issue reported on code.google.com by darde...@gmail.com on 27 Dec 2013 at 3:48

[GoogleCodeExporter]

Please attach a minimal code example which illustrates the issue. 

If you're trying to read a sheet that does not exist in a spreadsheet, I want 
the code to fail not to return NULL.  The sheet is not there.  If the error 
message is not clear about it, I can improve on that. 

Adrian

Original comment by adrian.d...@gmail.com on 27 Dec 2013 at 4:27

[GoogleCodeExporter]

Here is the code:

res <- read.xlsx("K:/Troubleshoot.xlsx", 1) #works because first sheet contains 
data
res2 <- read.xlsx("K:/Troubleshoot.xlsx", 2) #generates error because sheet is 
empty.  This should return NULL.  This causes my web application to crash

Original comment by darde...@gmail.com on 27 Dec 2013 at 4:34

Attachments:

• Troubleshoot.xlsx

[GoogleCodeExporter]

fixed it in trunk.  Now both read.xlsx, read.xlsx2 return NULL when the sheet 
is empty. 

Thanks, 
Adrian

Original comment by adrian.d...@gmail.com on 13 Feb 2014 at 3:59

• Changed state: Done