readxlsheet reads the empty cells as #NA about excelreaders.jl HOT 6 CLOSED

I don't think anything changed there? What behavior would you expect?

from excelreaders.jl.

They used to be registered as "missing", and functions such as ismissing() returned true (now they return false).

from excelreaders.jl.

Ah, I think you were reading them into a DataFrame, right? That functionality has been moved from this package to ExcelFiles.jl, and if you materialize things into a DataFrame that way, you'll get missing values for empty cells.

I don't think this package here ever created missing values, though...

from excelreaders.jl.

That's the case with ExcelFiles,but I usually used ExcelReaders like so and it did create missings (NAs in earlier versions of DataArrays).

a = readxlsheet(filename, sheetname);

a would come back as a DataArray{Any,2} with missings, and we did not pre-allocate it.

from excelreaders.jl.

Ah, interesting! I guess what happened is that DataArray was ported to Missing at some point, and then all of a sudden ExcelReaders.jl returned missing values, even though I was not even aware of that :)

The Queryverse is not using the whole Missing story. That design doesn't work for some key scenarios due to some technical limitations, so Queryverse is using DataValues.jl for its missing value story, and that is what you are getting there.

from excelreaders.jl.

Oh all right, thanks for the responses! Going forward I'm going to have to use ExcelFiles I guess.

from excelreaders.jl.