You can also very quickly build a solution utilizing XML data maps in
Excel. In this case you open an Excel spreadsheet on the client and
retrieve the XML data from a URL, which can either be link a to the
HttpGet interface of an ASP.NET Web Service or to a SQLXML HTTP
endpoint.
Take a look at
http://msdn.microsoft.com/library/de.../en-us/odc_xl2
003_ta/html/odc_xlexpen.asp to get you started and feel free to come
back with follow up questions.
Christoph Schittko
MVP XML
http://weblogs.asp.net/cschittko
[color=blue]
> -----Original Message-----
> From: Dino Chiesa [Microsoft] [mailto:dinoch@online.microsoft.com]
> Posted At: Thursday, December 09, 2004 10:34 AM
> Posted To: microsoft.public.dotnet.xml
> Conversation: XML to Excel
> Subject: Re: XML to Excel
>
> be careful.I believe using VSTO within ASP.NET qualifies as automation[/color]
of[color=blue]
> Office, therefore this article applies :
>
http://support.microsoft.com/kb/257757
>
> There is a group covering VSTO - see[/color]
microsoft.public.vsnet.vstools.office[color=blue]
> .
>
> You can build apps that automate office without VSTO (there are[/color]
examples[color=blue]
> in
> the .NET SDK v1.1, see
> %netsdk%\Samples\Technologies\Interop\Applications \Office\Excel ) ,[/color]
but[color=blue]
> it's
> easier if you use VSTO.
>
> It is possible to create or update an XLS file from .NET (including
> ASP.NET)
> without using Office automation. An Excel sheet can be accessed via
> OLEDB.
> Example:
>
http://cheeso.members.winisp.net/src...file=CopyData-
> SqlToExcel-TwoOledbConnections.cs
>
> -D
>
>
> "Oleg Tkachenko [MVP]" <oleg@NO!SPAM!PLEASEtkachenko.com> wrote in[/color]
message[color=blue]
> news:etP$fl32EHA.1404@TK2MSFTNGP11.phx.gbl...[color=green]
> > Marwa Bahaa wrote:
> >[color=darkred]
> >> I have an application using ASP.net, and in this application the[/color][/color][/color]
user[color=blue][color=green][color=darkred]
> >> will
> >> have the choice to download data from Sql Server to excel[/color][/color][/color]
sheet,this[color=blue]
> will[color=green][color=darkred]
> >> be
> >> done using code only
> >> could any one help me how to do this plzzzz???[/color]
> >
> > Take a look at
> > "Visual Studio Tools for the Microsoft Office System, Version 2003
> > Technical Articles" at
> >
http://msdn.microsoft.com/library/de...l=/library/en-[/color]
> us/odc_2003_ta/html/odc_landvsto_ta.asp[color=green]
> >
> > --
> > Oleg Tkachenko [XML MVP]
> >
http://blog.tkachenko.com[/color][/color]
