4.6.4.9 SetTitleRows

SetTitleRows procedure

Prototype:	procedure SetTitleRows( const R1, R2 :integer);
Description:	Sets the rows to repeat as titles at the top of every printed page if a worksheet produces more than one printed page
Syntax:	xls.SetTitleRows( R1, R2);
	Part	Description
	xls	Variable declared as an instance of the TExcelWrapper class
	R1	Variables declared as integer that represents row number of the first row to be repeated
	R2	Variables declared as integer that represents row number of the last row to be repeated
Return value:	none

See also:

Landscape , SetPrintMargins , SetHeader , SetFooter , SetHeaderAndFooter , SetFirstHeaderAndFooter , SetTitleRows , SetTitleRowsAndCols , InsertHPageBreak , InsertVPageBreak , CreateHeaderOfTableContent , CreateTableOfContent , AddBackToTableOfContent , SetPrintArea , RowCount , ColCount , Header and footer codes , Predefined paper sizes, KeepColsTogether, KeepRowsTogether, AutoPageBreaks, PrintNumberOfHorizontalPages, PrintNumberOfVerticalPages, PrintToFit, Complex example

Example:

Var
  Row, Rows, Cols:integer;
  xls :TExcelWrapper;
Begin
  {document preparation}
  //...
  {managing worksheets}
  {setting cell values}

  xls.Landscape:=true;
  xls.SetPaperSize('A4');
  xls.SetPrintArea(1,1,Cols, Rows);
  xls.SetPrintMargins(25,25,20,25,10,10);
  xls.InsertHPageBreak(10,true);

  {making the sheet fit in one page of width }
  xls.PrintNumberOfHorizontalPages:=1; 
  xls.PrintToFit:=true;


  {document saving / previewing}
  //...
End.