Top 3 Xlsm Open-Source Projects

ClosedXML

26 4,424 9.4 C#

ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.

Project mention: When XML in Word Became Illegal | news.ycombinator.com | 2023-10-12

It's also country specific.
I work on Excel library and the text to number/date feature was one of less fun things to implement at least semi-correctly.
I remember my comment on the PR back then:
https://github.com/ClosedXML/ClosedXML/pull/1899

pyexcel

1 1,173 0.0 Python

Single API for reading, manipulating and writing data in csv, ods, xls, xlsx and xlsm files

Project mention: Advice on ETL and Data Sharing work process | /r/ETL | 2023-11-07

You could try and write some simple python using the pyexcel and pandas libraries. I created a tool as a consultant with these packages that parsed spreadsheets with data from factories from all around the world. They did not lock down the Excel files used to submit data and it made it so much harder. If you go this route, I would recommend starting by putting your data into a SQLite database. Once you have your data in a database, you unlock the power of SQL for pulling reports. Also, you can port the data into a proper database if you ever need to. ChatGPT can probably get you a good chunk of the way there.

InfluxDB

www.influxdata.com featured

Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
excelize-wasm

1 164 6.7 Go

A WebAssembly build of the Go Excelize library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).