HotXLS 文档

Add 方法

按范围、行号或 A1 样式引用添加水平分页符,并返回一个 TXLSHPageBreak object

语法

function Add(Before: IXLSRange): TXLSHPageBreak;
function Add(BeforeRow: Integer): TXLSHPageBreak;
function Add(ARange: WideString): TXLSHPageBreak;
      
Before IXLSRange。一个 Range 对象,新分页符将添加到该范围的上方
BeforeRow One-based row before which the horizontal page break will be added
ARange A1-style cell reference used to choose the row for the horizontal page break

示例

此示例在单元格 G15 上方添加水平分页符,并在该单元格左侧添加垂直分页符

With Workbook.Sheets[1] do
begin
  HPageBreaks.Add('G15');
  HPageBreaks.Add(20);
end;