axlsx

It looks like this is a community continuation of the axlsx gem which was maintained back in the day by Randy Morgan (randym) over at https://github.com/randym/axlsx. One of my earliest open source contributions was adding support so that you could output spreadsheets with "conditional" formatting (color something red if it is below some value, for instance). I remember Randy being extremely supportive of new contributors and it made me want to be a part of the ruby community. Thanks for continuing the work!

You might be interested in the axlsx ruby gem: https://github.com/randym/axlsx Haven't used it, but it allows the creation of pretty complex spreadsheets from ruby code. Not sure if it is able to read from spreadsheets, but it could be one part of the service layer.

LO and other openoffice suites are progeny of StarOffice, originally released in 1985. Even with such a long development history, there are deep compatibility issues which make it unacceptable for the "power users" that comprise the most profitable segment of the market. And if you really want to go down that rabbit hole of perfect compatibility, it's an absolute clusterf*ck. There are more than than 20 different 100+ page specs (some exceeding 500 pages) needed to properly parse excel files. An incomplete list (which you can find by searching for the keyword): MS-XLS, MS-CFB, MS-ODRAW, MS-ODRAWXML, MS-OGRAPH, MS-OFFCRYPTO, MS-RMPR, MS-OVBA, MS-OSHARED, MS-CTXLS, ECMA-376, MS-OLEDS, MS-OLEPS, MS-DTYP, MS-XLSB, MS-OFORMS, MS-VBAL, MS-OAUT, MS-DCOM, MS-XLSX But if you are looking to contribute to an open source project, consider some of