C# Winforms datagridview column header text

Question

I build this code which exports datagridview rows into Excel file

Excel.Application xlApp ;
Excel.Workbook xlWorkBook ;
Excel.Worksheet xlWorkSheet ;
object misValue = System.Reflection.Missing.Value;

xlApp = new Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
int i = 0;
int j = 0;

for (i = 0; i <= dgvInventory.RowCount - 1; i++)
{
    for (j = 0; j <= dgvInventory.ColumnCount - 1; j++)
    {
        DataGridViewCell cell = dgvInventory[j, i];
        xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
    }
}

xlWorkBook.SaveAs(
    "D:\\exp.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue,
    misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue,
    misValue, misValue, misValue, misValue
);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();

releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);

it works good but problem is that im unable to export datagridview headertext. can anyone help me?

Can you post your code that worked to pass the datagridview header text to excel as well. I'm having the same issue and cant figure it out. — user933467
– user933467, Commented Sep 13, 2011 at 19:35

Decker97 · Accepted Answer · 2011-09-12 18:45:21Z

3

Do a loop before your main loop, something like this:

    for (int j = 0; j <= this.dataGridView1.ColumnCount - 1; j++)
    {
        string colName = dataGridView1.Columns[j].HeaderText;
    }

and set the header to excel worksheet row(0) or (1), column j to the value of colName.

answered Sep 12, 2011 at 18:45

Decker97

1,65310 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kier Primavera · Accepted Answer · 2018-10-19 01:57:31Z

0

    Excel.Application xlApp ;
    Excel.Workbook xlWorkBook ;
    Excel.Worksheet xlWorkSheet ;
    object misValue = System.Reflection.Missing.Value;

    xlApp = new Excel.ApplicationClass();
    xlWorkBook = xlApp.Workbooks.Add(misValue);
    xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
    int i = 0;
    int j = 0;

    /*header text*/
    for (i = 0; i <= dgvInventory.Columns.Count - 1; i++)
    {
      xlWorkSheet.Cells[1, i+1] = dgvView.Columns[i].HeaderText; 
    }

    /*And the information of your data*/
    for (i = 0; i <= dgvInventory.RowCount - 1; i++)
    {
        for (j = 0; j <= dgvInventory.ColumnCount - 1; j++)
        {
            DataGridViewCell cell = dgvInventory[j, i];
            xlWorkSheet.Cells[i + 2, j + 1] = cell.Value;
        }
    }

    xlWorkBook.SaveAs(
        "D:\\exp.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue,misValue, misValue, misValue, misValue);
    xlWorkBook.Close(true, misValue, misValue);
    xlApp.Quit();

    releaseObject(xlWorkSheet);
    releaseObject(xlWorkBook);
    releaseObject(xlApp);

edited Oct 19, 2018 at 1:57

answered Oct 19, 2018 at 1:49

Kier Primavera

11 bronze badge

4 Comments

Anh Pham Over a year ago

Usually it's better to explain a solution instead of just posting some rows of anonymous code. You can read How do I write a good answer, and also Explaining entirely code-based answers

Kier Primavera Over a year ago

oww sorry i only just copy his code and then paste this loop

Kier Primavera Over a year ago

/*header text*/ for (i = 0; i <= dgvInventory.Columns.Count - 1; i++) { xlWorkSheet.Cells[1, i+1] = dgvView.Columns[i].HeaderText; }

Kier Primavera Over a year ago

this loop which contains the header text that will help him to export datagridview headertext

Collectives™ on Stack Overflow

C# Winforms datagridview column header text

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related