📄 index.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Untitled Page</title>
<script language="javascript">
/*
function onload() {
var Spreadsheet1 = document.all.Spreadsheet1//document.all("Spreadsheet1");
//alert(Spreadsheet1);
Spreadsheet1.ActiveSheet.Cells(1,1).Value="0.13";
Spreadsheet1.ActiveSheet.Cells(1,2).Value="0.23";
Spreadsheet1.ActiveSheet.Cells(1,3).Value="0.33";
Spreadsheet1.ActiveSheet.Cells(1,4).Value="0.43";
Spreadsheet1.ActiveSheet.Cells(2,1).Value="2.13";
Spreadsheet1.ActiveSheet.Cells(2,2).Value="2.23";
Spreadsheet1.ActiveSheet.Cells(2,3).Value="2.33";
Spreadsheet1.ActiveSheet.Cells(3,4).Value="2.43";
Spreadsheet1.ActiveSheet.Range("a1:d3").Borders.Color = "green"
Spreadsheet1.ActiveSheet.Range("B5").Borders.Color = "Red"
//Spreadsheet1.TitleBar.Visible = true;//TitleBar是否可见 true;||false
Spreadsheet1.TitleBar.Interior.Color = "Green"//TitleBar背景顔色
Spreadsheet1.TitleBar.Caption = "test";//TitleBar标题内容
Spreadsheet1.TitleBar.Font.Color = "Red";//TitleBar字元顔色
Spreadsheet1.TitleBar.Font.Name = "Verdana";//TitleBar字体字体名称
Spreadsheet1.TitleBar.Font.Size = 10;//TitleBar字体大小
Spreadsheet1.TitleBar.Font.Bold = true;//TitleBar字体是否加粗
Spreadsheet1.TitleBar.Font.Italic = true;//TitleBar字体是否倾斜
Spreadsheet1.DisplayVerticalScrollBar = false;
Spreadsheet1.DisplayHorizontalScrollBar = false;
//Spreadsheet1.ActiveSheet.Range("A2").Select();//A2单元
//Spreadsheet1.ActiveSheet.Range("B2").Select();//B2单元
//Spreadsheet1.ActiveSheet.Range("A2:D3").Select();//A2-D3矩形中包含的所有单元
Spreadsheet1.ActiveSheet.Range("A2").ColumnWidth = 50;//单元宽度
Spreadsheet1.ActiveSheet.Range("A2").RowHeight = 50;//单元高度
//Spreadsheet1.ActiveSheet.Range("B2").Borders.Weight = 2;//单元框綫宽度
//Spreadsheet1.ActiveSheet.Range("B2").Borders.LineStyle = 4;//框綫样式 2-6之间的常数
//Spreadsheet1.ActiveSheet.Range("B2").Value = "123";//对该单元赋值
//Spreadsheet1.ActiveSheet.Range("B2").Cut();//单元内容剪切
//Spreadsheet1.ActiveSheet.Range("B2").Copy();//複制单元内容
//Spreadsheet1.ActiveSheet.Range("B2").Paste();//粘贴剪贴内容到单元
//Spreadsheet1.ActiveSheet.Range("B2").ParseText("test");//粘贴制定内容到单元
//Spreadsheet1.ActiveSheet.Range("B2").Clear();//单元内容晴空
//Spreadsheet1.ActiveSheet.Range("B2").Find("test");//单元内执行查找
Spreadsheet1.ActiveSheet.Range("B2").Interior.Color = "Yellow";//单元背景
Spreadsheet1.ActiveSheet.Range("B2").Font.Color = "Red";//单元字元顔色
//Spreadsheet1.ActiveSheet.Range("B2").Font.Name = "Verdana";//单元字体字体名称
//Spreadsheet1.ActiveSheet.Range("B2").Font.Size = 10;//A单元字体大小
//Spreadsheet1.ActiveSheet.Range("B2").Font.Bold = true;//单元字体是否加粗
Spreadsheet1.ActiveSheet.Range("B2").Font.Italic = true;//单元字体是否倾斜
//Spreadsheet1.ActiveSheet.Range("B2").Hyperlink.Address = "http://www.qpp.com";
//Spreadsheet1.ActiveSheet.Range("B2").Hyperlink.Delete();
Spreadsheet1.ActiveSheet.Range("C5").Value = 10.13;
Spreadsheet1.ActiveSheet.Range("C6").Value = 315.68;
Spreadsheet1.ActiveSheet.Range("B2").Formula = "=SUM(C5*C6)";//自动套用计算公式
Spreadsheet1.ActiveSheet.Range("B2").NumberFormat = "￥#,##0.00;￥-#,##0.00";//数字类型格式化
//alert(Spreadsheet1.XMLData);
}
*/
function set_a1() {
var i,j;
Spreadsheet1.cells(1,2).value="企业表";
Spreadsheet1.cells(2,2).value="财务指标";
Spreadsheet1.cells(3,2).value="主营业务收入";
Spreadsheet1.cells(4,1).value="时间";
Spreadsheet1.cells(4,2).value="本期";
Spreadsheet1.cells(4,3).value="同月比";
Spreadsheet1.cells(4,4).value="累计";
Spreadsheet1.cells(4,5).value="同期比";
Spreadsheet1.ActiveSheet.Range("B1").Font.Bold = true;//单元字体是否加粗
Spreadsheet1.ActiveSheet.Range("B2").Font.Color = "Red"
Spreadsheet1.cells(5,1).value="2005年1月";
Spreadsheet1.cells(6,1).value="2005年2月";
Spreadsheet1.cells(7,1).value="2005年3月";
Spreadsheet1.cells(8,1).value="2005年4月";
Spreadsheet1.cells(9,1).value="2005年5月";
Spreadsheet1.cells(10,1).value="2005年6月";
for(i=2;i<=5;i++){
for(j=5;j<=10;j++){
Spreadsheet1.cells(j,i).value=i;
};
};
Spreadsheet1.range(Spreadsheet1.cells(1,1),Spreadsheet1.cells(10,5)).cells.borders.weight=1;
Spreadsheet1.DisplayGridlines = true;
Spreadsheet1.DisplayToolbar = false;
Spreadsheet1.ActiveSheet.Range(Spreadsheet1.cells(1,1),Spreadsheet1.cells(10,5)).Font.Size = 10;
Spreadsheet1.ActiveSheet.Range(Spreadsheet1.cells(1,2),Spreadsheet1.cells(1,5)).Merge();
Spreadsheet1.ActiveSheet.Range(Spreadsheet1.cells(2,2),Spreadsheet1.cells(2,5)).Merge();
Spreadsheet1.ActiveSheet.Range(Spreadsheet1.cells(3,2),Spreadsheet1.cells(3,5)).Merge();
return false;
}
</script>
</head>
<body >
<form id="form1" >
</form>
<object classid="clsid:0002E559-0000-0000-C000-000000000046" width="100%" id="Spreadsheet1"height="500">
<param name="DisplayTitleBar" value=false/>
<param name="ViewableRange" value="1:65536"/>
<param name="EnableEvents" value="-1"/>
<param name="DisplayColHeaders" value="-1"/>
<param name="DisplayGridlines" value="-1"/>
<param name="DisplayHorizontalScrollBar" value="-1"/>
<param name="DisplayRowHeaders" value="-1"/>
<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="DataType" value="HTMLURL"/>
</object>
<form>
<input type=submit onclick='return get_a1()' value='Get A1'/>
<input type=submit onclick='return set_a1()' value='Set A1'/>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -