spreadJs的使用实例

最新推荐文章于 2024-01-30 18:02:36 发布
最新推荐文章于 2024-01-30 18:02:36 发布
阅读量6.0k 收藏 7
点赞数
分类专栏： javascript 插件 文章标签： spreadJs
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/wpy_ice/article/details/84946106
版权 
<!DOCTYPE html>
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<title>spreadJs-demo</title>
	<link rel="stylesheet" type="text/css" href="css/gc.spread.sheets.excel2013white.12.0.0.css">
	<script type="text/javascript" src="js/jquery-1.10.2.min.js"></script>
	<script src="js/spread/gc.spread.sheets.all.12.0.0.min.js" type="text/javascript"></script>
	<script src="js/spread/gc.spread.sheets.resources.zh.12.0.0.min.js" type="text/javascript"></script>
	<script src="js/utils.js" type="text/javascript"></script>
</head>
<body>
	<input type="text" id="inputValue"/>
	<input type="button" id="searchBtn" value="搜索" />
	<!-- <input type="button" id="searchBtn" value="搜索" /> -->
	<span>罐子类型</span>
	<select id="viewType">
        <option value="" selected="selected">全部</option>
        <option value="存钱罐">存钱罐</option>
        <option value="大富翁">大富翁</option>
    </select>
    <span>月度目标差额</span>
	<select id="monthCE">
        <option value="" selected="selected">全部</option>
        <option value="Y">已完成</option>
        <option value="N">未完成</option>
    </select>
     <span>历史完成月度</span>
	<select id="hisCompletedMonth">
        <option value="" selected="selected">全部</option>
        <option value="1个月">Y</option>
        <option value="x个月">N</option>
    </select>
     <span>上月是否完成规划</span>
	<select id="hasCompletedMonthPlan">
        <option value="" selected="selected">全部</option>
        <option value="Y">Y</option>
        <option value="N">N</option>
    </select>
	<div id="ss" style="margin:0 auto;width:1250px;height:860px;border:1px solid black;"></div>
</body>

