Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Asp.Net Programming

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...

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...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc