Read blank excel sheets with headers

[zx8754]

I need to read the sheet with headers, even if there is no data.

Example: if we have an excel file temp.xlsx with a sheet named Sheet1 with 3 columns as below with no data rows, just a header:

read_excel("temp.xlsx","Sheet1")

Gives error:

Error: Skipped over all data

I could set col_names = FALSE, then use the 1st row to be a header. As I need to read multiple sheets, some will have data and some will be blank with just a header, this is a bit painful.

Any better solution?

sessionInfo()
R version 3.2.2 (2015-08-14)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1

locale:
[1] LC_COLLATE=English_United Kingdom.1252  LC_CTYPE=English_United Kingdom.1252   
[3] LC_MONETARY=English_United Kingdom.1252 LC_NUMERIC=C                           
[5] LC_TIME=English_United Kingdom.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] readxl_0.1.0 dplyr_0.4.3 

loaded via a namespace (and not attached):
[1] magrittr_1.5   R6_2.1.1       assertthat_0.1 parallel_3.2.2 DBI_0.3.1      tools_3.2.2    Rcpp_0.12.1 

[jennybc]

Semi-duplicate of #222. Only difference: this issue confirms same behaviour happens when column headers are present, but there's no data. I verified that.