CompuMaster.Excel.ExcelOps

A common API for several libraries to access and edit Excel files

Why this project?

• Provides the common API for all following Excel engines
• Sometimes there is the need to switch the Excel engine under the hood, because the standard MS Excel engine (via COM interop) is too slow for many operations.
• Depending on your custom project or developer license, you might want/require to use a specific alternative Excel engine
• Allow parallel use of several Excel engines in your project
  • at least for some work items, you need Excel engine A, while for some other work item you need Excel engine B because of its feature set, bugs, etc.
  • allow step-by-step-migrations instead of one big migration task

One common API for several Excel engines

• CompuMaster.Excel.MicrosoftExcel
  • Use Microsoft.Office.Interop.Excel v15 (MS Office 2013) or higher, for solutions targetting .NET Framework 4.8 or .NET 6 or higher
• CompuMaster.Excel.EpplusFreeFixCalcsEdition
  • Use Epplus 4.5 with LGPL license for solutions targetting .NET Framework 4.8 or .NET 6 or higher
• CompuMaster.Excel.EpplusPolyformEdition
  • Use latest Epplus with Epplus Software's polyform license for solutions targetting .NET Framework 4.8 or .NET 6 or higher
• CompuMaster.Excel.FreeSpireXls
  • Use FreeSpire.Xls for solutions targetting .NET Framework 4.8 or .NET 6 or higher

Quick & dirty engine comparison / why you shouldn't use MS Excel for all situations

In following a simplified comparison without any warranties. Subjects might change over time, too. Please contact the responsible manufacturerer especially for licensing issues.

Engine	Pros	Cons	Note on licensing or support	Manufacturer website