There seems to be a bevy of excel packages in Julia. I see that Taro and ExcelReaders use different libraries, but I’m having a hard time distinguishing and choosing between all these packages. I see that ExcelFiles.jl also exists, but seems to be an adaptor library for ExcelReaders. Does anyone ha…

I see that ExcelReaders uses DataValue{Union{}}() for empty cells. Is DataValues.jl an alternative for missing in Julia? What’s the benefit of not just using missing?

Just as an FYI, I recently avoided ExcelReaders.jl precisely because DataValue entries. I ended up exporting from excel to csv and just using CSV.jl to work with DataFrames.

As the developer of XLSX.jl, I would say that a unique feature of this package is the existence of deliberate hidden bugs to make this life less miserable.

[image] [ANN] XLSX.jl now supports Julia v1.0 Community After a full rewrite of all custom iterators, XLSX.jl is now available for Julia v1.0 . Enjoy!

[image] felipenoris: As the developer of XLSX.jl, I would say that a unique feature of this package is the existence of deliberate hidden bugs to make this life less miserable. Have you received any feedback? I am curious how people reacts these kind of challenges. Could you also open a lit…

This was a joke, and I hope you understand that. The true story is that this is a code path I wrote to speed up the package, but I’m not sure if it introduces a bug (almost certain it does), so I left this as an easter egg for curious developers.

I don’t understand the joke, which is always embarrassing to admit. I understood it’s humour and that’s why I asked. That’s also the reason I tried to select words in such a way that nobody would be offended (because I didn’t get the joke). Stupid technical question: can’t you use unit testing to m…

I’m unable to trigger the bug. That’s the whole point. I should also point out that I’m great in making bad jokes. :sweat_smile:

I want to read xlsx documents. Should I use XLSX.jl, ExcelReaders.jl, Taro.jl, or XSLXReader.jl?

General Usage

felipenoris September 4, 2018, 1:36pm 5

Topic		Replies	Views
.xls Files on Julia General Usage package	5	3464	January 30, 2021
Excel files & Julia? General Usage excel	6	1098	September 1, 2026
[ANN] XLSX.jl now supports Julia v1.0 Community	0	773	September 4, 2018
Breaking ExcelReaders.jl update Data announcement	2	1122	May 7, 2018
Csv file not a valid file New to Julia csv	8	2549	March 18, 2020

I want to read xlsx documents. Should I use XLSX.jl, ExcelReaders.jl, Taro.jl, or XSLXReader.jl?

Related topics