Linq to Excel tables
Open a C# script and start querying and modifying data in workbook tables. Tables are available as strongly typed collections that you can read and modify.
Interact with Excel
Use C# to interact with Excel's API directly. Anything you can do with VBA, you can now do with C# too!
Use C# to fetch data from the outside world and bring it into Excel. REST services, API's, local files - if you can fetch it with C#, you can get it into Excel.
Find and format in Excel
Use C# and LINQ to find rows in Excel, highlight them, and change their formatting.
Use NuGet packages
Why reinvent the wheel? Make use of existing libraries to solve problems. Download NuGet packages and use them in your C# scripts.