I am working in a project where i need to export the Gridview data into an Excel file. after that in the newly geretated excel sheet i want to put some formula so that it gives the sum of all the columns. Exporting data into an excel file is done Using following code
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.IO;
using Microsoft.Office.Interop.Excel;
/// <summary>
/// Summary description for BinayExport
/// </summary>
public static class BinayExport
{
private static string _Name;
public static string Name
{
get {return _Name; }
set { _Name = value; }
}
private static string _CustomerName;
public static string Custome ...
Go to the complete details ...