By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,684 Members | 1,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,684 IT Pros & Developers. It's quick & easy.

Export to Excel

P: n/a
Hi
Is there anyway to export a DataTable to Excel?

Thanks
May 30 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <aa@as.comwrote in message
news:ei**************@TK2MSFTNGP02.phx.gbl...
Hi
Is there anyway to export a DataTable to Excel?

Thanks

May 31 '07 #2

P: n/a
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/micro...1439ff12d7473d

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" <aa@as.comwrote in message
news:ei**************@TK2MSFTNGP02.phx.gbl...
Hi
Is there anyway to export a DataTable to Excel?

Thanks
May 31 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.