C#

...
Microsoft.Office.Interop.Excel.Worksheet mySheetInputData = null;
try
{
   mySheetInputData = (Microsoft.Office.Interop.Excel.Worksheet)ExWorkBookInputData.Sheets["Sheet1"];

    mySheetInputData = (Microsoft.Office.Interop.Excel.Worksheet)ExWorkBookInputData.ActiveSheet;
    mySheetInputData.Name = "First Sheet";
 // storing header part in Excel
    for (int i = 1; i < dgv.Columns.Count + 1; i++)
    {
        mySheetInputData.Cells[1, i + 1] = dgv.Columns[i - 1].HeaderText;
    }
    for (int j = 1; j < dgv.Rows.Count + 1; j++)
    {
        mySheetInputData.Cells[j + 1, 1] = dgv.Rows[j - 1].HeaderCell.Value.ToString();
    }
    // storing Each row and column value to excel sheet

    for (int i = 0; i < dgv.Rows.Count; i++)
    {
        for (int j = 0; j < dgv.Columns.Count; j++)
        {
            mySheetInputData.Cells[i + 2, j + 2] = dgv.Rows[i].Cells[j].Value.ToString();
        }
    }
    //save the application
    string fileNameInputData = String.Empty;
    SaveFileDlgInputData.Filter = "Excel Files (*.xlsx)|*.xlsx";
    SaveFileDlgInputData.FilterIndex = 2;
    SaveFileDlgInputData.RestoreDirectory = true;

    if (SaveFileDlgInputData.ShowDialog() == DialogResult.OK)
    {
        fileNameInputData = SaveFileDlgInputData.FileName;
        ExWorkBookInputData.SaveAs(fileNameInputData, Type.Missing, Type.Missing,
            Type.Missing, Type.Missing, Type.Missing,
            Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

    }
    else
        return;
        ...

private const System.Reflection.BindingFlags FullAccess = System.Reflection.BindingFlags.CreateInstance |
                                                          System.Reflection.BindingFlags.GetField |
                                                          System.Reflection.BindingFlags.GetProperty |
                                                          System.Reflection.BindingFlags.Instance |
                                                          System.Reflection.BindingFlags.InvokeMethod |
                                                          System.Reflection.BindingFlags.Public |
                                                          System.Reflection.BindingFlags.SetField |
                                                          System.Reflection.BindingFlags.SetProperty |
                                                          System.Reflection.BindingFlags.Static |
                                                          System.Reflection.BindingFlags.NonPublic;


public static T GetMemberWiseClone<T>(T ToClone)
{
    T Result = default(T);

    if (ToClone != null)
    {
        try
        {
            Result = (T)ToClone.GetType().GetMethod("MemberwiseClone", FullAccess).Invoke(ToClone, new object[] { });
        }
        catch { }
    }

    return Result;
}