你可以使用 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); })