ExcelFiles.jl icon indicating copy to clipboard operation
ExcelFiles.jl copied to clipboard

Can not open xlsx file. How to fix that?

Open yummy527 opened this issue 3 years ago • 1 comments

julia: 1.7.2 python: 3.10

using ExcelFiles, DataFrames
df = DataFrame(load("result.xlsx", "result"))
PyError ($(Expr(:escape, :(ccall(#= /home/wangxl/.julia/packages/PyCall/L0fLP/src/pyfncall.jl:43 =# @pysym(:PyObject_Call), PyPtr, (PyPtr, PyPtr, PyPtr), o, pyargsptr, kw))))) <class 'xlrd.biffh.XLRDError'>
XLRDError('Excel xlsx file; not supported')
  File "/opt/anaconda/lib/python3.8/site-packages/xlrd/__init__.py", line 170, in open_workbook
    raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported')


Stacktrace:
  [1] pyerr_check
    @ ~/.julia/packages/PyCall/L0fLP/src/exception.jl:62 [inlined]
  [2] pyerr_check
    @ ~/.julia/packages/PyCall/L0fLP/src/exception.jl:66 [inlined]
  [3] _handle_error(msg::String)
    @ PyCall ~/.julia/packages/PyCall/L0fLP/src/exception.jl:83
  [4] macro expansion
    @ ~/.julia/packages/PyCall/L0fLP/src/exception.jl:97 [inlined]
  [5] #107
    @ ~/.julia/packages/PyCall/L0fLP/src/pyfncall.jl:43 [inlined]
  [6] disable_sigint
    @ ./c.jl:458 [inlined]
  [7] __pycall!
    @ ~/.julia/packages/PyCall/L0fLP/src/pyfncall.jl:42 [inlined]
  [8] _pycall!(ret::PyCall.PyObject, o::PyCall.PyObject, args::Tuple{String}, nargs::Int64, kw::Ptr{Nothing})
    @ PyCall ~/.julia/packages/PyCall/L0fLP/src/pyfncall.jl:29
  [9] _pycall!
    @ ~/.julia/packages/PyCall/L0fLP/src/pyfncall.jl:11 [inlined]
 [10] #_#114
    @ ~/.julia/packages/PyCall/L0fLP/src/pyfncall.jl:86 [inlined]
 [11] (::PyCall.PyObject)(args::String)
    @ PyCall ~/.julia/packages/PyCall/L0fLP/src/pyfncall.jl:86
 [12] openxl(filename::String)
    @ ExcelReaders ~/.julia/packages/ExcelReaders/PgE1r/src/ExcelReaders.jl:64
 [13] getiterator(file::ExcelFiles.ExcelFile)
    @ ExcelFiles ~/.julia/packages/ExcelFiles/NtqPa/src/ExcelFiles.jl:0
 [14] nondatavaluerows(x::ExcelFiles.ExcelFile)
    @ Tables ~/.julia/packages/Tables/M26tI/src/tofromdatavalues.jl:24
 [15] columns
    @ ~/.julia/packages/Tables/M26tI/src/fallbacks.jl:261 [inlined]
 [16] DataFrame(x::ExcelFiles.ExcelFile; copycols::Nothing)
    @ DataFrames ~/.julia/packages/DataFrames/MA4YO/src/other/tables.jl:58
 [17] DataFrame(x::ExcelFiles.ExcelFile)
    @ DataFrames ~/.julia/packages/DataFrames/MA4YO/src/other/tables.jl:49
 [18] top-level scope
    @ In[7]:1
 [19] eval
    @ ./boot.jl:373 [inlined]
 [20] include_string(mapexpr::typeof(REPL.softscope), mod::Module, code::String, filename::String)
    @ Base ./loading.jl:1196

yummy527 avatar Feb 18 '22 09:02 yummy527

Just find that xlrd has not supported xlsx any more.

yummy527 avatar Feb 21 '22 01:02 yummy527