Hi,
I used Microsoft web components to embed the Excel inside the IE. However, even I set autofit to true. The excel could not auto resize the columns with the table. Any suggestions?
Thanks for your help.
Cindy
Codes:
<HEAD>
</HEAD>
<BODY bgcolor="white" onload="init()">
<object classid="clsid:0002E510-0000-0000-C000-000000000046" id="Spreadsheet1" name="Spreadsheet1" width="100%" height="100%">
<param name="CSVDATA" value='<%= fixupData %>'>
<param name="DataType" value="CSVDATA">
<param name="AutoFit" value="-1">
<param name="AllowFormattingColumns" value="-1">
<param name="DisplayColHeaders" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScrollBar" value="-1">
<param name="DisplayRowHeaders" value="-1">
<param name="DisplayTitleBar" value="-1">
<param name="DisplayToolbar" value="-1">
<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>
</BODY>
<SCRIPT language="JavaScript">
function init()
{
Spreadsheet1.TitleBar.Caption = "Experiment Design Worksheet";
var objRange = Spreadsheet1.ActiveCell.EntireColumn;
objRange.Hidden = "True";
}
Bookmarks