473,320 Members | 2,110 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Create an XLS file from ASP

Hi all,

I have an ASP process that creates 'reports'. At the moment these reports
are output to a semi-comma delimmeted text file that I open in XLS. I then
run a macro that formats the page correctly for printing.

What I would really like to happen is the ASP page creates either an XLS of
..DOC file that would open in excel (or word) with the contents pre-formatted
ready to print.

I have been looking, but have been unable to find anything suitable on this.

Could someone out there point me in the right direction.

Many thanks in advance,

Bill.
Jul 19 '05 #1
6 1797
How about Reporting Services?
http://www.microsoft.com/sql/reporting/default.asp

--
http://www.aspfaq.com/
(Reverse address to reply.)


"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eI**************@tk2msftngp13.phx.gbl...
Hi all,

I have an ASP process that creates 'reports'. At the moment these reports
are output to a semi-comma delimmeted text file that I open in XLS. I then
run a macro that formats the page correctly for printing.

What I would really like to happen is the ASP page creates either an XLS of .DOC file that would open in excel (or word) with the contents pre-formatted ready to print.

I have been looking, but have been unable to find anything suitable on this.
Could someone out there point me in the right direction.

Many thanks in advance,

Bill.

Jul 19 '05 #2
Thanks Araron,

I'm not using SQL server, just access and can only use technology 'freely'
available, unfortunately.

Bill.
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:eW**************@TK2MSFTNGP12.phx.gbl...
How about Reporting Services?
http://www.microsoft.com/sql/reporting/default.asp

--
http://www.aspfaq.com/
(Reverse address to reply.)


"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eI**************@tk2msftngp13.phx.gbl...
Hi all,

I have an ASP process that creates 'reports'. At the moment these reports are output to a semi-comma delimmeted text file that I open in XLS. I then run a macro that formats the page correctly for printing.

What I would really like to happen is the ASP page creates either an XLS

of
.DOC file that would open in excel (or word) with the contents

pre-formatted
ready to print.

I have been looking, but have been unable to find anything suitable on

this.

Could someone out there point me in the right direction.

Many thanks in advance,

Bill.


Jul 19 '05 #3
"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eI**************@tk2msftngp13.phx.gbl...
Hi all,

I have an ASP process that creates 'reports'. At the moment these reports
are output to a semi-comma delimmeted text file that I open in XLS. I then
run a macro that formats the page correctly for printing.

What I would really like to happen is the ASP page creates either an XLS of .DOC file that would open in excel (or word) with the contents pre-formatted ready to print.

I have been looking, but have been unable to find anything suitable on this.
Could someone out there point me in the right direction.


Put the data into an HTML table instead:
http://support.microsoft.com/?kbid=301044

To get the formatting right, create an Excel sheet the way you want it to
look and save it as HTML - then "reverse engineer" the resulting HTML code
into your ASP.

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

Jul 19 '05 #4
Thanks Tom,

Funny you said that, I was just looking at that this very moment. My god
there is some extra data to put into the file to get the desired result.

Cheers, Bill.
"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:c9*********@kcweb01.netnews.att.com...
"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eI**************@tk2msftngp13.phx.gbl...
Hi all,

I have an ASP process that creates 'reports'. At the moment these reports are output to a semi-comma delimmeted text file that I open in XLS. I then run a macro that formats the page correctly for printing.

What I would really like to happen is the ASP page creates either an XLS of
.DOC file that would open in excel (or word) with the contents

pre-formatted
ready to print.

I have been looking, but have been unable to find anything suitable on

this.

Could someone out there point me in the right direction.


Put the data into an HTML table instead:
http://support.microsoft.com/?kbid=301044

To get the formatting right, create an Excel sheet the way you want it to
look and save it as HTML - then "reverse engineer" the resulting HTML code
into your ASP.

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running

IIS http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

Jul 19 '05 #5
update your knowledge about 'free' databases then :)
http://www.microsoft.com/sql/msde/default.asp

And while this msde is a stripped down SQL server, you -still- have -much-
better performance and reliability than when you use Access.

