Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
.NET Framework 2.0 For discussion of the Microsoft .NET Framework 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the .NET Framework 2.0 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
  #1 (permalink)  
Old February 19th, 2008, 08:08 AM
Registered User
 
Join Date: Mar 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Excel download in .net web appln

Hi,

I’m developing a asp.net application wherein I have a requirement to have a excel report download feature. The data from the database will be manipulated and filled in the excel file on click of a button at runtime and user should be able to download it.

Please let me know the best possible option to do it. I do not want to the COM interop.

Thanks in advance.

  #2 (permalink)  
Old February 19th, 2008, 09:00 AM
samjudson's Avatar
Friend of Wrox
Points: 8,687, Level: 40
Points: 8,687, Level: 40 Points: 8,687, Level: 40 Points: 8,687, Level: 40
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2007
Location: Newcastle, , United Kingdom.
Posts: 2,128
Thanks: 1
Thanked 189 Times in 188 Posts
Default

There is an example in this post here:

http://p2p.wrox.com/topic.asp?TOPIC_ID=65901

/- Sam Judson : Wrox Technical Editor -/
  #3 (permalink)  
Old February 20th, 2008, 07:29 AM
Registered User
 
Join Date: Mar 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply.

But the gridview object is rendered and used along with the datatable in the referred code.My excel file will contain multiple sheets and the no. of sheets are not fixed. At runtime I need to generate the excel file.

Regards,
K****ij

  #4 (permalink)  
Old February 20th, 2008, 07:34 AM
samjudson's Avatar
Friend of Wrox
Points: 8,687, Level: 40
Points: 8,687, Level: 40 Points: 8,687, Level: 40 Points: 8,687, Level: 40
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2007
Location: Newcastle, , United Kingdom.
Posts: 2,128
Thanks: 1
Thanked 189 Times in 188 Posts
Default

This really is the kind of this you should have checked google for first, as it is a very frequent request.

Top result for "multiple sheet excel spreadsheet asp.net" google search gives me this:

http://forums.asp.net/t/1207027.aspx

/- Sam Judson : Wrox Technical Editor -/


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to hide appln in TaskManager chanti VB How-To 3 November 5th, 2007 12:33 AM
Integrating from of Vb.net with C# appln pady123 C# 2 September 27th, 2007 07:50 PM
Proxy Authentication Required in ASP.Net appln. rajbiswas76 General .NET 2 March 2nd, 2007 09:12 AM
Problem after installing the setup of a .NET appln sarboo General .NET 0 June 20th, 2006 04:02 PM
Biginer VBA Book for Excel - Download roomi Excel VBA 0 January 15th, 2005 05:21 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.