How to read excel in julia?

Question

I need to read an excel file in Julia. I tried the package "ExcelReaders". However, the package requires an additional Python or xlrd package. Although it uses the conda.jl package to automatically install these dependencies, I constantly run into various installation problems. Is there an easy way to read excel in Julia? Has anyone tried the package Taro.jl?

Answer 1

The Taro.jl package works well to read Excel in Julia. The package can be installed using Pkg.add(Taro) . After installing the package, you can download it using using Taro; Taro.init() using Taro; Taro.init() . You can use Taro.readxl() to read excel files. The following post provides some nice tutorial on reading excel files in Julia using Taro.jl:

https://economictheoryblog.com/2018/01/03/how-to-read-an-excel-file-in-julia-language-an-example/

Answer 2

Tarot works very well (even if I say so). You need to install java on the computer, but after that Pkg.add(Taro) install all the dependencies for you. And, I think you're lucky with the tarot with more complex excel files.

Answer 3

If you're comfortable with the ods format, you can also use the OdsIO.jl package.

It also uses the python module ( ezodf ), but it should install it automatically on both Windows and Linux when installing OdsIO.jl.

Answer 4

If you can save as .csv then CSV.jl works well.

Answer 5

ExcelReaders Package Also Available

https://github.com/davidanthoff/ExcelReaders.jl