--
compatible web farm Session replacement for Asp and Asp.Net
http://www.nieropwebconsult.nl/asp_session_manager.htm

"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eV**************@TK2MSFTNGP09.phx.gbl...
Thanks Araron,

I'm not using SQL server, just access and can only use technology 'freely'
available, unfortunately.

Bill.
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:eW**************@TK2MSFTNGP12.phx.gbl...
How about Reporting Services?
http://www.microsoft.com/sql/reporting/default.asp

--
http://www.aspfaq.com/
(Reverse address to reply.)


"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eI**************@tk2msftngp13.phx.gbl...
Hi all,

I have an ASP process that creates 'reports'. At the moment these reports are output to a semi-comma delimmeted text file that I open in XLS. I then run a macro that formats the page correctly for printing.

What I would really like to happen is the ASP page creates either an
XLS of
.DOC file that would open in excel (or word) with the contents

pre-formatted
ready to print.

I have been looking, but have been unable to find anything suitable on

this.

Could someone out there point me in the right direction.

Many thanks in advance,

Bill.




Jul 19 '05 #6
http://support.microsoft.com/default...b;en-us;169377

http://support.microsoft.com/default...b;en-us;193332

http://support.microsoft.com/default...b;EN-US;199841

http://support.microsoft.com/default...43&Product=xlw

The last two are probably the best for you. But the second is pretty good also.

--
George Hester
__________________________________
"William E Hatto" <xx***********@bigpond.net.au> wrote in message news:Ou**************@TK2MSFTNGP12.phx.gbl...
Thanks Tom,

Funny you said that, I was just looking at that this very moment. My god
there is some extra data to put into the file to get the desired result.

Cheers, Bill.


"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:c9*********@kcweb01.netnews.att.com...
"William E Hatto" <xx***********@bigpond.net.au> wrote in message
news:eI**************@tk2msftngp13.phx.gbl...
Hi all,

I have an ASP process that creates 'reports'. At the moment these reports are output to a semi-comma delimmeted text file that I open in XLS. I then run a macro that formats the page correctly for printing.

What I would really like to happen is the ASP page creates either an XLS

of
.DOC file that would open in excel (or word) with the contents

pre-formatted
ready to print.

I have been looking, but have been unable to find anything suitable on

this.

Could someone out there point me in the right direction.


Put the data into an HTML table instead:
http://support.microsoft.com/?kbid=301044

To get the formatting right, create an Excel sheet the way you want it to
look and save it as HTML - then "reverse engineer" the resulting HTML code
into your ASP.

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running

IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/


Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Frank Millman | last post by:
Hi all I need to generate potentially large reports from a database, and I want to offer the option of print preview before actually printing (using wxPython). I figure that the best way to...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
4
by: I_AM_DON_AND_YOU? | last post by:
There is one more problem I am facing but didn't get the solution. In my Setup Program I am not been able to create 2 things (when the program is intalled on the client machine ) : (1) create...
5
by: Michael Sperlle | last post by:
Is it possible? Bestcrypt can supposedly be set up on linux, but it seems to need changes to the kernel before it can be installed, and I have no intention of going through whatever hell that would...
8
by: barb | last post by:
So that the world at large benefits from our efforts, here is one fully documented way to use Windows Irfanview freeware to create thumbnail web galleries (http://www.irfanview.com). STEP 1:...
23
by: sandy | last post by:
I need (okay, I want) to make a dynamic array of my class 'Directory', within my class Directory (Can you already smell disaster?) Each Directory can have subdirectories so I thought to put these...
4
by: Vlad | last post by:
I am having problems using the file.create method within a function that is called when looping through an array of filepaths. If I call my function with a hardcoded file path --C:\Temp.txt the...
3
by: sanghavi | last post by:
how to create a set up project in vb.net..how to run an application on a different machine
3
by: brook | last post by:
hey all - i´m new to php and having trouble writing a simple code which should create a file. here is the most simplified version: <?php $content = "my content"; $path = "test.txt";...
15
by: lxyone | last post by:
Using a flat file containing table names, fields, values whats the best way of creating html pages? I want control over the html pages ie 1. layout 2. what data to show 3. what controls to...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.