Create an XLS file from ASP

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

 

[Aaron [SQL Server MVP]]

How about Reporting Services?
http://www.microsoft.com/sql/reporting/default.asp

 

[Tom Kaminski [MVP]]

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.

 

[William E Hatto]

Thanks Araron,

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

Bill.

 

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

 

[Egbert Nierop \(MVP for IIS\)]

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.

 

[George Hester]

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

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

http://support.microsoft.com/default.aspx?scid=kb;EN-US;199841

http://support.microsoft.com/default.aspx?scid=kb;en-us;264143&Product=xlw

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