Solved

Adjust size of Excel Web Page to fill the screen.

Posted on 2008-10-14
6
883 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:sxlowry
Comment Utility
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
Comment Utility
possible but i am afraid we cannot have everything....
0
 

Author Comment

by:sxlowry
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now