insert data in excel using c# (save data in excel sheet column not in row) how to do this?

You could easily have typed this question into Google and get an answer - I'd suggest you to look at the Microsoft.COM.Interop.Excel[^] library which is automatically installed with
Office.

visit here...

http://www.sapnaedu.in/how-to-write-an-excel-file-in-c/[^]

protected void lnkExport_Click(object sender, EventArgs e)
   {
       Response.Clear();
       Response.Buffer = true;
       Response.ContentType = "application/vnd.ms-excel";
       Response.AddHeader("content-disposition", "attament;filename=SCMHatcheryReport.xls");
       Response.Charset = "";
       this.EnableViewState = false;

       System.IO.StringWriter sw = new System.IO.StringWriter();
       System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

       GVHatcheryReport.RenderControl(htw);

       Response.Write(sw.ToString());
       Response.End();
   }

   public override void VerifyRenderingInServerForm(Control control)
   {
   }