I didn't write this Excel formula engine. Here is why I trust it anyway

说明与用途

SharpCell 是一个免费的 MIT 许可的 Excel 公式引擎，适用于 .NET 8+，在 256 个测试工作簿上与 Excel 结果完全一致，支持 490 个函数，并允许添加自定义 C# 函数。

问题

A .NET project needs to recalculate Excel workbooks reliably without relying on Excel Interop, manual rewrite, or expensive commercial libraries.

结果

SharpCell achieves 253/254 formula‑containing workbooks with 100% cell‑level agreement to Excel, covering 423 of 490 functions, and is free and MIT‑licensed.

工作流

• Install SharpCell.Xlsx via dotnet add package
• Load workbook with XlsxReader.Load
• Call workbook.Recalculate() to compute all formulas
• Optionally add custom functions with workbook.Functions.Add
• Save or clone workbook for server use

证据

The result: 256 workbooks; of the 254 that contain formulas, 253 match Excel in every cell.

来源

490 functions, including dynamic arrays, LET, LAMBDA, MAP, BYROW, GROUPBY, PIVOTBY

来源

Free, MIT, no license keys

来源