Add xls/xlsx data processing

[endersonmaia]

A lot of data are made public using .xls/.xlsx format, and it would be great to free this data from this format to more open formats ;)

[danielfireman]

That is indeed a super nice to have!

The first thing to do is implementing a Table and Iterator. You can follow the CSV implementation.

One way of approaching this problem is generating a CSV from the XLS/XLSX and from there re-use the CSV implementation.

Furthermore, you could re-use functions like Remote and FromFile. It is quite simple to create a new package source and move the Source and those methods, which are likely to be re-used on this and other implementations.

Care to take a stab at this issue?

[endersonmaia]

I already started searching for some libs to deal with .xls, and it's hard to find something useful.

I'm experimenting with extrame/xls, and will post something here ASAP.

[danielfireman]

I usually start searching at https://golanglibs.com .. extrame/xls is actually the top hit.

The good news is that it seems that it can read XLS without formatting (which suffices our needs). Hope your tests go well and let me know if you run into any problem or have any questions.

[endersonmaia]

taking note : https://github.com/avelino/awesome-go#microsoft-excel

[endersonmaia]

using the github stars metric to decide :

• 6k ⭐ - https://github.com/360EntSecGroup-Skylar/excelize
• 4k ⭐ - https://github.com/tealeg/xlsx

[endersonmaia]

seems like a great option to use https://github.com/pbnjay/grate