Closed rozsasarpi closed 3 weeks ago
I am getting this also on a particular workbook. We try tp debug.
Okay .. readtable will read all sheets and if there is a sheet with NO ROWS (like a chart pointing to another sheet) ..it will error.
I got around this by :
julia> xf = XLSX.openxlsx(joinpath(filedir, fn), enable_cache=false)
XLSXFile("xxxxxxxxx.xlsx") containing 2 Worksheets
sheetname size range
-------------------------------------------------
Sheet1 12646x91 A1:CM12646
Chart size unknown
then I only read the sheet I need xf[1] ..
Just submitted a PR #267 which happens to fix this issue. I first thought, this issue would be unrelated, and digged deeper to solve my own problem. But then I saw that a file was shared in this issue and thought, I should at least test...
Closed by #267 .
readtable
andreadxlsx
both return an error:ERROR: ArgumentError: no node name
Here is the error trace for
readxlsx
:XLSX.jl 0.7.6 Julia 1.5.3 Windows 10
girder_results_10.xlsx