export sql query results to Excel

  • Thread starter Thread starter S. Justin Gengo
  • Start date Start date
Hi Dear Dica,

is it possible to generate an Exel file showing the results of an sql query
from an ASPX page?

Yes, Ofcourse;

here is the link

VB.Net
=====

HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
Visual Basic .NET
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

http://support.microsoft.com/default.aspx?scid=kb;en-us;308247

C#
===

HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
Visual C# .NET
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://support.microsoft.com/default.aspx?scid=kb;en-us;311194

For Anything and Everything, Please Let Me Know.

Bye
Venkat_KL
 
is it possible to generate an Exel file showing the results of an sql query
from an ASPX page?
 
Problem with these solutions and the print htmlt able solution is that
it is only good for very simple excel sheets that do not need to have
multiple pages or formulas in them.

There are commercial ASP.NET solutions for this, and I belive, if you have office
installed on the server you can (at least you could in classic ASP) instatiate
an Excel.Application object and operate on it.

I would guess you need to wrap the com object to be able to do that in .NET

PL.
 
Venkat_KL said:
Hi Dear Dica,

is it possible to generate an Exel file showing the results of an sql query
from an ASPX page?

Yes, Ofcourse;

here is the link

VB.Net
=====

HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
Visual Basic .NET
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

http://support.microsoft.com/default.aspx?scid=kb;en-us;308247

C#
===

HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
Visual C# .NET
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://support.microsoft.com/default.aspx?scid=kb;en-us;311194

For Anything and Everything, Please Let Me Know.

Bye
Venkat_KL
Click to expand...

perfect. thanks guys.
 
Back
Top