- <!doctype html>
- <html>
- <head>
- <title></title>
- <meta charset="utf-8" />
- <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
- <link href="http://demo.gcpowertools.com.cn/SpreadJS/TutorialSample/external/spreadjs/css/gcspread.sheets.excel2013white.9.40.20153.0.css" rel="stylesheet" type="text/css" />
- <script src="http://demo.gcpowertools.com.cn/SpreadJS/TutorialSample/external/external/jquery-1.8.2.min.js" type="text/javascript"></script>
- <script type="text/javascript" src="http://demo.gcpowertools.com.cn/SpreadJS/TutorialSample/external/spreadjs/gcspread.sheets.all.9.40.20153.0.min.js"></script>
-
- <style type="text/css">
- .demo-options, .option-row {
- margin-top: 10px;
- }
- </style>
- <script type="text/javascript">
- var spreadNS = GcSpread.Sheets;
- $(document).ready(function ()
- {
- var spread = new GcSpread.Sheets.Spread(document.getElementById("ss"));
- initSpread(spread);
- });
- function initSpread(spread)
- {
- var sheet = spread.getSheet(0);
- sheet.isPaintSuspended(true);
- sheet.setColumnWidth(0, 100);
- sheet.setColumnWidth(1, 170);
-
-
- datas = {tasks:[{table_line_xh:1, lrrq:1423584000000, xgrq:1423584000000},
- { table_line_xh:2, lrrq:1423584000000, xgrq:1423584000000}]};
-
- var dataSourceSH = new GcSpread.Sheets.CellBindingSource(datas);
-
- sheet.setDataSource(dataSourceSH);
-
- sheet.setBorder(new GcSpread.Sheets.Range(17, 1, 2, 4), new GcSpread.Sheets.LineBorder("#58B6C0", GcSpread.Sheets.LineStyle.thin), { top: false, bottom: true, innerHorizontal: true });
- var table = sheet.addTable("tableRecords", 1, 0, 4, 4, GcSpread.Sheets.TableStyles.light2());
-
- table.bindingPath("tasks");
- table.showHeader(false);
- table.filterButtonVisible(false);
- table.autoGenerateColumns(false);
- var tableColumn1 = new GcSpread.Sheets.TableColumnInfo();
- tableColumn1.dataField("table_line_xh");
- var tableColumn2 = new GcSpread.Sheets.TableColumnInfo();
- tableColumn2.dataField("lrrq");
- var tableColumn3 = new GcSpread.Sheets.TableColumnInfo();
- tableColumn3.dataField("xgrq");
- table.bindColumns([tableColumn1,tableColumn2, tableColumn3]);
- sheet.isPaintSuspended(false);
- };
- </script>
- </head>
- <body>
- <div class="sample-turtorial">
- <div id="ss" style="width:100%; height: 420px;border: 1px solid gray;"></div>
- </div>
- </body>
- </html>
复制代码
关于取值,如下方法都可以:
activeSheet.getText(1,1)
activeSheet.getCell(1,1).text()
这两个写法是一样的。 |