Xlsxplorer - Load data from your .xlsx file into an Explorer.DataFrame.

Source: ~jiglesias/xlsxplorer - sourcehut git
HexDocs: Xlsxplorer — Xlsxplorer v0.1.0

It does what it says on the cover.
Single function module: You pass a path to a .xlsx file as a String and an integer indicating which sheet of the workbook to read.
That sheet from the .xlsx file gets read into and Explorer.DataFrame.

I’m not very happy with the integer to indicate which sheet, but I think it’s better to solve that into the underlying parser.

I also think that friction to read a .xlsx file is a net positive, I’ve had really long nights reading .xlsx into databases or processes. Thus I will not propose to add this library’s functionality to core Explorer.

6 Likes