转至元数据结尾
转至元数据起始

你可以使用 setColumnPageBreak  setRowPageBreak 设置分页符。

示例代码

以下代码在行和列上设置了分页符

JavaScript
activeSheet.suspendPaint();
//set value
             for (var r = 0, rc = activeSheet.getRowCount(); r < rc; r++) {
                 for (var c = 0, cc = activeSheet.getColumnCount(); c < cc; c++) {
                     activeSheet.setValue(r, c, r + c);
                 }
             }
activeSheet.resumePaint();
$("#button1").click(function(){
activeSheet.setRowPageBreak(3, true);
activeSheet.setColumnPageBreak(5, true);
alert(activeSheet.getRowPageBreak(3));
alert(activeSheet.getColumnPageBreak(5));
spread.print(0);
           })

更多信息
getColumnPageBreak Method
getRowPageBreak Method

  • 无标签