📄 excelpage.aspx
字号:
<%@ Page CODEPAGE="936" CodeBehind="ExcelPage.aspx.cs" Language="c#" AutoEventWireup="false" Inherits="WebExcel.ExcelPage" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<html>
<head>
<title> Excel工作空间 </title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name=vs_defaultClientScript content="JavaScript">
<meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
<LINK media='print' href='Css/printCss.css' type='text/css' rel='stylesheet'>
<LINK media='screen' href='Css/Css.css' type='text/css' rel='stylesheet'>
<script language="JavaScript" src="js/Menu.js"></script>
<script language="JavaScript" src="js/MenuFunction.js"></script>
<script language="JavaScript" src="js/ToolBarJS.js"></script>
<script language="JavaScript" src="js/TopLeft.js"></script>
<script language="JavaScript" src="js/BodyOperate.js"></script>
<script language="JavaScript" src="js/ReadXML.js"></script>
<script language="JavaScript" src="js/WriteXML.js"></script>
<script language=javascript>
var ischange = true; //这个是一个判断标识，当有改变的时候属性设置为真
var clickobj = null; //要输入文字的对象
//返回影响到的行或者列
var effectrow = 0;
var effectcol = 0;
</script>
<script language="JavaScript">
/********************************************************
* 功能：Hashtable *
* 作者：胡耀 *
* 使用方法： var yourVariable = new Hashtable(); *
* 实现了如下方法： *
* ◆put(key,value) *
* ◆get(key,[defaultValue]),其中defaultValue参数可选 *
* 无defaultValue，get没有匹配时返回null *
* ◆remove(key),成功返回ture，失败返回false(要求IE5.5)*
* ◆clear() *
* ◆containsKey(key)，包含返回ture，否则返回false *
* ◆containsValue(value)，包含返回ture，否则返回false *
* ◆size()，返回hashtable中数据总数 *
********************************************************/
function Hashtable()
{
this.hash = new ActiveXObject("Scripting.Dictionary");
this.put = put;
this.get = get;
this.keys = keys;
this.values = values;
this.clear = clear;
this.remove = remove;
this.containsKey = containsKey;
this.containsValue = containsValue;
this.size = size;
function put(key,value) { if (this.hash.Exists(key)) this.remove(key); this.hash.Add(key,value); }
function get(key) { if(typeof( this.hash.Item(key)) != 'undefined') return this.hash.Item(key); return (arguments.length==2) ? arguments[1] : null; }
function remove(key) { if (this.hash.Exists(key)) this.hash.Remove(key); }
function keys() { return (new VBArray(this.hash.Keys())).toArray();}
function values() { return (new VBArray(this.hash.Items())).toArray(); }
function clear() { this.hash.RemoveAll(); }
function containsKey(key) { return (this.hash.Exists(key)) ? true : false; }
function containsValue(value) { var values = (new VBArray(this.hash.Items())).toArray(); for (var i=0; i<values.length; i++) if(values[i] == value) return true; return false; }
function size() { return this.hash.Count; }
}
</script>
</head>
<body topmargin=0 leftmargin=11>
<object id="WebBrowser" width=0 height=0 classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2" ></object>
<form id="form1" runat="server">
<script language=javascript>
var tablecol = 16;
var tablerow = 40;
var owidth = 80;
var oheight = 20;
</script>
<!----------------------------------------------------------------------------------------------------->
<table id=table cellPadding=0 cellSpacing=0 class=dwStyle onselectstart='return false'>
<tr height="20">
<td colspan =2 style="background-color:#BED5F9">
<!------------------------------菜单栏----------------------------------------------------------------->
<table id = menutable class=mymenutable cellSpacing="0" cellPadding="0" border="0" height="20">
<tr>
<td width="8" background="Images/toolbar_left.gif"></td>
<td width = 50 class="tdMenuNormal" onmousedown="ButtonClick(this,1)" onmouseover="onButton(this,1)" onmouseout="offButton(this,1)" >文件（F）</td>
<td width="8"></td>
<td width=50 class="tdMenuNormal" onmousedown="ButtonClick(this,2)" onmouseover="onButton(this,1)" onmouseout="offButton(this,1)" >编辑（E）</td>
<td width="8"></td>
<td width=50 class="tdMenuNormal" onmousedown="ButtonClick(this,3)" onmouseover="onButton(this,1)" onmouseout="offButton(this,1)" >操作（O）</td>
</tr>
</table>
<!----------------------------------------------------------------------------------------------------->
</td>
</tr>
<tr>
<td style="background-color:#BED5F9" colspan =2 valign=top>
<!------------------------工具栏菜单栏----------------------------------------------------------------->
<table id="tbBtnToolbar" class = mytooltable style="FONT-SIZE: 9pt; FONT-FAMILY: 宋体; HEIGHT: 20px" cellSpacing="0" cellPadding="0">
<tr height="20">
<td width="8" background="Images/toolbar_left.gif"></td>
<td background="Images/toolbar_bg.gif">
<table cellSpacing="0" cellPadding="0" border="0">
<tr>
<td width="2"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="cratenew()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/new.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="myopen()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/open.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="save()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/save.gif"></td>
<td><IMG src="Images/toolbar_splt.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="copy()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/copy.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="paster()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/paste.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="cut()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/Cut.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="print()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/print.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="preview()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/preview.gif"></td>
<td><IMG src="Images/toolbar_splt.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="left()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/fontleft.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="mid()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/fontmid.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="right()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/fontright.gif"></td>
<td><IMG src="Images/toolbar_splt.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="range(this)" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/4b.gif"></td>
</tr>
</table>
</td>
<td width="13" background="Images/toolbar_right.gif"></td>
<td width=8></td>
<td width="8" background="Images/toolbar_left.gif"></td>
<td background="Images/toolbar_bg.gif">
<table cellSpacing="0" cellPadding="0" border="0">
<tr>
<td width="2"></td>
<td>
<SELECT style="WIDTH: 100px;" onchange=fontfamily(this)>
<OPTION selected>宋体</OPTION>
<OPTION>隶书</OPTION>
<OPTION>仿宋_GB2312</OPTION>
<OPTION>黑体</OPTION>
<OPTION>华文彩云</OPTION>
<OPTION>华文细黑</OPTION>
<OPTION>楷体_GB2312</OPTION>
<OPTION>新宋体</OPTION>
<OPTION>幼圆</OPTION>
<OPTION>华文中宋</OPTION>
</SELECT>
</td>
<td>
<SELECT style="WIDTH: 50px;" onchange=fontsize(this)>
<OPTION>8</OPTION>
<OPTION>9</OPTION>
<OPTION>10</OPTION>
<OPTION>11</OPTION>
<OPTION selected>12</OPTION>
<OPTION>14</OPTION>
<OPTION>16</OPTION>
<OPTION>18</OPTION>
<OPTION>20</OPTION>
<OPTION>22</OPTION>
</SELECT>
</td>
<td width="2"></td>
<td><IMG src="Images/toolbar_splt.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="cuti()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/b.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="xieti()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/i.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="xiahuaxian()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/u.gif"></td>
<td class="tdBarNormal" onmouseover="onButton(this,2)" onclick="selected_area.unitTD()" onmouseout="offButton(this,2)" vAlign="middle" align="center"><IMG src="Images/merge.gif"></td>
<td><IMG src="Images/toolbar_splt.gif"></td>
</tr>
</table>
</td>
<td width="13" background="Images/toolbar_right.gif"></td>
</tr>
</table>
<!----------------------------------------------------------------------------------------------------->
<td>
</tr>
<tr><td colspan=2 valign=top>
<!------------------------头--------------------------------------------------------------------------->
<div id=topdiv>
<table id=toptable cellPadding=0 cellSpacing=0 class=dwTHStyle>
<thead><tr onmousedown=ChangWidth() onmousemove=ChangCursor()>
<td style="width:40"></td>
<script language=vbscript>
function getLetter(i)
getLetter=Chr(i)
end function
</script>
<script language="JavaScript">
<!--
var col = 65 + Number(tablecol);
for(var i=65; i<col; i++){
document.write("<td style=width:80>" + getLetter(i) + "</td>");
}
//-->
</script>
</tr>
</thead>
</table>
</div>
<!----------------------------------------------------------------------------------------------------->
</td></tr><tr>
<td valign=top>
<!------------------------左--------------------------------------------------------------------------->
<div id = leftdiv>
<table id=lefttable cellPadding=0 cellSpacing=0 class=dwTLStyle onmousedown=ChangHeight() onmousemove=ChangHCursor()>
<tbody>
<script language="JavaScript">
<!--
for(var i=1; i<=tablerow; i++){
document.write("<tr><td style=width:40;height:20px>" + i + "</td></tr>");
}
//-->
</script>
</tbody>
</table>
</div>
<!----------------------------------------------------------------------------------------------------->
</td>
<td valign=top><div id =rightdiv>
<!-----------------------中---------------------------------------------------------------------------->
<table id=tbobj cellPadding=0 cellSpacing=0 class= dwTBStyle>
<tbody ondrag="return false" onmousedown='down()' onmouseover='move()' onmouseup='up()' onselectstart='return false' >
<script language="JavaScript">
<!--
for(var i=0; i<=tablerow; i++){
document.write("<tr>");
for(var j=0; j<=tablecol; j++){
{
if(i==0&&j == 0)
{
document.write("<td style=width:0px;height:0px></td>");continue;
}
else if(i==0)
document.write("<td style=width:79px;height:0px></td>");
else if( j == 0 )
document.write("<td style=width:0px;height:20px></td>");
else
document.write("<td ><div contentEditable=true></div></td>");
}
}
document.write("</tr>");
}
//-->
</script>
</tbody>
</table>
<!----------------------------------------------------------------------------------------------------->
</div></td></tr></table>
<INPUT id = loadhash type="hidden" value="">
<INPUT id = mergehash type="hidden" value="">
</form>
<!----------------------------------------------------------------------------------------------------->
<input style="display:none" type="file" id="path"/>
<button style=display:none id=load style="behavior:url(#default#download)" onClick="path.click();var values = path.value;if(!values)return;startDownLoad(values,gettxt);">load</button>
<button style=display:none onclick='selected_area.drawNet()'>网</button>
<button style=display:none onclick='selected_area.drawRect()'>框</button>
<button style=display:none onclick='selected_area.drawTopLine()'>上</button>
<button style=display:none onclick='selected_area.drawBottomLine()'>下</button>
<button style=display:none onclick='selected_area.drawLeftLine()'>左</button>
<button style=display:none onclick='selected_area.drawRightLine()'>右</button>
<button style=display:none onclick='selected_area.drawNone()'>无</button>
<div style="position:absolute; left:100; top:300" id= ohoh></div>
<div style="position:absolute; left:300; top:300" id= ohoh1></div>
<div style="position:absolute; left:500; top:400" id= ohoh2></div>
<div style="position:absolute; left:500; top:430" id= ohoh3></div>
<div style="position:absolute; left:50; top:450" id= ohoh4></div>
<div style="position:absolute; left:500; top:450" id= ohoh5></div>
<div id = hehe style="position:absolute;background-color:yellow; FILTER: Alpha( style=0,opacity=25);display:;font-size:9pt" onmousemove='move()' onmousedown='down()' onmouseup='up()' oncontextmenu=RightClick() onselectstart='return false'></div>
<script language="JavaScript">
<!--
var tbs = new Hashtable();//记录起始表格
var unitcells = new Hashtable();//记录合并的对象
var n = 0;//开关变量1表示正在选择0表示没有进行选择
//var tablecol = 10;//表一共有多少列
//var tablerow = 30;//表一共有多少行
//var tbobj = t1;//表格对象
var addtop = 78;//往上要加多少
var addleft = 11;//左边要加多少
Array.prototype.digitalsort=function(){this.sort(new Function("a","b","return digitalcomp(a,b,'1')"));}
function digitalcomp(x,y,flag)
{
if(flag!=1) return Number(y)-Number(x);
else return Number(x)-Number(y);
}
function coordinates(row,col,merge)
{
this.row = row;
this.col = col;
this.merge = merge;
}
//-----------------------创建起始时候的哈希表--------------------------------
function cal_coordinates(){
for(var i=0; i<tbobj.rows.length; i++){
for(var j=0; j<tbobj.rows[i].cells.length; j++){
var key = i + '-' + j;
var col = new coordinates(0,0,false);
col.row = i;
col.col = j;
col.merge = false;
tbs.put(key, col);
}
}
}
//保存时调用
function inputhashvalue1(){
document.form1.loadhash.value = "";
var count = tbs.hash.Count;
for(var i=0; i<count; i++){
var key = tbs.keys()[i];
var obj = tbs.get(key);
document.form1.loadhash.value += key+","+obj.row+","+obj.col+","+obj.merge+","
}
}
function inputhashvalue2(){
document.form1.mergehash.value = "";
var count = unitcells.hash.Count;
for(var i=0; i<count; i++){
var key = unitcells.keys()[i];
var obj = tbs.get(key);
document.form1.mergehash.value += key+","+obj+",";
}
}
//打开时调用
function loadhashvalue1(){
tbs.clear();
var value = document.form1.loadhash.value;
var values = value.split(",");
for(var i=0;i<values.length;i+=4)
{
var col = new coordinates(0,0,false);
col.row = values[i+1];
col.col = values[i+2];
col.merge = eval(values[i+3]);
tbs.put(values[i], col);
}
//values = null;
}
function loadhashvalue2(){
unitcells.clear();
var value = document.form1.mergehash.value;
var values = value.split(",");
for(var i=0;i<values.length;i+=2)
{
unitcells.put(values[i] , values[i+1]);
}
//values = null;
}
cal_coordinates();
//----------------------------------------------------------------------------
//取得操作空间中最大的行或者列
function GetMaxColRow(erow,ecol)
{
if(erow>effectrow) effectrow = erow;
if(ecol>effectcol) effectcol = ecol;
}
function selectedArea(sy,ey,sobj,eobj,lineColor,xscol,xsrow,xecol,xerow)
{
this.sobj = sobj;//鼠标选中的开始的表格
this.eobj = eobj;//鼠标选中的最后的表格
this.lineColor = '#000000';
this.sy = sy;
this.ey = ey;
//读文件时要用
this.xscol = xscol;
this.xsrow = xsrow;
this.xecol = xecol;
this.xerow = xerow;
//以下四个变量是在表开始建立的时候的行号和列号定位的单元格子
var scol = 0;
var srow = 0;
var ecol = 0;
var erow = 0;
this.show = show;//显示所选范围
this.unitTD = unitTD;//合并单元格
this.getscol = getscol;
this.getsrow = getsrow;
this.geterow = geterow;
this.getecol = getecol;
this.readfile = readfile;
//边框函数
this.drawNet = drawNet;
this.drawRect = drawRect;
this.drawTopLine = drawTopLine;
this.drawBottomLine = drawBottomLine;
this.drawLeftLine = drawLeftLine;
this.drawRightLine = drawRightLine;
this.drawNone = drawNone;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -