4.6.4.10 SetTitleRowsAndCols

SetTitleRowsAndCols procedure

Prototype:	procedure SetTitleRowsAndCols( const R1, R2, C1,C2 :integer);
Description:	Sets the rows and columns to repeat as titles at the top and left of every printed page if a worksheet produces more than one printed page
Syntax:	xls.SetTitleRowsAndCols( R1, R2, C1, C2);
	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
	C1	Variables declared as integer that represents column number of the first column to be repeated
	C2	Variables declared as integer that represents column number of the last column to be repeated
Return value:	none

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.