spreadjs的用法

varspreadNS=GC.Spread.Sheets;varspread=newspreadNS.Workbook($("#spreadjsExc")[0],{sheetCount:0});varexcelIO=newGC.Spread.Excel.IO();varfbx=newspreadNS.FormulaTextBox.FormulaTextBox(document.getElementById('formulabox'));fbx.workbook(spread);var_blob=parent.$("#fileImportIO").data("fileIO");varreadonly=parent.$("#fileImportIO").attr('readonly');excelIO.open(_blob,function(spreadJson){functionupdateActiveCells(){for(vari=0;i<spread.getSheetCount();i++){varsheet=spread.getSheet(i);columnIndex=sheet.getActiveColumnIndex(),rowIndex=sheet.getActiveRowIndex();if(columnIndex!==undefined&&rowIndex!==undefined){spread.getSheet(i).setActiveCell(rowIndex,columnIndex);}else{spread.getSheet(i).setActiveCell(0,0);}if(readonly=="true"){sheet.options.isProtected=true;//禁止编辑sheet.options.colHeaderVisible=false;sheet.options.rowHeaderVisible=false;//取消头跟左侧工具栏spread.options.newTabVisible=false;//取消新建sheet按钮}else{sheet.options.isProtected=false;}}}if(spreadJson.version&&spreadJson.sheets){spread.unbindAll();spread.fromJSON(spreadJson);//attachSpreadEvents(true);updateActiveCells();spread.focus();fbx.workbook(spread);onCellSelected();//syncSpreadPropertyValues();//syncSheetPropertyValues();}},function(e){if(e.errorCode===0||e.errorCode===1){//alert("error");}});if(readonly=="true"){$("#saveFile").remove();$("#close").remove();}//spread.print();打印functiononCellSelected(){$("#addslicer").addClass("hidden");varsheet=spread.getActiveSheet(),row=sheet.getActiveRowIndex(),column=sheet.getActiveColumnIndex();if(showSparklineSetting(row,column)){setActiveTab("sparklineEx");return;}varcellInfo=getCellInfo(sheet,row,column),cellType=cellInfo.type;syncCellRelatedItems();updatePositionBox(sheet);updateCellStyleState(sheet,row,column);vartabType="cell";clearCachedItems();//addmapfromcelltypetotabtypehereif(cellType==="table"){tabType="table";syncTablePropertyValues(sheet,cellInfo.object);$("#addslicer").removeClass("hidden");}elseif(cellType==="comment"){tabType="comment";syncCommentPropertyValues(sheet,cellInfo.object);}setActiveTab(tabType);}$("#saveFile").click(function(e){e.preventDefault();varjson=spread.toJSON({includeBindingSource:true});json=JSON.stringify(json);varxhr=newXMLHttpRequest();varbuttonid=parent.$("#fileImportIO").attr("buttonid");var_beanid=parent.$("#fileImportIO").attr("_beanid");varurl='/map/download!save?_beanid='+_beanid+'&buttonid='+buttonid;xhr.open("POST",url,true);xhr.onload=function(oEvent){if(this.status==200){if(this.response=="success"){alert('保存成功');}}};xhr.send(json);/*excelIO.save(json,function(blob){},function(e){//alert(e);});*/});$("#printFile").click(function(e){e.preventDefault();spread.print();});$("#exportFile").click(function(e){e.preventDefault();varjson=spread.toJSON({includeBindingSource:true});var_fname=parent.$("#fileImportIO").attr("filename");excelIO.save(json,function(blob){saveAs(blob,_fname+".xlsx");},function(e){alert(e);});});$("#close").click(function(e){e.preventDefault();var_beanid=parent.$("#fileImportIO").attr("_beanid");varbuttonid=parent.$("#fileImportIO").attr("buttonid");varurl='/map/download!delete?_beanid='+_beanid+'&buttonid='+buttonid;var_ajax={url:url,success:function(data){parent.$("#fileImportIO").closest("#wapper").find(".ui-dialog-titlebar").find(".ui-dialog-titlebar-close").click();}};$.ajax(_ajax);});$("#closes").click(function(e){parent.$("#fileImportIO").closest("#wapper").find(".ui-dialog-titlebar").find(".ui-dialog-titlebar-close").click();});