Formatting ASP Generated Excel Page

palagrim · Oct 11, 2005

Hi.

I'm having trouble formatting a generated excel page. I'm using

<code>

<% Response.ContentType = "application/vnd.ms-excel" %>

<HTML xmlns:x="urn:schemas-microsoft-com

ffice:excel">
<HEAD>
<style>

</style>

[ loop through record set and out put a html table ]

</code>
The page doesn't seem to format to landscape, plus I need the page to print on to one page without the end user having to select Fit-To-Page from the page layout menu.

Does anybody have any ideas?

Thanks in advance.

- Craig.

SatishPutcha · Oct 12, 2005

Try using CSS for printing

DNG had pointed me to this site and CSS was a great help in creating page settings while printing.

Regards
Satish

palagrim · Oct 12, 2005

Thanks for that... I managed to come up with a solution in the end. Used CSS to format the text / table so it was nice and small and then used ScriptX (available from

http://www.meadroid.com/ScriptX)

to force the page to print on landscape.

Not exactly what I wanted to do - but close enough for the end user.

Which to me is a result. ;-)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Formatting ASP Generated Excel Page

palagrim

Programmer

SatishPutcha

Programmer

palagrim

Programmer

Similar threads

Part and Inventory Search

Sponsor