Problem with missing values

[ghost]

Hi,

I would like to read values from A1:B2 cells using readxl with following script:

using ExcelReaders

path = Base.Filesystem.joinpath(@__DIR__, "test.xlsx")
range = "test!A1:B2"

data = ExcelReaders.readxl(path, range)
dump(data)

Currently the script works fine if the values are there and I get PyError in case values are missing. I would like to get 2x2 array regardless if the values are there or not.

I tried to use readxlsheet like this:

data = ExcelReaders.readxlsheet(path, "test"; skipstartrows=0, skipstartcols=0, nrows=2, ncols=2)
dump(data)

but I get 0x0 array in case data is missing.

Thanks,
Piotr

[davidanthoff]

Hm, I'm not sure we should do this... There is a difference between a cell that is defined but has no data in it (which we handle correctly), and a situation where a cell is just not defined at all because you are indexing into a location outside of the size of the sheet. I think the fact that the underlying python lib also errors if one tries to access this is probably a good precedent to follow.

I'll leave this open in case others want to chime in as well.

[ghost]

Thanks for the reply, for the time being I will do without this feature.
Just to understand a bit more. When is the cell considered to be defined - when it has value or some formatting?

[davidanthoff]

I'm not entirely clear what the semantics are, but at least from the python lib point of view there seems to be a difference between a cell existing and a cell existing but not having a value.