Open
Description
openedon Mar 6, 2018
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment