在网页中嵌入excel文档

最简单的，直接window.open('excel路径');
然后会弹出下载对话框，选打开就在浏览器中打开了
<html xmlns="http://www.w3.org/1999/xhtml" ><head id="Head1" runat="server">    <title>Untitled Page</title>
     <script language="javascript">
function document.onkeydown(){
if(event.keyCode == 116){
event.keyCode = 0;
event.returnValue = false;
return;
}
}
if(window.Event){
   document.captureEvents(Event.MOUSEUP);
   }

function nocontextmenu(){
event.cancelBubble = true
event.returnValue = false;
return false;
}

function norightclick(e) {
if (window.Event){
if (e.which == 2 || e.which == 3)
    return false;
}else if(event.button == 2 || event.button == 3) {
    event.cancelBubble = true
    event.returnValue = false;
    return false;
}
}

document.oncontextmenu = nocontextmenu;  // for IE5+
document.onmousedown = norightclick;  // for all others
function deleteRecord(){
var Spreadsheet1 = document.all("Spreadsheet1");
       //var rowNum = Spreadsheet1.ActiveCell.Row;
//Spreadsheet1.Cells.Rows(rowNum).Delete();
       var rowNums = Spreadsheet1.Selection.Rows;
rowNums.Delete();
}function undo(){

var Spreadsheet1 = document.all("Spreadsheet1");
if(Spreadsheet1.CanUndo){
     Spreadsheet1.Undo();
}else{
     alert("无法执行撤销操作！");
}
}function clearAll(){
var Spreadsheet1 = document.all("Spreadsheet1");
Spreadsheet1.Range("A2:DD500").Cells.Clear();
}function Spreadsheet1_BeforeContextMenu(x, y, Menu, Cancel){
var cmContextMenu = new Array();
     cmContextMenu[0] = ["撤销操作(&U)", "undo"];
cmContextMenu[1] = null;
cmContextMenu[2] = ["删除行记录(&D)", "deleteRecord"];
cmContextMenu[3] = ["清空所有记录(&A)", "clearAll"];
Menu.Value = cmContextMenu;
//Cancel.Value = true;
}function Spreadsheet1_CommandExecute(Command, Succeeded){
if(Command == 'undo')  undo();
if(Command == 'deleteRecord')  deleteRecord();
if(Command == 'clearAll')  clearAll();
}function Spreadsheet1_BeforeKeyDown(KeyCode, Shift, Cancel){
//屏蔽剪切复制
if((Shift == 2) && (KeyCode == 88 || KeyCode == 67)) Cancel.Value = true;
}function   onload()   { var   Spreadsheet1   =   document.all("Spreadsheet1");
Spreadsheet1.EnableUndo = false;
//设置显示工具栏
Spreadsheet1.DisplayToolbar = false;//设置调整大小
Spreadsheet1.ActiveWindow.EnableResize = false;//alert(arr.length);//显示“命令和选项”窗口
Spreadsheet1.AllowPropertyToolbox =  false;//设置单个sheet属性
Spreadsheet1.DisplayWorkbookTabs = true; var aa = eval("Spreadsheet1"+"_BeforeContextMenu");
//调用事件
Spreadsheet1.attachEvent("BeforeContextMenu",aa);
Spreadsheet1.attachEvent("CommandExecute",Spreadsheet1_CommandExecute);
Spreadsheet1.attachEvent("BeforeKeyDown",Spreadsheet1_BeforeKeyDown);
      Spreadsheet1.ActiveSheet.Cells.Clear();
      Spreadsheet1.ActiveSheet.Cells(2, 1).Value = "Car";
      Spreadsheet1.ActiveSheet.Cells(3, 1).Value = "Sport-Utility";
      Spreadsheet1.ActiveSheet.Cells(4, 1).Value = "Truck";
      Spreadsheet1.ActiveSheet.Cells(5, 1).Value = "Minivan";
      Spreadsheet1.ActiveSheet.Cells(1, 2).Value = "1998";
      Spreadsheet1.ActiveSheet.Cells(2, 2).Value = 0.2;
      Spreadsheet1.ActiveSheet.Cells(3, 2).Value = 0.06;
      Spreadsheet1.ActiveSheet.Cells(4, 2).Value = 0.17;
      Spreadsheet1.ActiveSheet.Cells(5, 2).Value = 0.13;      Spreadsheet1.ActiveSheet.Cells(1, 3).Value = "1999";
      Spreadsheet1.ActiveSheet.Cells(2, 3).Value = 0.38;
      Spreadsheet1.ActiveSheet.Cells(3, 3).Value = 0.82;
      Spreadsheet1.ActiveSheet.Cells(4, 3).Value = 0.28;
      Spreadsheet1.ActiveSheet.Cells(5, 3).Value = 0.62;      Spreadsheet1.ActiveSheet.Cells(1, 4).Value = "2000";
      Spreadsheet1.ActiveSheet.Cells(2, 4).Value = 0.42;
      Spreadsheet1.ActiveSheet.Cells(3, 4).Value = 0.12;
      Spreadsheet1.ActiveSheet.Cells(4, 4).Value = 0.55;
      Spreadsheet1.ActiveSheet.Cells(5, 4).Value = 0.25;
    //设置保护区域
    var shtCurrent = Spreadsheet1.ActiveSheet;         var rngUsed = shtCurrent.UsedRange; var rngCurRegion = Spreadsheet1.Range("a2").CurrentRegion;   alert(rngUsed.Rows.Count);
   //alert(rngUsed.Columns.Count);
//Spreadsheet1.Cells.Rows(2).Delete();    //shtCurrent.range(shtCurrent.Cells(5, 1),shtCurrent.Cells(5, 4)).Locked = false;
    //shtCurrent.Protection.Enabled = true;Spreadsheet1.EnableUndo = true;//alert(Spreadsheet1.XMLData);    //alert(Spreadsheet1.ActiveWorkbook.XmlMaps(1).MapData);
} </script> </head><body onload="return onload()" ><form id="form1" runat="server">
<div>
</div>
</form><OBJECT  id="Spreadsheet1" classid="clsid:0002E559-0000-0000-C000-000000000046" name="Spreadsheet1" style="width:100%;height:421px" >             <table width="100%" cellpadding="0" cellspacing="0" border="0">
                <tr>
                    <td bgcolor="#336699" height="25" width="10%"> </td>
                    <td bgcolor="#666666" width="85%">
                        <font face="宋体" color="white" size="4">
                            <b>  缺少 Microsoft Office Web Components</b>
                        </font>
                    </td>
                </tr>
                <tr>
                    <td bgcolor="#cccccc" width="15"> </td><td bgcolor="#cccccc" width="500px"><br>
                     <font face="宋体" size="2">此网页要求 Microsoft Office Web Components。
                         <p align="center">
                             <a href="C:/IUware Online/Microsoft Office Professional Enterprise Edition 2003/files/owc11/setup.exe"> 单击此处安装 Microsoft Office Web Components。
                              </a>.
                          </p>
                      </font>
                      <p>
                      <font face="宋体" size="2"> 此网页同时要求 Microsoft Internet Explorer 5.01 或更高版本。</p>
                        <p align="center"/><a href="http://www.microsoft.com/windows/ie/default.htm"> 单击此处安装最新的 Internet Explorer</a>.
                      </font><br> 
                    </td>
                  </tr>
              </table></OBJECT>
</body></html>
我JSP开发，使用此种方法，请问这里面的数据如何保存到数据库呢

调试易

在网页中嵌入excel文档

解决方案 »