<script type="text/javascript" src="js/esheetSearch.js"></script>
<script type="text/javascript">
	var param=window.location.search;
    var spreadNS = GC.Spread.Sheets;
    var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'));
    var activeSheet = spread.getSheet(0);
    //影藏sheet添加符号
	spread.options.newTabVisible=false;
    var columnNums=0;
	
    window.onload = function() {
         $.ajax({
    		type: "POST",
            url: "http://localhost:8080/getData.do"+param+"&r="+ new Date().getTime(),
            async: false,
            success: function(data){
            	var obj=data.Data;
            	var header=data.Header
            	columnNums=data.columnNum;
            	activeSheet.suspendPaint();
            	//表头三行
            	activeSheet.setRowCount(2, GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 0, "群名", GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.addSpan(0,1,1,2,GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 1, header[0], GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 3, "当月加保人数", GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 4, header[1], GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 5, "当月金额", GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 6, header[2], GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 7, "本月完成规划人数", GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 8, header[3], GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 9, "上月完成规划人数", GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setValue(0, 10, header[4], GC.Spread.Sheets.SheetArea.colHeader);

//            	activeSheet.setValue(0, 11, "退保用户", GC.Spread.Sheets.SheetArea.colHeader);
            	var cellType = new GC.Spread.Sheets.CellTypes.Button();
            	cellType.buttonBackColor("#FF0000");
            	cellType.text("退保用户");
            	activeSheet.getCell(0, 11,GC.Spread.Sheets.SheetArea.colHeader).cellType(cellType);
            	
            	activeSheet.addSpan(0, 12, 1, 65, GC.Spread.Sheets.SheetArea.colHeader);
            	
            	var defaultStyle = new GC.Spread.Sheets.Style();
            	defaultStyle.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
            	activeSheet.setDefaultStyle(defaultStyle, GC.Spread.Sheets.SheetArea.viewport);
            	
            	 //Change the column header height.
            	activeSheet.setRowHeight(0, 60.0,GC.Spread.Sheets.SheetArea.colHeader);
            	activeSheet.setRowHeight(1, 30.0,GC.Spread.Sheets.SheetArea.colHeader);
                //Change the row header width.
 //               activeSheet.setColumnWidth(1, 150.0,GC.Spread.Sheets.SheetArea.colHeader);
            	
      //      	activeSheet.addSpan(0,);
//            	activeSheet.setRowHeight(1, 50);
 //           	activeSheet.setColumnWidth(0, 150);
            	activeSheet.autoGenerateColumns = true;
            	activeSheet.options.allowCellOverflow = true;
            	activeSheet.setDataSource(obj);
            	
            	activeSheet.defaults.rowHeight = 50;
//            	activeSheet.defaults.columnWidth = 100;
            	activeSheet.getRange(-1, 1, -1, columnNums-1, GC.Spread.Sheets.SheetArea.viewport).width(120);
//            	activeSheet.getRange(1, 1, 1, 3).backColor("rgb(20, 140, 1218)");
 				var row = activeSheet.getRange(1, -1, 1, -1, spreadNS.SheetArea.colHeader);
    		    row.backColor("yellow");
    		    
    		    activeSheet.autoFitColumn;
 //   		    activeSheet.autoFitRow
    		    //行添加yanse
    		    for(var i=0;i<obj.length;i++){
    		    	if(obj[i].罐子区分=='大富翁'){
    		    		activeSheet.getRange(i, -1, 1, -1, spreadNS.SheetArea.viewport).backColor("Pink");
    		    	}
    		    }
 				//隐藏列
    		    var instance = new GC.Spread.Sheets.CellRange(activeSheet, -1, columnNums, -1, 3, spreadNS.SheetArea.viewport);
    		    instance.visible(false);
 
    		  //自动调整行高列宽 参数为第几列
    		    activeSheet.autoFitColumn(0);
//    		    activeSheet.autoFitColumn(1);
    		    activeSheet.autoFitColumn(4);
    		    activeSheet.setColumnWidth(5, 240.0,GC.Spread.Sheets.SheetArea.colHeader);
    		   
    //		    activeSheet.getRange(0, -1, obj.length, -1, GC.Spread.Sheets.SheetArea.viewport).height(150);
    		    
/*     		    var instance = new GC.Spread.Sheets.CellRange(activeSheet, 0, -1, obj.length, -1, GC.Spread.Sheets.SheetArea.viewport);
    		    instance.height(100); */
    		    
    		    
    		    for(var i=0;i<obj.length;i++){
    		    	
     		    	var text=activeSheet.getCell(i,5).value();
    		    	if(!(typeof text == "undefined" || text == null || text == "" || text.length<30)){
	    		    	activeSheet.getCell(i,5).wordWrap(true);
	    		    	activeSheet.autoFitRow(i); 
    		    	}

    		    }
//    		    activeSheet.setColumnWidth(5, 240.0,GC.Spread.Sheets.SheetArea.colHeader);
				
				//筛选
				var filter = new spreadNS.Filter.HideRowFilter(new spreadNS.Range(-1, columnNums-4, -1, 4));
                activeSheet.rowFilter(filter);
                filter.filterButtonVisible(true);
				
				
				//居中
				var style = new GC.Spread.Sheets.Style();
				style.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
				style.vAlign = GC.Spread.Sheets.VerticalAlign.center;
				style.wordWrap = true;
				activeSheet.setStyle(-1,-1,style,GC.Spread.Sheets.SheetArea.viewport);
				
    		   //边框
            	activeSheet.getRange(-1, -1, -1, -1).setBorder(new spreadNS.LineBorder('black', spreadNS.LineStyle.thin), { all: true });
            	
            	spread.sheets[0].name(header[0]);
            	
              //单元格值改变事件
                spread.bind(spreadNS.Events.ValueChanged, function (e, args) {
                	console.log(args);
                	if(args.col==5){
	//                    alert(args.newValue);
	                    if(confirm("确认保存修改么？")){
	                    	
	                    	alert(activeSheet.getValue(1,columnNums+1));
	                    	var viewId=activeSheet.getValue(args.row,columnNums);
	                    	var userId=activeSheet.getValue(args.row,columnNums+1);
	                    	var msg=args.newValue;
	                    	submitMessage_bgg(args.newValue,userId,viewId)
	                    	$.ajax({
								type: "POST",
								url:  "url",
								dataType: "json",
								data: "userId=" + userId+"&remark="+msg+"&viewId="+viewId,
								async: false,
								success: function(data) {
									var result = data.result;
									if(result == 1){
										alert("修改成功");
										activeSheet.getCell(args.row,args.col).wordWrap(true);
					    		    	activeSheet.autoFitRow(args.row);
									}else{
										alert("修改失败")
									}
								}
							});
		                     
	                    }
                	}
                 });
                activeSheet.resumePaint();
                

            }
    	}); 
         
        
         
    }
    </script>
</html>

esheetSearch.js

$(function(){
	
	//自定已筛选
	function CustomFilter(){
	    GC.Spread.Sheets.ConditionalFormatting.Condition.apply(this, arguments);
	};
	CustomFilter.prototype = new GC.Spread.Sheets.ConditionalFormatting.Condition();
	CustomFilter.prototype.evaluate = function (evaluator, row, col) {
	    var value = evaluator.getValue(row, col);
	    if (value !== '' && isNumber(value.trim())) {
	        return true;
	    } else {
	        return false;
	    }
	};
	
	 document.getElementById('searchBtn').onclick = function() {
         var sheet = spread.getActiveSheet();
         var searchCondition = getSearchCondition();
         var searchResult = null;
         var sels = sheet.getSelections();
         if (sels.length > 1) {
             searchCondition.searchFlags |= spreadNS.Search.SearchFlags.blockRange;
         } else if (sels.length == 1) {
             var spanInfo = getSpanInfo(sheet, sels[0].row, sels[0].col);
             if (sels[0].rowCount != spanInfo.rowSpan && sels[0].colCount != spanInfo.colSpan) {
                 searchCondition.searchFlags |= spreadNS.Search.SearchFlags.blockRange;
             }
         }
         searchResult = getResultSearchinSheetEnd(searchCondition);
         if (searchResult == null || searchResult.searchFoundFlag == spreadNS.Search.SearchFoundFlags.none) {
             searchResult = getResultSearchinSheetBefore(searchCondition);
         }
         

         if (searchResult != null && searchResult.searchFoundFlag != spreadNS.Search.SearchFoundFlags.none) {
             spread.setActiveSheetIndex(searchResult.foundSheetIndex);
             var sheet = spread.getActiveSheet();
             sheet.setActiveCell(searchResult.foundRowIndex, searchResult.foundColumnIndex);
             if ((searchCondition.searchFlags & spreadNS.Search.SearchFlags.blockRange) == 0) {
                 sheet.setActiveCell(searchResult.foundRowIndex, searchResult.foundColumnIndex, 1, 1);
             }
             //scrolling
             if (searchResult.foundRowIndex < sheet.getViewportTopRow(1) ||
                 searchResult.foundRowIndex > sheet.getViewportBottomRow(1) ||
                 searchResult.foundColumnIndex < sheet.getViewportLeftColumn(1) ||
                 searchResult.foundColumnIndex > sheet.getViewportRightColumn(1)
             ) {
                 sheet.showCell(searchResult.foundRowIndex,
                     searchResult.foundColumnIndex,
                     spreadNS.VerticalPosition.center,
                     spreadNS.HorizontalPosition.center);
             } else {
                 sheet.repaint();
             }
         } else {
             //Not Found
             alert('Not Found');
         }
     };
     
     //罐子类型筛选
     $("#viewType").change(function(){
	   	 var sheet = spread.getActiveSheet(),
         filter = sheet.rowFilter(),
         value = $("#viewType").val();
         col = columnNums-1;
         if (filter) {
        	 if(''==value){
        		 value="*";
        	 }
             filter.removeFilterItems(col);
             var condition = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
                 compareType: spreadNS.ConditionalFormatting.TextCompareType.contains,
                 expected: value
             });
             filter.addFilterItem(col, condition);
             filter.filter();
             sheet.invalidateLayout();
             sheet.repaint();
         }
	   	});
     
     //月度差额
     $("#monthCE").change(function(){
	   	 var sheet = spread.getActiveSheet(),
         filter = sheet.rowFilter(),
         value = $("#monthCE").val();
         col = columnNums-4;
         if (filter) {
        	 if(''==value){
        		 value="*";
        	 }else if("Y"==value){
        		 value='已完成';
        	 }
             filter.removeFilterItems(col);
        	 var condition = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
        		 compareType: spreadNS.ConditionalFormatting.TextCompareType.contains,
        		 expected: value
        	 });
        	 if('N'==value){
        		 var condition1 = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
            		 compareType: spreadNS.ConditionalFormatting.TextCompareType.doesNotContain,
            		 expected: '已完成'
            	 });
        		 
        		 var condition2 = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
                     compareType: spreadNS.ConditionalFormatting.TextCompareType.notEqualsTo,
                     expected: ''
                 });
        		 var conditions=getComplexCondition(condition1,condition2);
            	 filter.addFilterItem(col, conditions);
        	 }else{
        		 filter.addFilterItem(col, condition);
        	 }
             filter.filter();
             sheet.invalidateLayout();
             sheet.repaint();
         }
	   	});
     
     //历史完成月度
     $("#hisCompletedMonth").change(function(){
	   	 var sheet = spread.getActiveSheet(),
         filter = sheet.rowFilter(),
         value = $("#hisCompletedMonth").val();
         col = columnNums-3;
         if (filter) {
        	 if(''==value){
        		 value="*";
        	 }else if('1个月'==value){
        		 value='/1个月';
        	 }
             filter.removeFilterItems(col);
             var condition = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
                 compareType: spreadNS.ConditionalFormatting.TextCompareType.contains,
                 expected: value
             });
             if('x个月'==value){
            	 var condition1 = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
                     compareType: spreadNS.ConditionalFormatting.TextCompareType.doesNotContain,
                     expected: '/1个月'
                 });
            	 var condition2 = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
                     compareType: spreadNS.ConditionalFormatting.TextCompareType.notEqualsTo,
                     expected: ''//null也可以
                 });
            	 
            	/* var condition2 = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.formulaCondition,{
            		 compareType: GC.Spread.Sheets.ConditionalFormatting.CustomValueType.nonEmpty
            	  });*/
            	 
            	 var conditions=getComplexCondition(condition1,condition2);
            	 filter.addFilterItem(col, conditions);
             }else{
            	 filter.addFilterItem(col, condition);
             }
             filter.filter();
             sheet.invalidateLayout();
             sheet.repaint();
         }
	   	});
     
     //上月是否完成规划
     $("#hasCompletedMonthPlan").change(function(){
	   	 var sheet = spread.getActiveSheet(),
         filter = sheet.rowFilter(),
         value = $("#hasCompletedMonthPlan").val();
         col = columnNums-2;
         if (filter) {
        	 if(''==value){
        		 value="*";
        	 }
             filter.removeFilterItems(col);
             var condition = new spreadNS.ConditionalFormatting.Condition(spreadNS.ConditionalFormatting.ConditionType.textCondition, {
                 compareType: spreadNS.ConditionalFormatting.TextCompareType.contains,
                 expected: value
             });
             filter.addFilterItem(col, condition);
             filter.filter();
             sheet.invalidateLayout();
             sheet.repaint();
         }
	   	});
     
     
});

