export gridview to excel using closed xml with 1 column apart

Question

I'm exporting gridview to excel using ClosedXML, I want my output to have a one column apart. Like this.

This is my code for the gridview header part.

           for (col = 0; col < headerCount; col++)
            {
                worksheet.Cell(3, current + 1).Value = GridView1.HeaderRow.Cells[col].Text;

            }

Note: My gridview column count is dynamic.

Sorry, it should be 'col' not current, typo error. I'll try your solution below if its going to work. — odlan yer, Sep 22 '16 at 07:42

score 1 · Accepted Answer · answered Sep 22 '16 at 07:02

1

Try this:

for (col = 0; col < headerCount; col++)
{
    worksheet.Cell(3, current * 2 + 1).Value = GridView1.HeaderRow.Cells[col].Text;
}

answered Sep 22 '16 at 07:02

Francois Botha

4,520
1
34
46

What if I only want the 4th and succeeding column to have 1 column apart, and the first four column is not? – odlan yer Sep 22 '16 at 07:52
You'll have to use normal programming statements, `if`s and such, do output the values to the relevant column. – Francois Botha Sep 22 '16 at 11:58

export gridview to excel using closed xml with 1 column apart

1 Answers1