使用行与列

SpreadJS允许您对行和列执行各种操作，如下所述:

增加行和列

本示例增加行和列。

window.onload = function()
{
 var spread =
 new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
 var sheet = spread.getActiveSheet();
 var sheet = spread.getActiveSheet();

 // 设置行数为3
 sheet.setRowCount(3, GC.Spread.Sheets.SheetArea.viewport);
 sheet.setValue(0, 0, "Row 1", GC.Spread.Sheets.SheetArea.viewport);
 sheet.setValue(1, 0, "Row 2", GC.Spread.Sheets.SheetArea.viewport);
 sheet.setValue(2, 0, "Row 3", GC.Spread.Sheets.SheetArea.viewport);
 sheet.setColumnWidth(0, 90.0, GC.Spread.Sheets.SheetArea.viewport);

 $("#button1").click(function()
   {
     // 在行2下增加一行.  
     sheet.addRows(1, 1);
     sheet.setValue(1, 0, "Added row");
   });

 $("#button2").click(function()
   {
    // 在列2后增加一列
    sheet.addColumns(1, 1);
    sheet.setValue(0, 1, "Added column");
  });
}

删除行和列

本示例删除行和列

$(document).ready(function ()
  {
    var spread =
    new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
    var sheet = spread.getActiveSheet();
   
    // 设置行数为3
    sheet.setRowCount(3, GC.Spread.Sheets.SheetArea.viewport);
    sheet.setValue(0, 0, "The 1st row", GC.Spread.Sheets.SheetArea.viewport);
    sheet.setValue(1, 0, "The 2st row", GC.Spread.Sheets.SheetArea.viewport);
    sheet.setValue(2, 0, "The 3st row", GC.Spread.Sheets.SheetArea.viewport);
    sheet.setColumnWidth(0, 90.0, GC.Spread.Sheets.SheetArea.viewport);
    $("#button1").click(function()
     {
        // 删除行2
        spread.getActiveSheet().deleteRows(1, 1);
     });
   
    $("#button2").click(function()
     {
       // 删除列2.
       spread.getActiveSheet().deleteColumns(1, 1);
     });
});

设置行数列数

本示例设置行数和列数

$(document).ready(function ()
{
    var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),
    {sheetCount:3});
    var sheet = spread.getActiveSheet();
   
    // 设置行数、列数为3
    sheet.setRowCount(3, GC.Spread.Sheets.SheetArea.viewport);
    sheet.setColumnCount(3, GC.Spread.Sheets.SheetArea.viewport);
});

使用setRowCount/setColumnCount方法设置行/列数时，如果计数参数小于旧计数，则行/列将被删除，而不管行/列是否包含数据、公式或其他任何内容。

但是，您可以使用UsedRangeType枚举选项防止删除行/列。

以下代码示例显示如何在 setRowCount 方法中使用 UsedRangeType 枚举：

sheet.setRowCount(5, GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.UsedRangeType.span);

注意：只有当新的行/列的数量小于现有的行/列的数量时，保护行/列不被删除才有意义。

设置行高和列宽

本示例设置行高和列宽

$(document).ready(function ()
{
    var spread =
    new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
    var sheet = spread.getActiveSheet();
   
    //改变第二行的行高
    sheet.setRowHeight(1, 90.0,GC.Spread.Sheets.SheetArea.viewport);
   
    //改变第二列的列宽
    sheet.setColumnWidth(1, 120.0,GC.Spread.Sheets.SheetArea.viewport);
});

选择和取消选择行。

此示例选择和取消选择行。

window.onload = function()
{
  var spread =
  new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
  var activeSheet = spread.getActiveSheet();
  activeSheet.setColumnCount(5);
     $("#button1").click(function()
     {
         // 选择整个第4行。
        activeSheet.addSelection(3, -1, 1, -1);
     });
    
     $("#button2").click(function()
      {
         // 删除表单中的选择。
         activeSheet.clearSelection();
     });
}

设置顶部行和列

$("#button1").click(function ()
{
    var activeSheet = spread.getActiveSheet();
    activeSheet.showRow(9, GC.Spread.Sheets.VerticalPosition.top);
});

$("#button2").click(function()
{
    var activeSheet = spread.getActiveSheet();
    activeSheet.showColumn(9, GC.Spread.Sheets.HorizontalPosition.left);
});

获取显示单元格的索引

本示例获取显示单元格的索引

$("#button1").click(function ()
{
    var spread =
    new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
    var sheet = spread.getActiveSheet();
   
    // 获取顶行(列)索引
    var topRow = sheet.getViewportTopRow(1);
    var leftCol = sheet.getViewportLeftColumn(1);
    alert("Index of top row being displayed: " + topRow + "\n" +
        "Index of first column being displayed: " + leftCol);
});