sending ASP output to a excel file - ASP / Active Server Pages

mvr

Hi all

I have a asp page which will get the data from multiple tables (with
functions and procedures)and display data in HTML tables <TABLE> on ASP
page.
Is there any way we can create a excel file from the output of this ASP
file.
I know how to export if this information on ASP page is coming from single
query from a database table.
Any suggestions???

Thanks
mvr

Jan 30 '06 #1

Subscribe Reply

3172

dNagel

http://groups.google.com/group/micro...35030dc?hl=en&

D.

mvr wrote:

Hi all

I have a asp page which will get the data from multiple tables (with
functions and procedures)and display data in HTML tables <TABLE> on ASP
page.
Is there any way we can create a excel file from the output of this ASP
file.
I know how to export if this information on ASP page is coming from single
query from a database table.
Any suggestions???

Thanks
mvr

Jan 31 '06 #2

lyma

You should use a third party tool if you want to have multiple worsheet
and a real Excel Biff format...

Let have a look at those 2 goods one :
- DypsXLS from Dypso BackOffice
- ExcelWritter from SoftArtisan

Jan 31 '06 #3

Similar topics

4925

XSL output and/or encoding question..

by: Beowulf | last post by:

Hi, I have an XML file generated by a third party (and therefore unchangable) program. 1st line in it is <?xml version="1.0" encoding="us-ascii"?> and down in the depths of the xml I have a...

.NET Framework

5267

Excel, DB2, AS400 (retriving data and sending into Excell)

by: Niyazi | last post by:

Hi, I have to retrieve a data from AS400 DB2 and after working with data I have to export into one of existing Excel file. I can connect into specific library in AS400 DB2 using AS400...

.NET Framework

2285

Can SQLServer produce Excel Spreadsheet output ?

by: cpeters5 | last post by:

Deaa group, I am using SQLServer 2000 in an XP Sp2. I would like to do the following: I have a program running on a database server that generates some data which are loaded to the database....

Microsoft SQL Server

2144

Output Excel File (dhl)

by: David | last post by:

(dhl)Using 2K. I have a query I want to export to excel. There are 35,000+ lines for this query. I created a macro to run on a schedule to export the excel file to a network shared drive. I can...

Microsoft Access / VBA

11611

Create Access, Excel and .dbf output file from DataSet using C#

by: tkaleb | last post by:

I have to create output file in a text, MS Access, MS Excel and .dbf format from C# Win/ADO.NET application. Data are collected in DataSet and there is no problem to make text file. However, I have...

C# / C Sharp

2139

Sending xls file from Server to Client via asp.net

by: Lars Netzel | last post by:

I have an XLS file that I try to send to the webclient via ASP.NET. When sending I use this code... Response.ClearContent() Response.ClearHeaders() Response.ContentType =...

ASP.NET

3277

Output to Excel 2007

by: =?Utf-8?B?ZGlzcGxheW5hbWU=?= | last post by:

The following code used to outputs to Excel 2003 fine. Do I need to change it to output to Excel 2007? <% Response.ContentType = "application/vnd.ms-excel" Response.AddHeader...

ASP / Active Server Pages

2900

output buffering, parse error unexpected t_string

by: JRough | last post by:

I'm trying to use output buffering to cheat so i can print to excel which is called later than this header(). header("Content-type: application/xmsdownload"); header("Content-Disposition:...

PHP

1670

Reformatting Excel Files and sending output to notepad

by: richie9648 | last post by:

Hi All Been attempting my spreadsheet conversion to notepad all morning without any luck and now very frustrated Could some of you good people in here help out if possible It seems very...

Visual Basic 4 / 5 / 6

7182

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

6906

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5490

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4611

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3110

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3106

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1430

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

672

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

316

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General