Solved

Adjust size of Excel Web Page to fill the screen.

Posted on 2008-10-14
6
915 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

809 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