次のサンプルコードは、印刷用の行改ページを設定します。
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();
activeSheet.setRowPageBreak(3, true);
activeSheet.setColumnPageBreak(5, true);
alert(activeSheet.getRowPageBreak(3));
alert(activeSheet.getColumnPageBreak(5));
//Remove following comment to use the print method
//spread.print(0);