|
 |
aspx thread: Export Datagrid to MS Excel
Message #1 by Ugo Bachetti <ubachetti@h...> on Thu, 7 Mar 2002 11:45:49 -0500
|
|
Hi,
Can anyone help?
I have created a ASP.NET page that builds a datagrid from an SQL database.
From there I have inserted a button called Export that once clicked I would
like to have the data from the datagrid exported to an Excel spreadsheet and
open the Excel application with the data displayed.
Can someone please guide me through this.
Thanks in advance.
Ugo
Message #2 by "Minh T. Nguyen" <nguyentriminh@y...> on Thu, 7 Mar 2002 09:31:47 -0800
|
|
Ugo,
See: http://p2p.wrox.com/view.asp?list=c_sharp&id=154193
I have used the above trick many times with classic ASP web
applications.
Minh.
-----Original Message-----
From: Ugo Bachetti [mailto:ubachetti@h...]
Sent: Thursday, March 07, 2002 8:46 AM
To: ASP+
Subject: [aspx] Export Datagrid to MS Excel
Hi,
Can anyone help?
I have created a ASP.NET page that builds a datagrid from an SQL
database. From there I have inserted a button called Export that once
clicked I would like to have the data from the datagrid exported to an
Excel spreadsheet and open the Excel application with the data
displayed. Can someone please guide me through this.
Thanks in advance.
Ugo
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Message #3 by "Li, Fang" <fang@c...> on Thu, 7 Mar 2002 14:30:34 -0500
|
|
I use a component to create a temperate Excel file at server then use
Response.Redirect(excelpath) to sent back to client.
Another article http://www.aspalliance.com/articles/CrystalReportVSNet.aspx
Said you can export your data to Excel using Crystal Report.
I am not sure this is the best way. If you get some better way please let me
know too.
Fang
-----Original Message-----
From: Ugo Bachetti [mailto:ubachetti@h...]
Sent: Thursday, March 07, 2002 11:46 AM
To: ASP+
Subject: [aspx] Export Datagrid to MS Excel
Hi,
Can anyone help?
I have created a ASP.NET page that builds a datagrid from an SQL database.
From there I have inserted a button called Export that once clicked I would
like to have the data from the datagrid exported to an Excel spreadsheet and
open the Excel application with the data displayed.
Can someone please guide me through this.
Thanks in advance.
Ugo
|
|
|
View Cart
