Solved

Adjust size of Excel Web Page to fill the screen.

Posted on 2008-10-14
6
903 Views
Last Modified: 2013-12-24
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.
0
Comment
Question by:sxlowry
  • 3
  • 3
6 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 500 total points
ID: 22718949
if doing all in frontpage

look at line
<table width='100%' cellpadding='0' cellspacing='0' border='0' height='8'>

<html>
 
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
<meta name="Microsoft Border" content="b, default">
</head>
 
<body>
 
<p>
<object classid="clsid:0002E559-0000-0000-C000-000000000046" id="Spreadsheet1" width="100%">
	<param name="DataType" value="XMLDATA">
	<param name="XMLData" value="&lt;?xml version=&quot;1.0&quot;?&gt;
&lt;ss:Workbook xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;
 xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;
 xmlns:c=&quot;urn:schemas-microsoft-com:office:component:spreadsheet&quot;&gt;
 &lt;x:ExcelWorkbook&gt;
  &lt;x:ProtectStructure&gt;False&lt;/x:ProtectStructure&gt;
  &lt;x:ActiveSheet&gt;0&lt;/x:ActiveSheet&gt;
 &lt;/x:ExcelWorkbook&gt;
 &lt;ss:Styles&gt;
  &lt;ss:Style ss:ID=&quot;Default&quot;&gt;
   &lt;ss:Alignment ss:Horizontal=&quot;Automatic&quot; ss:Rotate=&quot;0.0&quot; ss:Vertical=&quot;Bottom&quot;
    ss:ReadingOrder=&quot;Context&quot;/&gt;
   &lt;ss:Borders&gt;
   &lt;/ss:Borders&gt;
   &lt;ss:Font ss:FontName=&quot;Arial&quot; ss:Size=&quot;10&quot; ss:Color=&quot;Automatic&quot; ss:Bold=&quot;0&quot;
    ss:Italic=&quot;0&quot; ss:Underline=&quot;None&quot;/&gt;
   &lt;ss:Interior ss:Color=&quot;Automatic&quot; ss:Pattern=&quot;None&quot;/&gt;
   &lt;ss:NumberFormat ss:Format=&quot;General&quot;/&gt;
   &lt;ss:Protection ss:Protected=&quot;1&quot;/&gt;
  &lt;/ss:Style&gt;
 &lt;/ss:Styles&gt;
 &lt;c:ComponentOptions&gt;
  &lt;c:Label&gt;
   &lt;c:Caption&gt;Microsoft Office Spreadsheet&lt;/c:Caption&gt;
  &lt;/c:Label&gt;
  &lt;c:MaxHeight&gt;80%&lt;/c:MaxHeight&gt;
  &lt;c:MaxWidth&gt;80%&lt;/c:MaxWidth&gt;
  &lt;c:NextSheetNumber&gt;4&lt;/c:NextSheetNumber&gt;
 &lt;/c:ComponentOptions&gt;
 &lt;x:WorkbookOptions&gt;
  &lt;c:OWCVersion&gt;11.0.0.8166         &lt;/c:OWCVersion&gt;
  &lt;x:Height&gt;7620&lt;/x:Height&gt;
  &lt;x:Width&gt;18838&lt;/x:Width&gt;
 &lt;/x:WorkbookOptions&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet1&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:Selected/&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
 &lt;/ss:Worksheet&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet2&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
 &lt;/ss:Worksheet&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet3&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
 &lt;/ss:Worksheet&gt;
&lt;/ss:Workbook&gt;
">
	<param name="AllowPropertyToolbox" value="-1">
	<param name="AutoFit" value="0">
	<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="DisplayTitleBar" value="0">
	<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="80%">
	<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">
	<table width='100%' cellpadding='0' cellspacing='0' border='0' height='8'><tr><td bgColor='#336699' height='25' width='10%'>&nbsp;</td><td bgColor='#666666'width='85%'><font face='Tahoma' color='white' size='4'><b>&nbsp; Missing: Microsoft Office Web Components</b></font></td></tr><tr><td bgColor='#cccccc' width='15'>&nbsp;</td><td bgColor='#cccccc' width='500px'><br> <font face='Tahoma' size='2'>This page requires the Microsoft Office Web Components.<p align='center'> <a href='E:/files/owc11/setup.exe'>Click here to install Microsoft Office Web Components.</a>.</p></font><p><font face='Tahoma' size='2'>This page also requires Microsoft Internet Explorer 5.01 or higher.</p><p align='center'><a href='http://www.microsoft.com/windows/ie/default.htm'> Click here to install the latest Internet Explorer</a>.</font><br>&nbsp;</td></tr></table></object>
