see07

Hello:
I’ve a web form containing a datagrid which data I need to export to an Excel sheet, I’m using RenderControl to extract data from datagrid, Response.ContentType = "application/vnd.ms-excel"; and Response.Write to show it into a web form, but I need instead data be opened directly by Excel as an Excel application with all its controls available.
I think it may be achieved using Excel OLE Automation, but there are not enough examples in the web.
Does somebody knows a link to an article explaining it, or have a suggestion to me?
I’ll appreciate it very much.
A.L.

__________________
<span style='color:red'>El Hombre que tiene Amigos, debe mostrarse Amigo...</span>

kurifu

I have not really done this before, but based on my limited knowledge of OLE automation, this does seem to be the correct approach. You can find a lot more information on this topic at http://www.thecodeproject.com.

Good luck.

__________________
Clifford Matthew Roche &lt;geek@cliffordroche.com&gt;
Web Hosting: http://www.crd-hosting.com
Consulting: http://www.crdev-consulting.com

tempest

You need to just find a way to export the data as an excel file, or maybe even try a CVS file and send HTTP headers saying that excel should open it.

__________________