C#

<asp:Repeater ID="rptTotAmount" runat="server">
       <ItemTemplate>
            <div style="page-break-after:always;">
               <asp:Table ID="tblItemListt" runat="server" Font-Size="8%">
                   <asp:TableRow>
                       <asp:TableCell HorizontalAlign="Right"><%# DataBinder.Eval(Container.DataItem, "TotalAmount", "Total: {0:c}")%></asp:TableCell>
                   </asp:TableRow>
               </asp:Table>
           </div>
       </ItemTemplate>
   </asp:Repeater>

private void CreateExcelReport()
       {
           Microsoft.Office.Interop.Excel.Workbook wBook;
           Microsoft.Office.Interop.Excel.Worksheet wSheet;
           Microsoft.Office.Interop.Excel.Application wApp = new Microsoft.Office.Interop.Excel.Application();
           wApp.Visible = false;
           wBook = wApp.Workbooks.Add(true);
           wSheet = wApp.ActiveSheet;
           try
           {
               for (int i = 0; i < dataGridViewReport.Columns.Count; i++)
               {
                   wSheet.Cells[1, i + 1] = dataGridViewReport.Columns[i].HeaderText;
               }

               for (int i = 0; i < dataGridViewReport.Rows.Count; i++)
               {
                   DataGridViewRow row = dataGridViewReport.Rows[i];
                   for (int j = 0; j < row.Cells.Count; j++)
                   {
                       DataGridViewCell cell = row.Cells[j];
                       try
                       {
                           wSheet.Cells[i + 2, j + 1] = (cell.Value == null) ? "" : cell.Value.ToString();
                       }
                       catch (Exception ex)
                       {
                           MessageBox.Show("Error : " + ex.Message);
                       }
                   }
               }
               wApp.Visible = true;
           }
           catch (Exception ex)
           {
               MessageBox.Show("Error : " + ex.Message);
           }
           wApp.UserControl = true;
       }