«

Hi All!
How to Export Datagrid view data to excel in ASP.net 3.5?

Thanks,
Chandan

I have some code..
I think it will help you...
public static void CreateWorkbook(DataSet ds, String path)
{
XmlDataDocument xmlDataDoc = new XmlDataDocument(ds);
XslTransform xt = new XslTransform();
StreamReader reader =new StreamReader(typeof
(WorkbookEngine).Assembly.GetManifestResourceStrea m(typeof (WorkbookEngine),
"Excel.xsl"));
XmlTextReader xRdr = new XmlTextReader(reader);
xt.Load(xRdr, null, null);

StringWriter sw = new StringWriter();
xt.Transform(xmlDataDoc, null, sw, null);

StreamWriter myWriter = new StreamWriter (path + "\\Report.xls");
myWriter.Write (sw.ToString());
myWriter.Close ();
}

And also visit following websites

http://www.codeproject.com/KB/grid/e...agridview.aspx

http://www.c-sharpcorner.com/uploadf...idtoexcel.aspx

http://www.vbdotnetheaven.com/Upload...idtoExcel.aspx







"chandan" <> wrote in message
news:d58949e0-81a1-4229-a2a1-...
> Hi All!
> How to Export Datagrid view data to excel in ASP.net 3.5?
>
> Thanks,
> Chandan