Ex_spreadsheet - fast, memory-efficient Elixir library for parsing spreadsheet files

Your Libraries & OS Mentoring Libraries
,
1

Hi everyone. We released Spreadsheet a couple of months ago which we have been using internally for parsing xlsx files internally for our production systems. There are already a couple of xlsx parsing libraries, but none of them managed to handle the file sizes and data types we found in the wild. We also needed something which can parse some other spreadsheet formats. Luckily we found a rust library called calamine which handled 99% of our scenarios and created this library to essentially wrap it with rustler.

It would be good to know if this can be useful for someone else.

Here are some benchmarks we ran today:

Docs: Spreadsheet — spreadsheet v0.4.0
Source:

29 Likes
2

this would be lovely as we deal with a lot of XLSX and XLS files.

3

Nice! Do you have a plan to add support for writing a spreadsheet file?

4

There is another library for writer spreadsheets we were working on and is published, but think we want to change the api slightly. It’s called xlsx_writer, also a rust library. You can check it out: xlsx_writer | Hex . It just needs a little bit of work still imo. Comments are welcome.

We thought about combining the two into one, but decided against it in the end for various reasons.

2 Likes