function getComplexCondition(condition1,condition2){
	var conditions = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.relationCondition, {
        compareType: spreadNS.ConditionalFormatting.LogicalOperators.and,
        item1: condition1,
        item2: condition2
	});
	return conditions;
}

function getSpanInfo(sheet, row, col) {
	var span = sheet.getSpans(new spreadNS.Range(row, col, 1, 1));
	if (span.length > 0) {
		return {
			rowSpan : span[0].rowCount,
			colSpan : span[0].colCount
		};
	} else {
		return {
			rowSpan : 1,
			colSpan : 1
		};
	}
}

function getResultSearchinSheetEnd(searchCondition) {
	var sheet = spread.getActiveSheet();
	searchCondition.startSheetIndex = spread.getActiveSheetIndex();
	searchCondition.endSheetIndex = spread.getActiveSheetIndex();

	if (searchCondition.searchOrder == spreadNS.Search.SearchOrder.zOrder) {
		searchCondition.findBeginRow = sheet.getActiveRowIndex();
		searchCondition.findBeginColumn = sheet.getActiveColumnIndex() + 1;
	} else if (searchCondition.searchOrder == spreadNS.Search.SearchOrder.nOrder) {
		searchCondition.findBeginRow = sheet.getActiveRowIndex() + 1;
		searchCondition.findBeginColumn = sheet.getActiveColumnIndex();
	}

	if ((searchCondition.searchFlags & spreadNS.Search.SearchFlags.blockRange) > 0) {
		var sel = sheet.getSelections()[0];
		searchCondition.rowStart = sel.row;
		searchCondition.columnStart = sel.col;
		searchCondition.rowEnd = sel.row + sel.rowCount - 1;
		searchCondition.columnEnd = sel.col + sel.colCount - 1;
	}
	var searchResult = spread.search(searchCondition);
	return searchResult;
}

