Recommended method of doing work from C# was given here: Export datagridview to excel while keeping the formatting
1. Create a Macro recording of the actions that you wish to perform
2. View the VBA code generated for you
3. Use the VBA code to guide you for writing your C# code
If you follow these steps, and the original answer given, you will easily solve this question.