How to write the data in to excel file

Wrox Programmer Forums

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.1
How to write the data in to excel file

ASP.NET 1.1 As of 10/6/2005, this forum is locked as part of the reorganization described here: http://p2p.wrox.com/topic.asp?TOPIC_ID=35394. No posts have been deleted. Open ongoing discussions from the last week have been moved to either ASP.NET 1.0 and 1.1 Beginners http://p2p.wrox.com/asp-net-1-0-1-1-basics-60/ or ASP.NET 1.0 and 1.1 Professional. http://p2p.wrox.com/forum.asp?FORUM_ID=50. See my sticky post inside for more.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.1 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

October 13th, 2004, 10:41 AM

pavanp

pavanp is offline

Authorized User

Join Date: Jul 2004

Posts: 10

Thanks: 0

Thanked 0 Times in 0 Posts

Default

How to write the data in to excel file

How to write the search results from SQL Server into the excel file. I need the best and fastest way of doing it.

Old

October 13th, 2004, 11:34 AM

bmains

bmains is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 1,998

Thanks: 0

Thanked 3 Times in 3 Posts

Default

http://www.dotnetjohn.com/articles.aspx?articleid=54

This article is on reading, but it is just as easy to write to. Take the results from a dataset and do a SQLDataAdapter.Update(DataSet1).

Brian

Old

October 13th, 2004, 01:39 PM

Greg Griffiths Greg Griffiths is offline

Greg Griffiths is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 344

Thanks: 0

Thanked 1 Time in 1 Post

Default

also worth checking out is http://www.greggriffiths.org/webdev/both/excel/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Read and write excel file using VB6	sjlsysprg1	VB How-To	14	September 21st, 2011 01:21 PM
How Silverlight write data to XML file?	tomalani	Other Programming Languages	0	May 15th, 2008 07:31 AM
How to write data on ms excel	azharrahi	ASP.NET 1.x and 2.0 Application Design	0	January 11th, 2008 08:35 AM
Write an Excel File.	dpkbahuguna	ASP.NET 2.0 Basics	4	March 9th, 2007 05:20 AM
write multi-sheet Excel w/o Excel.Application	manmoth	Classic ASP Components	2	November 22nd, 2005 10:56 AM