function getResultSearchinSheetBefore(searchCondition) {
	var sheet = spread.getActiveSheet();
	searchCondition.startSheetIndex = spread.getActiveSheetIndex();
	searchCondition.endSheetIndex = spread.getActiveSheetIndex();
	if ((searchCondition.searchFlags & spreadNS.Search.SearchFlags.blockRange) > 0) {
		var sel = sheet.getSelections()[0];
		searchCondition.rowStart = sel.row;
		searchCondition.columnStart = sel.col;
		searchCondition.findBeginRow = sel.row;
		searchCondition.findBeginColumn = sel.col;
		searchCondition.rowEnd = sel.row + sel.rowCount - 1;
		searchCondition.columnEnd = sel.col + sel.colCount - 1;
	} else {
		searchCondition.rowStart = -1;
		searchCondition.columnStart = -1;
		searchCondition.findBeginRow = -1;
		searchCondition.findBeginColumn = -1;
		searchCondition.rowEnd = sheet.getActiveRowIndex();
		searchCondition.columnEnd = sheet.getActiveColumnIndex();
	}

	var searchResult = spread.search(searchCondition);
	return searchResult;
}

function getResultSearchinWorkbookEnd(searchCondition) {
	searchCondition.rowStart = -1;
	searchCondition.columnStart = -1;
	searchCondition.findBeginRow = -1;
	searchCondition.findBeginColumn = -1;
	searchCondition.rowEnd = -1;
	searchCondition.columnEnd = -1;
	searchCondition.startSheetIndex = spread.getActiveSheetIndex() + 1;
	searchCondition.endSheetIndex = -1;
	var searchResult = spread.search(searchCondition);
	return searchResult;
}

