Automation of an Excel file allows us to doing various operations from C#. We can automate an Excel file from C# in two ways. Using Excel Object Model in one way and another way is using Microsoft Jet Engine to connect Excel from CSharp. Through the automation from C# we can achieve creating a new workbook, adding data to a workbook, creating charts etc.
From the following links you can see helpful resources about Excel automation from C#.