Programmatic-ally write from C# to Excel

richard smith

I am pulling data from a SQL Server Database into a C# datagrid. I then want to take C# to write into column A1 - R1 information about what is being pulled into the Excel, for example the data would be like this (A1) ID, (B1) Phone Number, (C1) Email etc etc

The only examples I have been able to find thus far show how to write cell by cell, but there has to be a way to just assign a value like you would do in Excel VBA:

FormulaR1C1 = "ID"



Can someone please provide me with a way to perform this daunting task?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
Try:

worksheet.Range["A1"].Value2 = id;
worksheet.Range["B1"].Value2 = phoneNumer;
worksheet.Range["c1"].Value2 = eMail;
richard smith13y ago
Thank all of you for replying. The answers provided show how to export a datagridview to Excel. I want to hardcode values in my C# coding and then export those values to a certain cell in my Excel Workbook. So I would want the value of ID to be written to A1, Phone Number to be written to B1, Email to be written to C1.
darma teja13y ago
Hi,

try like this:

Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();

Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);
Microsoft.Office.Interop.Excel._Worksheet worksheet = null;
worksheet = workbook.ActiveSheet;
worksheet.Name = namehere;


for (int i = 1; i < datagridview.Columns.Count + 1; i++)
{
worksheet.Cells[1, i] = datagridview.Columns[i - 1].HeaderText;

}

for (int i = 0; i < datagridview.Rows.Count - 1; i++)
{
for (int j = 0; j < datagridview.Columns.Count; j++)
{
worksheet.Cells[i + 2, j + 1] = datagridview.Rows[i].Cells[j].Value;

}
}

app.Visible = true;
Mahesh Mohan13y ago
  protected void lnkBtnExcel_Click(object sender, EventArgs e)

        {

           Response.ClearContent();

            Response.Buffer = true;

            Response.AddHeader("content-disposition",

            string.Format("attachment; filename={0}", "Customers.xls"));

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

            StringWriter sw = new StringWriter();

            HtmlTextWriter htw = new HtmlTextWriter(sw);

            gvCompetitor.AllowPaging = false; gvCompetitor.DataBind();

            gvCompetitor.HeaderRow.Style.Add("background-color", "#FFFFFF");

            gvCompetitor.RenderControl(htw);

            Response.Write(sw.ToString());

            Response.End();





        }
Satyapriya Nayak13y ago
http://www.c-sharpcorner.com/uploadfile/hrojasara/export-datagridview-to-excel-in-C-Sharp/