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 PrepareGridView ForExport(Contr ol gv)
{

Button lb = new Button();

Literal l = new Literal();

string name = String.Empty;

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

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

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

gv.Controls.Rem ove(gv.Controls[i]);

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

PrepareGridView ForExport(gv.Co ntrols[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