Thank xlbo. Thank you all!
We have tried this method. Now the problem is that ROW 1 will be out of view when click the vertical scroll bar. But if you freeze ROW 1 then you cannt click the horizontal scroll bar to view the last some columns.
How can we? Following is a source code example of our equip maintenance web page.
Thanks again!
Vincent
------------------------------------------------------------
<html>
<head>
<title>Equipment Maintenance</title>
</head>
<p align="center">
<form action="detail_excelUI_save.do" name="excelForm" method="POST">
<span style="font-size: 14px">
<font color="#000080">Detail Equip Maintenance - Shenzhen Telecommunication Ltd. 2003-06-30
</font></span>
<input type="submit" value="Save" name="btnSave" class="button" onclick="onSubmit();">
<hr color="#000080" size=1>
<div align="center">
<input type="text" name="title" size="113" style="border-style: solid" readonly="true">
<object classid="clsid:0002E510-0000-0000-C000-000000000046" id="sheet" width="800" height="500">
<param name="HTMLURL" value>
<param name="HTMLData" value="<html xmlns:x="urn:schemas-microsoft-com
ffice:excel"
xmlns="
<head>
<style type="text/css">
<!--tr
{mso-height-source:auto;}
td
{white-space:nowrap;}
.wc0C53AD4
{white-space:nowrap;
font-family:ËÎÌå;
mso-number-format:General;
font-size:auto;
font-weight:auto;
font-style:auto;
text-decoration:auto;
mso-background-source:auto;
mso-pattern:auto;
mso-color-source:auto;
text-align:general;
vertical-align:bottom;
border-top:none;
border-left:none;
border-right:none;
border-bottom:none;
mso-protection:unlocked;}
-->
</style>
</head>
<body>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:OWCVersion>9.0.0.2710</x:OWCVersion>
<x:Label Style='border-top:solid .5pt silver;border-left:solid .5pt silver;
border-right:solid .5pt silver;border-bottom:solid .5pt silver'>
<x:Caption>Microsoft Office Spreadsheet</x:Caption>
</x:Label>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Selected/>
<x:Height>7620</x:Height>
<x:Width>15240</x:Width>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x
rotectContents>False</x
rotectContents>
<x
efaultRowHeight>210</x
efaultRowHeight>
<x:StandardWidth>2389</x:StandardWidth>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:MaxHeight>80%</x:MaxHeight>
<x:MaxWidth>80%</x:MaxWidth>
</x:ExcelWorkbook>
</xml><![endif]-->
<table class=wc0C53AD4 x:str>
<col width="56">
<tr height="14">
<td></td>
</tr>
</table>
</body>
</html>
">
<param name="DataType" value="HTMLDATA">
<param name="AutoFit" value="0">
<param name="DisplayColHeaders" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScrollBar" value="-1">
<param name="DisplayRowHeaders" value="-1">
<param name="DisplayTitleBar" value="0">
<param name="DisplayToolbar" value="0">
<param name="DisplayVerticalScrollBar" value="-1">
<param name="EnableAutoCalculate" value="-1">
<param name="EnableEvents" value="-1">
<param name="MoveAfterReturn" value="-1">
<param name="MoveAfterReturnDirection" value="0">
<param name="RightToLeft" value="0">
<param name="ViewableRange" value="1:65536">
</object>
</div>
<input type="hidden" name="data" value="">
<input type="hidden" name="columnCount" value="">
<input type="hidden" name="rowCount" value="">
<script language="javascript">
excelForm.sheet.CSVData = "Shenzhen,Import,China,Huawei,C08,2002,1,2,3\nShenzhen,Import,USA,Motolola,C09,2002,1,2,3\nShenzhen,Import,Fenland,Nokia,C10,2002,1,2,3\nShenzhen,Import,China,Huawei,C11,2002,1,2,3\nShenzhen,Import,China,Huawei,C12,2002,1,2,3\nShenzhen,Import,China,Huawei,C13,2002,1,2,3\nShenzhen,Import,China,Huawei,C14,2002,1,2,3\nShenzhen,Import,China,Huawei,C15,2002,1,2,3\nShenzhen,Import,China,Huawei,C16,2002,1,2,3\nShenzhen,Import,China,Huawei,C17,2002,1,2,3\nShenzhen,Import,China,Huawei,C18,2002,1,2,3\nShenzhen,Import,China,Huawei,C19,2002,1,2,3\n";
excelForm.title.value = "Location(A)|ImportMethod(B)|Country(C)|Company(D)|Model(E)|Year(F)|SCP Capacity(G)|SSP Capacity(H)|Remark1(I)|Remark2(I)|Remark3(I)";
var range = "A:"+ (String.fromCharCode(12+64));
excelForm.sheet.ViewableRange = range;
</script>
</form>
<p align="center">
<a href="ListDetail.do">Back</a>
</body>
</html>
