Asp.Net Programming :: Export to Excel


	Export to Excel Hi Is there anyway to export a DataTable to Excel? Thanks You can write it to disk or memory stream and then use Excel to open it. Or flush it to the response buffer and change the content type to excel. -- Regards, Alvin Bruney ------------------------------------------------------ Shameless author plug Excel Services for .NET is coming... https://www.microsoft.com/MSPress/books/10933.aspx OWC Black Book www.lulu.com/owc Professional VSTO 2005 - Wrox/Wiley "Smith" <a@as.com> wrote in message news:eiJTfRxoHHA.5084@TK2MSFTNGP02.phx.gbl... - Hide quoted text - > Hi > Is there anyway to export a DataTable to Excel? > Thanks Here are some great ways to create Excel output: http://SteveOrr.net/articles/ExcelExport.aspx Here's a free control that can help with Excel output (and Word, PowerPoint, and WordPerfect output): http://SteveOrr.net/articles/ExportPanel.aspx Or You could open an existing Excel file and modify it as an ADO.NET data source: http://groups.google.com/group/microsoft.public.excel.programming/bro... And here are a couple good 3rd party products that can make your chores easy: http://SteveOrr.net/reviews/AsposeExcel.aspx http://SteveOrr.net/reviews/OfficeWriter.aspx -- I hope this helps, Steve C. Orr, MCSD, MVP, CSM, ASPInsider http://SteveOrr.net "Smith" <a@as.com> wrote in message news:eiJTfRxoHHA.5084@TK2MSFTNGP02.phx.gbl... - Hide quoted text - > Hi > Is there anyway to export a DataTable to Excel? > Thanks