</p>
 
</body>
 
</html>

Open in new window

0
 

Author Comment

by:sxlowry
ID: 22720507
Thanks for your reply.  I pasted the statement you provided in the location designated and did not get the results I wanted.  I have attached a test workbook,  and a screenprint of what I see when I open the web page in my browser (my screen resolution is 1280 x 1024).  Also included is the code for the .htm file that is generated when the workbook is published as a web page.  I will be republishing the web page when I make changes to the workbook, so please note the statement in the code about information between the DIV tags being replaced when republished.

Thanks for your help.
Steve
<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 Excel 11">
<link rel=File-List href="Pagetest_files/filelist.xml">
</head>
 
<body>
<!--[if !excel]>&nbsp;&nbsp;<![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">
 <param name=DisplayTitleBar value=false>
 <param name=Autofit value=true>
 <param name=DataType value=XMLData>
 <param name=XMLData
 value="&lt;?xml version=&quot;1.0&quot;?&gt;&#13;&#10;&lt;?mso-application progid=&quot;Excel.Sheet&quot;?&gt;&#13;&#10;&lt;Workbook xmlns=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;&#13;&#10; xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot;&#13;&#10; xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;&#13;&#10; xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;&#13;&#10; xmlns:html=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;&#13;&#10; &lt;DocumentProperties xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;&#13;&#10;  &lt;Author&gt; Chemical Company&lt;/Author&gt;&#13;&#10;  &lt;LastAuthor&gt; Chemical Company&lt;/LastAuthor&gt;&#13;&#10;  &lt;Created&gt;2008-10-14T14:31:34Z&lt;/Created&gt;&#13;&#10;  &lt;LastSaved&gt;2008-10-15T11:59:21Z&lt;/LastSaved&gt;&#13;&#10;  &lt;Company&gt; Chemical Company&lt;/Company&gt;&#13;&#10;  &lt;Version&gt;11.8132&lt;/Version&gt;&#13;&#10; &lt;/DocumentProperties&gt;&#13;&#10; &lt;OfficeDocumentSettings xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;&#13;&#10;  &lt;RelyOnVML/&gt;&#13;&#10;  &lt;AllowPNG/&gt;&#13;&#10;  &lt;PixelsPerInch&gt;120&lt;/PixelsPerInch&gt;&#13;&#10;  &lt;TargetScreenSize&gt;1280x1024&lt;/TargetScreenSize&gt;&#13;&#10; &lt;/OfficeDocumentSettings&gt;&#13;&#10; &lt;ExcelWorkbook xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;  &lt;PublishObjects&gt;&#13;&#10;   &lt;PublishObject&gt;&#13;&#10;    &lt;Id&gt;13424&lt;/Id&gt;&#13;&#10;    &lt;DivID&gt;testbook_13424&lt;/DivID&gt;&#13;&#10;    &lt;SourceType&gt;SourceWorkbook&lt;/SourceType&gt;&#13;&#10;    &lt;HtmlType&gt;HtmlCalc&lt;/HtmlType&gt;&#13;&#10;    &lt;Location x:HRef=&quot;G:\Engineering\LAB\AB3 and Q1 Logs\Pagetest.htm&quot;/&gt;&#13;&#10;   &lt;/PublishObject&gt;&#13;&#10;   &lt;AutoRepublish&gt;&#13;&#10;    &lt;DivID&gt;testbook_13424&lt;/DivID&gt;&#13;&#10;   &lt;/AutoRepublish&gt;&#13;&#10;  &lt;/PublishObjects&gt;&#13;&#10;  &lt;WindowHeight&gt;13035&lt;/WindowHeight&gt;&#13;&#10;  &lt;WindowWidth&gt;14955&lt;/WindowWidth&gt;&#13;&#10;  &lt;WindowTopX&gt;720&lt;/WindowTopX&gt;&#13;&#10;  &lt;WindowTopY&gt;330&lt;/WindowTopY&gt;&#13;&#10;  &lt;ProtectStructure&gt;False&lt;/ProtectStructure&gt;&#13;&#10;  &lt;ProtectWindows&gt;False&lt;/ProtectWindows&gt;&#13;&#10; &lt;/ExcelWorkbook&gt;&#13;&#10; &lt;Styles&gt;&#13;&#10;  &lt;Style ss:ID=&quot;Default&quot; ss:Name=&quot;Normal&quot;&gt;&#13;&#10;   &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;&#13;&#10;   &lt;Borders/&gt;&#13;&#10;   &lt;Font/&gt;&#13;&#10;   &lt;Interior/&gt;&#13;&#10;   &lt;NumberFormat/&gt;&#13;&#10;   &lt;Protection/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s22&quot;&gt;&#13;&#10;   &lt;Interior ss:Color=&quot;#FF6600&quot; ss:Pattern=&quot;Solid&quot;/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s23&quot;&gt;&#13;&#10;   &lt;Interior ss:Color=&quot;#FFFF00&quot; ss:Pattern=&quot;Solid&quot;/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10; &lt;/Styles&gt;&#13;&#10; &lt;Worksheet ss:Name=&quot;Sheet1&quot;&gt;&#13;&#10;  &lt;Table ss:ExpandedColumnCount=&quot;3&quot; ss:ExpandedRowCount=&quot;21&quot; x:FullColumns=&quot;1&quot;&#13;&#10;   x:FullRows=&quot;1&quot;&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;This is Sheet 1 of the test workbook.&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row ss:Index=&quot;4&quot;&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;  &lt;/Table&gt;&#13;&#10;  &lt;WorksheetOptions xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;ProtectObjects&gt;False&lt;/ProtectObjects&gt;&#13;&#10;   &lt;ProtectScenarios&gt;False&lt;/ProtectScenarios&gt;&#13;&#10;  &lt;/WorksheetOptions&gt;&#13;&#10; &lt;/Worksheet&gt;&#13;&#10; &lt;Worksheet ss:Name=&quot;Sheet2&quot;&gt;&#13;&#10;  &lt;Table ss:ExpandedColumnCount=&quot;3&quot; ss:ExpandedRowCount=&quot;9&quot; x:FullColumns=&quot;1&quot;&#13;&#10;   x:FullRows=&quot;1&quot;&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;This is Sheet 2 of the test workbook&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row ss:Index=&quot;4&quot;&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;  &lt;/Table&gt;&#13;&#10;  &lt;WorksheetOptions xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;ProtectObjects&gt;False&lt;/ProtectObjects&gt;&#13;&#10;   &lt;ProtectScenarios&gt;False&lt;/ProtectScenarios&gt;&#13;&#10;  &lt;/WorksheetOptions&gt;&#13;&#10; &lt;/Worksheet&gt;&#13;&#10;&lt;/Workbook&gt;&#13;&#10;">
 <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&amp;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>

Open in new window

testbook.xls
Screenprint-of-Testbook-displaye.doc
0
 
LVL 31

Expert Comment

by:James Murrell
ID: 22720612
thanks for this try

i changed

      <object
 id="testbook_13424_Spreadsheet"
 classid="CLSID:0002E559-0000-0000-C000-000000000046" width="100%" height="288">

<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="&lt;?xml version=&quot;1.0&quot;?&gt;
&lt;?mso-application progid=&quot;Excel.Sheet&quot;?&gt;&lt;ss:Workbook
 xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot;
 xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;
 xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;
 xmlns:c=&quot;urn:schemas-microsoft-com:office:component:spreadsheet&quot;
 xmlns:html=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;
 &lt;x:ExcelWorkbook&gt;
  &lt;x:ProtectStructure&gt;False&lt;/x:ProtectStructure&gt;
  &lt;x:ActiveSheet&gt;0&lt;/x:ActiveSheet&gt;
 &lt;/x:ExcelWorkbook&gt;
 &lt;ss:Styles&gt;
  &lt;ss:Style ss:ID=&quot;Default&quot;&gt;
   &lt;ss:Alignment ss:Horizontal=&quot;Automatic&quot; ss:Rotate=&quot;0.0&quot; ss:Vertical=&quot;Bottom&quot;
    ss:ReadingOrder=&quot;Context&quot;/&gt;
   &lt;ss:Borders&gt;
   &lt;/ss:Borders&gt;
   &lt;ss:Font ss:FontName=&quot;Arial&quot; ss:Size=&quot;10&quot; ss:Color=&quot;Automatic&quot; ss:Bold=&quot;0&quot;
    ss:Italic=&quot;0&quot; ss:Underline=&quot;None&quot;/&gt;
   &lt;ss:Interior ss:Color=&quot;Automatic&quot; ss:Pattern=&quot;None&quot;/&gt;
   &lt;ss:NumberFormat ss:Format=&quot;General&quot;/&gt;
   &lt;ss:Protection ss:Protected=&quot;1&quot;/&gt;
  &lt;/ss:Style&gt;
  &lt;ss:Style ss:ID=&quot;wc03CF96A0&quot;&gt;
   &lt;ss:Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
   &lt;ss:Font/&gt;
   &lt;ss:Interior ss:Color=&quot;#FF6600&quot; ss:Pattern=&quot;Solid&quot;/&gt;
  &lt;/ss:Style&gt;
  &lt;ss:Style ss:ID=&quot;wc03CFC4A8&quot;&gt;
   &lt;ss:Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
   &lt;ss:Font/&gt;
   &lt;ss:Interior ss:Color=&quot;#FFFF00&quot; ss:Pattern=&quot;Solid&quot;/&gt;
  &lt;/ss:Style&gt;
 &lt;/ss:Styles&gt;
 &lt;c:ComponentOptions&gt;
  &lt;c:Label&gt;
   &lt;c:Caption&gt;Microsoft Office Spreadsheet&lt;/c:Caption&gt;
  &lt;/c:Label&gt;
  &lt;c:SpreadsheetAutoFit/&gt;
  &lt;c:MaxHeight&gt;80&lt;/c:MaxHeight&gt;
  &lt;c:MaxWidth&gt;100%&lt;/c:MaxWidth&gt;
  &lt;c:NextSheetNumber&gt;1&lt;/c:NextSheetNumber&gt;
 &lt;/c:ComponentOptions&gt;
 &lt;x:WorkbookOptions&gt;
  &lt;c:OWCVersion&gt;11.0.0.8166         &lt;/c:OWCVersion&gt;
  &lt;x:Height&gt;7620&lt;/x:Height&gt;
  &lt;x:Width&gt;15240&lt;/x:Width&gt;
 &lt;/x:WorkbookOptions&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet1&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:Selected/&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
  &lt;ss:Table ss:ExpandedColumnCount=&quot;3&quot; ss:ExpandedRowCount=&quot;21&quot;
   ss:DefaultColumnWidth=&quot;48.0&quot; ss:DefaultRowHeight=&quot;12.75&quot;&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell&gt;
     &lt;ss:Data ss:Type=&quot;String&quot;&gt;This is Sheet 1 of the test workbook.&lt;/ss:Data&gt;
    &lt;/ss:Cell&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row ss:Index=&quot;4&quot;&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
  &lt;/ss:Table&gt;
 &lt;/ss:Worksheet&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet2&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
  &lt;ss:Table ss:ExpandedColumnCount=&quot;3&quot; ss:ExpandedRowCount=&quot;9&quot;
   ss:DefaultColumnWidth=&quot;48.0&quot; ss:DefaultRowHeight=&quot;12.75&quot;&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell&gt;
     &lt;ss:Data ss:Type=&quot;String&quot;&gt;This is Sheet 2 of the test workbook&lt;/ss:Data&gt;
    &lt;/ss:Cell&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row ss:Index=&quot;4&quot;&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
  &lt;/ss:Table&gt;
 &lt;/ss:Worksheet&gt;
  &lt;o:DocumentProperties&gt;
   &lt;o:Author&gt; Chemical Company&lt;/o:Author&gt;
   &lt;o:LastAuthor&gt; Chemical Company&lt;/o:LastAuthor&gt;
   &lt;o:Created&gt;2008-10-14T14:31:34Z&lt;/o:Created&gt;
   &lt;o:LastSaved&gt;2008-10-15T11:59:21Z&lt;/o:LastSaved&gt;
   &lt;o:Company&gt; Chemical Company&lt;/o:Company&gt;
   &lt;o:Version&gt;11.8132&lt;/o:Version&gt;
  &lt;/o:DocumentProperties&gt;
  &lt;o:OfficeDocumentSettings&gt;
   &lt;o:RelyOnVML/&gt;
   &lt;o:AllowPNG/&gt;
   &lt;o:PixelsPerInch&gt;120&lt;/o:PixelsPerInch&gt;
   &lt;o:TargetScreenSize&gt;1280x1024&lt;/o:TargetScreenSize&gt;
  &lt;/o:OfficeDocumentSettings&gt;
&lt;/ss:Workbook&gt;
">
 <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&amp;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>

Open in new window

0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:sxlowry
ID: 22721991
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.
0
 
LVL 31

Expert Comment

by:James Murrell
ID: 22722452
possible but i am afraid we cannot have everything....
0
 

Author Comment

by:sxlowry
ID: 22722549
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
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question