Bug - Excel range setting not working when importing multiple sheets

[jkmusyoka]

@N-thony I would like to report a bug in R-Instat 0.8.1.

I am using the "Import from file" dialog to import a range of cells in multiple sheets as shown below.

The corresponding R code, as shown below, is actually missing the range argument.

petaukemissingdatamoffat1 <- rio::import_list(file="C:/Users/jkmus/Downloads/petauke missing data moffat (1).xlsx", guess_max=Inf, na=c("",""), which=c(4,5,6)

However when I edited the R command to include the range argument, the importing process works OK.

petaukemissingdatamoffat1 <- rio::import_list(file="C:/Users/jkmus/Downloads/petauke missing data moffat (1).xlsx", guess_max=Inf, range="A4:G35", which=c(4,5,6), na=c("",""))

Since the R code works, I believe this is a small bug to fix to get the dialog working for multiple sheets?

Over to you to allocate.

[rdstern]

@jkmusyoka my understanding is that the range addition does work when a single Excel sheet is imported. It goes wrong when the import is for multiple sheets.

Did I understand that correctly?