By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,499 Members | 1,303 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,499 IT Pros & Developers. It's quick & easy.

XML to Excel

P: n/a
HI all,
I have an application using ASP.net, and in this application the user will
have the choice to download data from Sql Server to excel sheet,this will be
done using code only
could any one help me how to do this plzzzz???


Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Marwa Bahaa wrote:
I have an application using ASP.net, and in this application the user will
have the choice to download data from Sql Server to excel sheet,this will be
done using code only
could any one help me how to do this plzzzz???


Take a look at
"Visual Studio Tools for the Microsoft Office System, Version 2003
Technical Articles" at
http://msdn.microsoft.com/library/de...andvsto_ta.asp

--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com
Nov 12 '05 #2

P: n/a
be careful.I believe using VSTO within ASP.NET qualifies as automation of
Office, therefore this article applies :
http://support.microsoft.com/kb/257757

There is a group covering VSTO - see microsoft.public.vsnet.vstools.office .

You can build apps that automate office without VSTO (there are examples in
the .NET SDK v1.1, see
%netsdk%\Samples\Technologies\Interop\Applications \Office\Excel ) , but 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...Connections.cs

-D
"Oleg Tkachenko [MVP]" <oleg@NO!SPAM!PLEASEtkachenko.com> wrote in message
news:et**************@TK2MSFTNGP11.phx.gbl...
Marwa Bahaa wrote:
I have an application using ASP.net, and in this application the user
will
have the choice to download data from Sql Server to excel sheet,this will
be
done using code only
could any one help me how to do this plzzzz???


Take a look at
"Visual Studio Tools for the Microsoft Office System, Version 2003
Technical Articles" at
http://msdn.microsoft.com/library/de...andvsto_ta.asp

--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com

Nov 12 '05 #3

P: n/a

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
-----Original Message-----
From: Dino Chiesa [Microsoft] [mailto:di****@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 of Office, therefore this article applies :
http://support.microsoft.com/kb/257757

There is a group covering VSTO - see microsoft.public.vsnet.vstools.office .

You can build apps that automate office without VSTO (there are examples in
the .NET SDK v1.1, see
%netsdk%\Samples\Technologies\Interop\Applications \Office\Excel ) , but 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 message news:et**************@TK2MSFTNGP11.phx.gbl...
Marwa Bahaa wrote:
I have an application using ASP.net, and in this application the user will
have the choice to download data from Sql Server to excel
sheet,this
will be
done using code only
could any one help me how to do this plzzzz???


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-

us/odc_2003_ta/html/odc_landvsto_ta.asp

--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com

Nov 12 '05 #4

P: n/a

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
-----Original Message-----
From: Dino Chiesa [Microsoft] [mailto:di****@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 of Office, therefore this article applies :
http://support.microsoft.com/kb/257757

There is a group covering VSTO - see microsoft.public.vsnet.vstools.office .

You can build apps that automate office without VSTO (there are examples in
the .NET SDK v1.1, see
%netsdk%\Samples\Technologies\Interop\Applications \Office\Excel ) , but 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 message news:et**************@TK2MSFTNGP11.phx.gbl...
Marwa Bahaa wrote:
I have an application using ASP.net, and in this application the user will
have the choice to download data from Sql Server to excel
sheet,this
will be
done using code only
could any one help me how to do this plzzzz???


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-

us/odc_2003_ta/html/odc_landvsto_ta.asp

--
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.