<!-- SpreadJS语言设置（1）--><meta name="spreadjs culture" content="zh-cn" /><!-- jQuery、jQurey UI （2） --><script src="http://code.jquery.com/jquery-1.11.1.min.js" type="text/javascript"></script><script src="http://code.jquery.com/ui/1.11.0/jquery-ui.min.js" type="text/javascript"></script><!-- Wijmo CSS（3）--><link href="http://cdn.wijmo.com/themes/aristo/jquery-wijmo.css" rel="stylesheet" type="text/css" /><!-- SpreadJS（4） --><script src="http://cdn.wijmo.com/spreadjs/jquery.wijmo.wijspread.all.3.20142.11.min.js" type="text/javascript"></script><!-- SpreadJS CSS（5）--><link href="http://cdn.wijmo.com/spreadjs/jquery.wijmo.wijspread.3.20142.11.css" rel="stylesheet" type="text/css" />

<script id="scriptInit" type="text/javascript">$(document).ready( $(function () {// SpreadJS 初始化$("#wijspread1").wijspread();}));</script>

<div id="wijspread1" style="width: 480px; height: 320px; border: 1px solid gray"/>

<script id="scriptInit" type="text/javascript">$(document).ready( $(function () {// SpreadJS 初始化$("#wijspread1").wijspread({sheetCount: 3, //初始化为3个标签页newTabVisible:false //隐藏新建标签页按钮
                });}));</script>

          // 获得Spread 对象var spread = $("#wijspread1").wijspread("spread");// 获得当前激活的标签页var activeSheet = spread.getActiveSheet();// 获得第2行2列单元格var cell = activeSheet.getCell(1, 1);// 对这个单元格进行赋值cell.value("Wijmo SpreadJS");//单元格设置字体大小cell.font("15pt 宋体");// 当前标签页自动进行行、列适应大小activeSheet.autoFitColumn(1);activeSheet.autoFitRow(1);

          // 获得第2行2列 ~ 第4行5列，并设置背景色var cell = activeSheet.getCells(1, 1, 3, 4)cell.backColor("#00ff00");

          // 获得LineBorder属性var lineBorder = new $.wijmo.wijspread.LineBorder("#000000", $.wijmo.wijspread.LineStyle.thin);// 设置边框
            cell.borderTop(lineBorder);cell.borderBottom(lineBorder);cell.borderLeft(lineBorder);cell.borderRight(lineBorder);

          // 列結合activeSheet.addSpan(0, 0, 2, 4, $.wijmo.wijspread.SheetArea.colHeader);// 行結合activeSheet.addSpan(0, 0, 2, 4, $.wijmo.wijspread.SheetArea.rowHeader);// 单元格結合activeSheet.addSpan(0, 0, 2, 4, $.wijmo.wijspread.SheetArea.viewport);

        activeSheet.getCell(0, 0).value('考试成绩');// 各科成绩activeSheet.getCell(2, 0).value('语文');activeSheet.getCell(2, 1).value(80);activeSheet.getCell(3, 0).value('数学');activeSheet.getCell(3, 1).value(70);activeSheet.getCell(4, 0).value('英语');activeSheet.getCell(4, 1).value(90);activeSheet.getCell(5, 0).value('政治');activeSheet.getCell(5, 1).value(45);// 总分和平均分activeSheet.getCell(6, 0).value("总分");      // 总分activeSheet.getCell(6, 1).formula("SUM(B3:B6)");   activeSheet.getCell(7, 0).value('平均分');        //平均分activeSheet.getCell(7, 1).formula("AVERAGE(B3:B6)");

//数据输出function ExportJSON(){// 获得Spread 对象var spread = $("#wijspread1").wijspread("spread");var jsonStr = JSON.stringify(spread.toJSON());$("#jsonCode").html(jsonStr);}////数据输入function ImportJSON(){// 获得Spread 对象var spread = $("#wijspread1").wijspread("spread");var jsonObj = JSON.parse($("#jsonCode").html());spread.fromJSON(jsonObj);            }

//导出CSV字符串function ExportCSV() {// 获得Spread 对象var spread = $("#wijspread1").wijspread("spread");var csvString = spread.getActiveSheet().getCsv(0,                                       // 开始行0,                                       // 开始列10,                                      // 行数5,                                       // 列数"\n",                                    // 行分割字符","                                      // 列分割字符
            );$("#jsonCode").html(csvString);}//导入CSV字符串function ImportCSV() {// 获得Spread 对象var spread = $("#wijspread1").wijspread("spread");var csvString = $("#jsonCode").html();spread.getActiveSheet().setCsv(0,                                       // 开始行0,                                       // 开始列csvString,                               // CSV字符串"\n",                                    // 行分割字符",",                                     // 列分割字符$.wijmo.wijspread.TextFileOpenFlags.None // 导入选项
            );}