Problem with Page Orientation of Excel Workbook While Streaming MIME Content

[Yelena Kaplun]

Hi,
I'm trying to customize print settings while streaming HTML content into
Excel. I'm using ASP.NET 1.1 and Excel 2003.
While some printer settings like Margins are working correctly, I cannot
change the Page Orientation to Landscape: mso-page-orientation:lan dscape;.
I tried to produce the Excel Page, save it as HTML, open in text editor and
then copy and paste Excel generated settings. But it did not help.
If anybody resolved this problem before please respond. Your reply is
greatly appreciated.
I'm setting content type as following:
Response.Clear( )

Response.Charse t = ""

Response.Conten tType = "applicatio n/vnd.ms-excel"

Response.AddHea der("Content-Disposition", "attachment ;
filename=Campai gnReports.xls")

And then using <style> and XML tags to change the settings:

<style>

<!--table

{mso-displayed-decimal-separator:"\.";

mso-displayed-thousand-separator:"\,"; }

@page

{margin:1.0in .5in 1.0in .5in;

mso-header-margin:.5in;

mso-footer-margin:.5in;

mso-page-orientation:lan dscape;}

tr

{mso-height-source:auto;}

col

{mso-width-source:auto;}

br

{mso-data-placement:same-cell;}

-->

</style>

<!--[if gte mso 9]><xml>

<x:ExcelWorkboo k>

<x:ExcelWorkshe ets>

<x:ExcelWorkshe et>

<x:Name>Campaig nReports 1 </x:Name>

<x:WorksheetOpt ions>

<x:Print>

<x:ValidPrinter Info/>

<x:Scale>75</x:Scale>

<x:HorizontalRe solution>1200</x:HorizontalRes olution>

<x:VerticalReso lution>1200</x:VerticalResol ution>

</x:Print>

<x:Selected/>

<x:DoNotDisplay Gridlines/>

<x:ProtectConte nts>False</x:ProtectConten ts>

<x:ProtectObjec ts>False</x:ProtectObject s>

<x:ProtectScena rios>False</x:ProtectScenar ios>

</x:WorksheetOpti ons>

</x:ExcelWorkshee t>

</x:ExcelWorkshee ts>

<x:WindowHeight >8700</x:WindowHeight>

<x:WindowWidth> 15195</x:WindowWidth>

<x:WindowTopX>0 </x:WindowTopX>

<x:WindowTopY>1 20</x:WindowTopY>

<x:ProtectStruc ture>False</x:ProtectStruct ure>

<x:ProtectWindo ws>False</x:ProtectWindow s>

</x:ExcelWorkbook >

</xml><![endif]-->

Thanks,

Yelena

[Yelena Kaplun]

Just an additional info to a previous message: print settings are working
fine for classic ASP version, but in ASP.NET page only margins are changed.
The Landscape and Scale remain unchanged.
"Yelena Kaplun" <ye**********@h otmail.com> wrote in message
news:eS******** ********@TK2MSF TNGP15.phx.gbl. ..

Hi,
I'm trying to customize print settings while streaming HTML content into
Excel. I'm using ASP.NET 1.1 and Excel 2003.
While some printer settings like Margins are working correctly, I cannot
change the Page Orientation to Landscape: mso-page-orientation:lan dscape;.
I tried to produce the Excel Page, save it as HTML, open in text editor and then copy and paste Excel generated settings. But it did not help.
If anybody resolved this problem before please respond. Your reply is
greatly appreciated.
I'm setting content type as following:
Response.Clear( )

Response.Charse t = ""

Response.Conten tType = "applicatio n/vnd.ms-excel"

Response.AddHea der("Content-Disposition", "attachment ;
filename=Campai gnReports.xls")

And then using <style> and XML tags to change the settings:

<style>

<!--table

{mso-displayed-decimal-separator:"\.";

mso-displayed-thousand-separator:"\,"; }

@page

{margin:1.0in .5in 1.0in .5in;

mso-header-margin:.5in;

mso-footer-margin:.5in;

mso-page-orientation:lan dscape;}

tr

{mso-height-source:auto;}

col

{mso-width-source:auto;}

br

{mso-data-placement:same-cell;}

-->

</style>

<!--[if gte mso 9]><xml>

<x:ExcelWorkboo k>

<x:ExcelWorkshe ets>

<x:ExcelWorkshe et>

<x:Name>Campaig nReports 1 </x:Name>

<x:WorksheetOpt ions>

<x:Print>

<x:ValidPrinter Info/>

<x:Scale>75</x:Scale>

<x:HorizontalRe solution>1200</x:HorizontalRes olution>

<x:VerticalReso lution>1200</x:VerticalResol ution>

</x:Print>

<x:Selected/>

<x:DoNotDisplay Gridlines/>

<x:ProtectConte nts>False</x:ProtectConten ts>

<x:ProtectObjec ts>False</x:ProtectObject s>

<x:ProtectScena rios>False</x:ProtectScenar ios>

</x:WorksheetOpti ons>

</x:ExcelWorkshee t>

</x:ExcelWorkshee ts>

<x:WindowHeight >8700</x:WindowHeight>

<x:WindowWidth> 15195</x:WindowWidth>

<x:WindowTopX>0 </x:WindowTopX>

<x:WindowTopY>1 20</x:WindowTopY>

<x:ProtectStruc ture>False</x:ProtectStruct ure>

<x:ProtectWindo ws>False</x:ProtectWindow s>

</x:ExcelWorkbook >

</xml><![endif]-->

Thanks,

Yelena

[Jeff Horne]

Just an additional info to a previous message: print settings are working fine for classic ASP version, but in ASP.NET page only margins are changed. The Landscape and Scale remain unchanged.

I am encourtering the same issue. Were you able to discover a soultion?

Thanks,

Jeff