Datagrid to Excel

[JES]

I am trying to export a datagrid to Excel. Via web help, I'm 90% there. My
only problem is that I would like to remove one column from the export. I've been successful at removing the data portion of the column, but I can't get rid of the heading. Any help would be appreciated.

[hakeemkazmi]

hi thr,i can help u this extent that you can remove the data waht eveer in column but even i am unable to completely remove column.try this or if you got any idea please forward to me also.but this is for the fields like buttonfields or linkfields.

private void PrepareGridViewForExport(Control gv)
{

Button lb = new Button();

Literal l = new Literal();

string name = String.Empty;

for (int i = 0; i < gv.Controls.Count; i++)
{

if (gv.Controls[i].GetType() == typeof(Button))
{

l.Text = (gv.Controls[i] as Button).Text;

gv.Controls.Remove(gv.Controls[i]);

}
else
if (gv.Controls[i].HasControls())
{

PrepareGridViewForExport(gv.Controls[i]);

}
}

I am trying to export a datagrid to Excel. Via web help, I'm 90% there. My
only problem is that I would like to remove one column from the export. I've been successful at removing the data portion of the column, but I can't get rid of the heading. Any help would be appreciated.

[r035198x]

Again moved to .NET forum.
And guys let's make sure we all use code tags when posting code in the forums.

[insanomania911]

But how do you export it at first place to Excel??

I tried all the methods (codings) available online and none worked since I can't refrence to the PIA's (Interop) related to Microsoft Office.

Is there any other way around it?

Thanks,

[Shashi Sadasivan]

Please see the thread,
This question was asked before
http://www.thescripts.com/forum/thread378185.html

Hope this also deletes the header

cheers