function getResultSearchinWorkbookBefore(searchCondition) {
	searchCondition.rowStart = -1;
	searchCondition.columnStart = -1;
	searchCondition.findBeginRow = -1;
	searchCondition.findBeginColumn = -1;
	searchCondition.rowEnd = -1;
	searchCondition.columnEnd = -1;
	searchCondition.startSheetIndex = -1
	searchCondition.endSheetIndex = spread.getActiveSheetIndex() - 1;
	var searchResult = spread.search(searchCondition);
	return searchResult;
}

function getSearchCondition(searchString) {
	var searchCondition = new spreadNS.Search.SearchCondition();
	var searchString=$("#inputValue").val();
	searchCondition.searchString = searchString;
	searchCondition.startSheetIndex = spread.getActiveSheetIndex();
	searchCondition.endSheetIndex = spread.getActiveSheetIndex();
	searchCondition.searchOrder = spreadNS.Search.SearchOrder.zOrder;
	searchCondition.searchTarget = spreadNS.Search.SearchFoundFlags.cellText;
	searchCondition.searchFlags |= spreadNS.Search.SearchFlags.ignoreCase;
	return searchCondition;
}

 

纯前端表格控件SpreadJS示例教程：纳税单示例
qq_42444778的博客
03-02 559
SpreadJS是一款基于 HTML5 的纯前端电子表格控件，兼容 450 种以上的 Excel 公式，具有 “高性能、跨平台、与 Excel 高度兼容”的产品特性SpreadJS 为用户带来亲切的 Excel 使用体验的同时，满足 Web Excel 组件开发、表格文档协同编辑、数据填报、Excel 类报表设计等业务场景，极大降低了企业研发成本和项目交付风险。下面我们将讲述在使用SpreadJS进行开发时如何应用Excel主题。 下载最新版SpreadJS 下面的示例展示了如何用SpreadJS轻松.
SpreadJS设计使用说明书
最新发布
张先森的博客
02-14 732
图表的类型：area（地区图）、areaStacked（堆积面积图）、areaStacked100（百分比堆积面积图）、barClustered（集群条形图）、barStacked（堆积条形图）、barStacked100（百分比堆积条形图）、boxWhisker（箱线图）、bubble（气泡图）、clusteredColumn（群集列图）、columnClustered（聚簇柱状图）、columnClustered（聚簇柱状图）、columnClustered（聚簇柱状图）A1:H4'（图表基础数据!
SpreadJS_Demo3.zip
05-06
spreadjs打开服务器上的execl文件，然后进行编辑修改，然后再保存到服务器上； 此demo中spreadjs是使用版本可能远程保存存在问题，但是引入你的项目中没有问题，如有问题评论一下，我帮你解决；
SpreadJS 集成使用案例
一条咸鱼
12-27 2291
SpreadJS 基于 HTML5 标准，支持跨平台开发和集成，支持所有主流浏览器，无需预装任何插件或第三方组件，以原生的方式嵌入各类应用，可以与各类后端技术框架相结合。SpreadJS 以 纯前端、跨平台的能力，让应用系统轻松获得与原生Excel 一致的交互体验。
SpreadJS公式函数示例集合|附下载
weixin_34268843的博客
10-30 352
2019独角兽企业重金招聘Python工程师标准>>> ...
spreadjs-online-excel基础入门-demo
m0_44963501的博客
07-12 699
官网：https://demo.grapecity.com.cn/spreadjs/SpreadJSTutorial/quickstart/quickstart-vue 环境准备 l安装 nodejs 官网安装包 https://nodejs.org/en/ ，包含 npm 安装 Vue CLI 3 https://cli.vuejs.org/zh/ 终端运行：npm install -g @vue/cli 安装 TypeScript https://www.typescriptla
纯前端Excel表格控件SpreadJS,代码和例子下载
09-21
SpreadJS 是一款强大的纯前端Excel表格控件，它允许开发者在Web应用中实现与Microsoft Excel高度相似的功能。这款工具提供了一整套丰富的API和事件，让开发者能够轻松地在网页上创建、编辑和操作电子表格数据。...
Vue+SpringBoot+SpreadJS 实现的在线文档
12-19
项目中的"ExcelDemo"可能是一个演示或实例，展示了如何使用Vue、SpringBoot和SpreadJS创建一个基本的在线Excel编辑功能。它可能包含了初始化表格、读写数据、保存和加载工作簿等核心功能的代码示例。开发者可以通过...
如何在AngularJS中使用SpreadJS？
qq_42444778的博客
03-22 379
SpreadJS是一款基于 HTML5 的纯前端电子表格控件，兼容 450 种以上的 Excel 公式，凭借其 “高性能、跨平台、与 Excel 高度兼容”的产品特性，备受以华为、苏宁易购、天弘基金等为代表的企业用户青睐。SpreadJS 为用户带来亲切的 Excel 使用体验的同时，满足 Web Excel 组件开发、表格文档协同编辑、数据填报、Excel 类报表设计等业务场景，极大降低了企业研发成本和项目交付风险。 下载最新版SpreadJS SpreadJS支持 AngularJS. Ang..
spreadjs_集成 Echarts 并导出 PDFdemo.zip
09-09
标题 "spreadjs_集成 Echarts 并导出 PDFdemo.zip" 暗示这是一个使用 SpreadJS 库与 ECharts 图表结合，并实现 PDF 导出功能的示例项目。SpreadJS 是一款强大的 HTML5 表格组件，它提供了丰富的电子表格功能，而 ...
Vue+SpringBoot+SpreadJS 实现的在线文档功能.docx
07-12
`MySpreadJS` 组件接收来自后端的文件流，并使用 SpreadJS 的 `ExcelIO.IO().open()` 方法打开文件，然后将工作簿对象加载到 SpreadJS 的实例中。这样，用户就能在浏览器中看到并编辑Excel内容。 后端使用 ...
spreadjs_自定义右键菜单-demo.zip
09-09
spreadjs_自定义右键菜单-demo
spreadjs_包含合并单元格的数据绑定-demo.zip
09-09
spreadjs_包含合并单元格的数据绑定-demo
spreadjs_自定义表格筛选菜单内容-demo.zip
09-09
spreadjs_自定义表格筛选菜单内容-demo
spreadjs_公式追踪-demo.zip
09-09
spreadjs_公式追踪-demo
Spreadjs报表使用教程
张先森的博客
07-17 980
定义模板文件/数据文件名称。'YYYY年MM月DD日'添加 tzreport。引入 SpreadJS。
spreadjs使用
qq_34357018的博客
11-20 4632
初始化表单API const spreadNS = GC.Spread.Sheets; const SHEETS = new spreadNS.Workbook(this.refs['overseas']); // set sheet count // SHEETS.setSheetCount(1); const sheet = SHEETS.sheets[0]; 设置默认属性 const defaultStyle = new GC.Spread.Sheets.Style(); // 设置默认
SpreadJS 16.0 中文版在线电子表设计预览EXCEL-Crack
控件与插件之大全
02-28 1657
SpreadJS 纯前端表格控件 - V16.0 新特性:新文件结构是 SpreadJS 近几个版本中最为重要的架构级更新。这种新文件结构可以大大提高导入大型 Excel 文件的性能，同时在保存时创建更小、优化更好的文件。
vue引入spreadjs
qq_41615201的博客
01-30 2273
本文章记录vue 引入 SpreadJS 的方法
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值