Export Datagridview to excell in c#.net(WinForm)

[nirmalsingh]

hai all,
i need to export datagridview contents to a excell sheet including header.
can anyone help me with sample code in c#.
thanx in advance
with Cheers
Nirmal

[nirmalsingh]

hai all,
i need to export datagridview contents to a excell sheet including header.
can anyone help me with sample code in c#.
thanx in advance
with Cheers
Nirmal

i myself found the solution, here is that.
onclick of a button
-----------------------------

dgPrefixes.SelectAll();//dgPrefixes is name of datagridview.
                Clipboard.SetDataObject(dgPrefixes.GetClipboardContent(), true);
                StreamWriter sw = new StreamWriter("d:\\test.xls");
                sw.Write(Clipboard.GetText());
                sw.Flush();
                sw.Close();

[jbi]

i TRIED YOUR CODE AND IT WORKED FINE..HOW CAN I ADD THE FIELD HEADINGS TO THE XLS FILE? APPRECIATE IT.

i myself found the solution, here is that.
onclick of a button
-----------------------------

dgPrefixes.SelectAll();//dgPrefixes is name of datagridview.
                Clipboard.SetDataObject(dgPrefixes.GetClipboardContent(), true);
                StreamWriter sw = new StreamWriter("d:\\test.xls");
                sw.Write(Clipboard.GetText());
                sw.Flush();
                sw.Close();