Steve Lowry
asked on
Adjust size of Excel Web Page to fill the screen.
When I publish an entire Excel workbook as a web page, it fills about 3/4 of the screen with white space around it. I cannot find a way to adjust the size of the web page. I have Microsoft FrontPage available to make changes to the HTML code, but I do not know what to change to make the web page fill the screen.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
thanks for this try
i changed
<object
id="testbook_13424_Spreads heet"
classid="CLSID:0002E559-00 00-0000-C0 00-0000000 00046" width="100%" height="288">
i changed
<object
id="testbook_13424_Spreads
classid="CLSID:0002E559-00
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=FrontPage.Editor.Document>
<meta name=Generator content="Microsoft FrontPage 6.0">
</head>
<body>
<!--[if !excel]> <![endif]-->
<!--The following information was generated by Microsoft Office Excel's Publish
as Web Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->
<div id="testbook_13424" align=center x:publishsource="Excel">
<object
id="testbook_13424_Spreadsheet"
classid="CLSID:0002E559-0000-0000-C000-000000000046" width="100%" height="288">
<param name=DisplayTitleBar value=0>
<param name=Autofit value=-1>
<param name=DataType value=XMLDATA>
<param name=XMLData
value="<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?><ss:Workbook
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<x:ExcelWorkbook>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ActiveSheet>0</x:ActiveSheet>
</x:ExcelWorkbook>
<ss:Styles>
<ss:Style ss:ID="Default">
<ss:Alignment ss:Horizontal="Automatic" ss:Rotate="0.0" ss:Vertical="Bottom"
ss:ReadingOrder="Context"/>
<ss:Borders>
</ss:Borders>
<ss:Font ss:FontName="Arial" ss:Size="10" ss:Color="Automatic" ss:Bold="0"
ss:Italic="0" ss:Underline="None"/>
<ss:Interior ss:Color="Automatic" ss:Pattern="None"/>
<ss:NumberFormat ss:Format="General"/>
<ss:Protection ss:Protected="1"/>
</ss:Style>
<ss:Style ss:ID="wc03CF96A0">
<ss:Alignment ss:Vertical="Bottom"/>
<ss:Font/>
<ss:Interior ss:Color="#FF6600" ss:Pattern="Solid"/>
</ss:Style>
<ss:Style ss:ID="wc03CFC4A8">
<ss:Alignment ss:Vertical="Bottom"/>
<ss:Font/>
<ss:Interior ss:Color="#FFFF00" ss:Pattern="Solid"/>
</ss:Style>
</ss:Styles>
<c:ComponentOptions>
<c:Label>
<c:Caption>Microsoft Office Spreadsheet</c:Caption>
</c:Label>
<c:SpreadsheetAutoFit/>
<c:MaxHeight>80</c:MaxHeight>
<c:MaxWidth>100%</c:MaxWidth>
<c:NextSheetNumber>1</c:NextSheetNumber>
</c:ComponentOptions>
<x:WorkbookOptions>
<c:OWCVersion>11.0.0.8166 </c:OWCVersion>
<x:Height>7620</x:Height>
<x:Width>15240</x:Width>
</x:WorkbookOptions>
<ss:Worksheet ss:Name="Sheet1">
<x:WorksheetOptions>
<x:Selected/>
<x:ViewableRange>R1:R262144</x:ViewableRange>
<x:Selection>R1C1</x:Selection>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x:ProtectContents>False</x:ProtectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="21"
ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="12.75">
<ss:Row>
<ss:Cell>
<ss:Data ss:Type="String">This is Sheet 1 of the test workbook.</ss:Data>
</ss:Cell>
</ss:Row>
<ss:Row ss:Index="4">
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
<ss:Cell ss:StyleID="wc03CF96A0"/>
</ss:Row>
</ss:Table>
</ss:Worksheet>
<ss:Worksheet ss:Name="Sheet2">
<x:WorksheetOptions>
<x:ViewableRange>R1:R262144</x:ViewableRange>
<x:Selection>R1C1</x:Selection>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x:ProtectContents>False</x:ProtectContents>
</x:WorksheetOptions>
<c:WorksheetOptions>
</c:WorksheetOptions>
<ss:Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="9"
ss:DefaultColumnWidth="48.0" ss:DefaultRowHeight="12.75">
<ss:Row>
<ss:Cell>
<ss:Data ss:Type="String">This is Sheet 2 of the test workbook</ss:Data>
</ss:Cell>
</ss:Row>
<ss:Row ss:Index="4">
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
</ss:Row>
<ss:Row>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
<ss:Cell ss:StyleID="wc03CFC4A8"/>
</ss:Row>
</ss:Table>
</ss:Worksheet>
<o:DocumentProperties>
<o:Author> Chemical Company</o:Author>
<o:LastAuthor> Chemical Company</o:LastAuthor>
<o:Created>2008-10-14T14:31:34Z</o:Created>
<o:LastSaved>2008-10-15T11:59:21Z</o:LastSaved>
<o:Company> Chemical Company</o:Company>
<o:Version>11.8132</o:Version>
</o:DocumentProperties>
<o:OfficeDocumentSettings>
<o:RelyOnVML/>
<o:AllowPNG/>
<o:PixelsPerInch>120</o:PixelsPerInch>
<o:TargetScreenSize>1280x1024</o:TargetScreenSize>
</o:OfficeDocumentSettings>
</ss:Workbook>
">
<param name="AllowPropertyToolbox" value="-1">
<param name="Calculation" value="-4105">
<param name="Caption" value="Microsoft Office Spreadsheet">
<param name="DisplayColumnHeadings" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScrollBar" value="-1">
<param name="DisplayOfficeLogo" value="-1">
<param name="DisplayPropertyToolbox" value="0">
<param name="DisplayRowHeadings" value="-1">
<param name="DisplayToolbar" value="-1">
<param name="DisplayVerticalScrollBar" value="-1">
<param name="DisplayWorkbookTabs" value="-1">
<param name="EnableEvents" value="-1">
<param name="MaxHeight" value="80">
<param name="MaxWidth" value="100%">
<param name="MoveAfterReturn" value="-1">
<param name="MoveAfterReturnDirection" value="-4121">
<param name="RightToLeft" value="0">
<param name="ScreenUpdating" value="-1">
<param name="LockedDown" value="0">
<param name="ConnectedToChart" value="0">
<param name="DefaultQueryOnLoad" value="-1">
<param name="EnableUndo" value="-1">
<p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web
page interactively, you must have Microsoft® Internet Explorer 5.01 Service
Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components.</p>
<p style='margin-top:100;font-family:Arial;font-size:8.0pt'>See the <a
href="http://r.office.microsoft.com/r/rlidmsowcpub?clid=1033&p1=Excel">Microsoft
Office Web site</a> for more information.</p>
</object></div>
<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>
</html>
ASKER
The change did make the web page wider, but it has very little height. I have tried to change the height value, but it has not made a difference.
Also, with the width and height statement located between the DIVs, won't I lose that formatting when I republish the web page?
Thanks.
Also, with the width and height statement located between the DIVs, won't I lose that formatting when I republish the web page?
Thanks.
possible but i am afraid we cannot have everything....
ASKER
The more I look into this issue, it looks like I am going to get what I am going to get. Even though I would like more control, I can live with the formatting as it is.
I really appreciate your time in looking at this.
Thanks.
Steve
I really appreciate your time in looking at this.
Thanks.
Steve
ASKER
Thanks for your help.
Steve
Open in new window
testbook.xlsScreenprint-of-Testbook-displaye.doc