Skip to content

ArgumentError: ref of NULL PyObject #64

@castrovjm

Description

@castrovjm

Hello! I just installed the newest version of JuliaPro (1.1.1.1) and ExcelReaders stopped working.

using ProgressMeter, BenchmarkTools, DataFrames, GLM, Combinatorics

# Set Directory

cd("...\\julia_codes")


global Country_Sample = "vsmall"

Data1 = readxlsheet("gravity_$(Country_Sample).xlsx", "Sheet1") '''

The following error appears 

```ArgumentError: ref of NULL PyObject
in top-level scope at base\none
in readxlsheet at ExcelReaders\PgE1r\src\ExcelReaders.jl:79
in #readxlsheet#3 at ExcelReaders\PgE1r\src\ExcelReaders.jl:79 
in openxl at ExcelReaders\PgE1r\src\ExcelReaders.jl:64
in getproperty at PyCall\ttONZ\src\PyCall.jl:313 
in getproperty at PyCall\ttONZ\src\PyCall.jl:303```

I have removed, added and built Conda and PyCall several times. 

Also, I added xldr through Conda.

Finally, this is the output when I run test ExcelReaders:

``` Testing ExcelReaders
    Status `C:\Users\jmcastro\AppData\Local\Temp\jl_8D0.tmp\Manifest.toml`
  [00ebfdb7] CSTParser v0.6.2
  [34da2185] Compat v2.1.0
  [8f4d0f93] Conda v1.3.0
  [864edb3b] DataStructures v0.17.0
  [e2d170a0] DataValueInterfaces v1.0.0
  [e7dc6d0d] DataValues v0.4.12
  [c04bee98] ExcelReaders v0.11.0
  [682c06a0] JSON v0.21.0
  [1914dd2f] MacroTools v0.5.1
  [bac558e1] OrderedCollections v1.1.0
  [69de0a69] Parsers v0.3.6
  [438e738f] PyCall v1.91.2
  [0796e94c] Tokenize v0.5.5
  [81def892] VersionParsing v1.1.3
  [2a0f44e3] Base64  [`@stdlib/Base64`]
  [b99e7846] BinaryProvider  [`@stdlib/BinaryProvider`]
  [864e158e] CredentialsHandler  [`@stdlib/CredentialsHandler`]
  [ade2ca70] Dates  [`@stdlib/Dates`]
  [8bb1440f] DelimitedFiles  [`@stdlib/DelimitedFiles`]
  [8ba89e20] Distributed  [`@stdlib/Distributed`]
  [cd3eb016] HTTP  [`@stdlib/HTTP`]
  [83e8ac13] IniFile  [`@stdlib/IniFile`]
  [b77e0a4c] InteractiveUtils  [`@stdlib/InteractiveUtils`]
  [76f85450] LibGit2  [`@stdlib/LibGit2`]
  [8f399da3] Libdl  [`@stdlib/Libdl`]
  [37e2e46d] LinearAlgebra  [`@stdlib/LinearAlgebra`]
  [56ddb016] Logging  [`@stdlib/Logging`]
  [d6f4376e] Markdown  [`@stdlib/Markdown`]
  [739be429] MbedTLS  [`@stdlib/MbedTLS`]
  [a63ad114] Mmap  [`@stdlib/Mmap`]
  [44cfe95a] Pkg  [`@stdlib/Pkg`]
  [de0858da] Printf  [`@stdlib/Printf`]
  [3fa0cd96] REPL  [`@stdlib/REPL`]
  [9a3f8284] Random  [`@stdlib/Random`]
  [ea8e919c] SHA  [`@stdlib/SHA`]
  [9e88b42a] Serialization  [`@stdlib/Serialization`]
  [1a1011a3] SharedArrays  [`@stdlib/SharedArrays`]
  [6462fe0b] Sockets  [`@stdlib/Sockets`]
  [2f01184e] SparseArrays  [`@stdlib/SparseArrays`]
  [10745b16] Statistics  [`@stdlib/Statistics`]
  [9d418dce] TOML  [`@stdlib/TOML`]
  [8dfed614] Test  [`@stdlib/Test`]
  [cf7118a7] UUIDs  [`@stdlib/UUIDs`]
  [4ec0a83e] Unicode  [`@stdlib/Unicode`]
Test Summary: | Pass  Total
ExcelReaders  |  245    245
   Testing ExcelReaders tests passed ```

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions