Create an XLS file from ASP

  • Thread starter William E Hatto
  • Start date
W

William E Hatto

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.
 
T

Tom Kaminski [MVP]

William E Hatto said:
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.
 
W

William E Hatto

Thanks Araron,

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

Bill.
 
W

William E Hatto

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top