using System;

using System.Web;

using System.Data;

​

​

​

using System.IO;

​

​

public class Program

{

    public static void Main()

    {

        try

            {

                DataSet dsData = new DataSet(); 

                DataTable dt = new DataTable();

                dt.Clear();

                dt.Columns.Add("Name");

                dt.Columns.Add("Marks");

                dt.Columns["Name"].ColumnName = "Name";

                dt.Columns["Marks"].ColumnName = "Marks";

                object[] o = { "Ravi", 500 };

                object[] o2 = { "Ravi", 500 };

                object[] o3 = { "Ravi", 500 };

                dt.Rows.Add(o);

                dt.Rows.Add(o2);

                dt.Rows.Add(o3);

                dsData.Tables.Add(dt);

                //SpreadsheetGear.IWorkbook wbExport = SpreadsheetGear.Factory.GetWorkbook();

                if (dsData.Tables.Count > 0)

                {

                    //SpreadsheetGear.IWorksheet wsExport = wbExport.Worksheets.Count > 0 ? wbExport.Worksheets[0] : wbExport.Worksheets.Add();

                     // Create a new empty workbook in a new workbook set. 

        SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook(); 

        // Get a reference to the first worksheet. 

        SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets["Sheet1"]; 

        // Get a reference to the top left cell of Sheet1. 

        SpreadsheetGear.IRange a1 = worksheet.Cells["A1"]; 

        // Set a formula. 

        a1.Formula = "=24901.55 / PI()"; 

        // Output the result of the formula. 

        System.Console.WriteLine("The diameter of the earth is " + a1.Value + " miles."); 

                string strExport = HttpContext.Current.Request.MapPath(string.Format("/Export-{0}.xls", Guid.NewGuid()));

                workbook.SaveAs(strExport, SpreadsheetGear.FileFormat.Excel8);

                //context.Response.AddHeader("Content-Disposition", "attachment;filename=\"Export.xls\"");

                //context.Response.ContentType = "application/vnd.ms-excel";

                byte[] arrContent = File.ReadAllBytes(strExport);

                //wbExport.SaveToStream(context.Response.OutputStream, SpreadsheetGear.FileFormat.Excel8);

                    }

            }

            catch (Exception ex)

            {

                System.Console.WriteLine(ex);

                System.Console.WriteLine(ex.StackTrace);

                //context.Response.Write("{TotalCount: 0, Data: {}, Message: 'Exception raised, please contact administrator for more details!'}");

                //ClientRequest.WriteLog(System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath, ex.ToString());

            }

    }

}