Well, I think Aspose.Cells for .NET suits your needs well. Aspose.Cells is a spreadsheet management library (created in managed C#) used to create, manipulate, render, convert or print MS Excel files (XLS, XLSX, XLSM, CSV, Tab Delimited, ODS, SpreadsheetML etc.). You can create the spreadsheets from the scratch with data, formatting, formulas, charts, pivot tables or other objects. You can also manipulate existing Excel files and re-save them after modifications in data or objects.
We recommend you to kindly see the Wiki Conf. Docs for your reference here: