Field-Map Scripting

4.6.3.13 SetRowHeight

SetRowHeight procedure


Prototype:

procedure SetRowHeight(const row1,row2 :integer; const Height :integer);

Description:

Sets the height of rows in pixels.

Syntax:

xls.SetRowHeight(row1,row2, Height);  


Part

Description


xls

Variable declared as an instance of the TExcelWrapper class


row1

Variable declared as integer that represents row number of the first row to set height


row2

Variable declared as integer that represents row number of the last row to set height


Height

Variable declared as integer that represents height in pixels

Return value:

none


See also:

MergeCells , SetTextOrientation , Align , DrawBorders , FormatCells , AddUserFormat , AutofitCol , AutofitRow , SetOptimalColWidth , SetColWidth ,SetDefaultColWidth,SetRowHeight, SetDefaultRowHeight , SetColWidth_mm , SetRowHeight_mm , GetTextWidth , GetTextHeight , GetCellWidth, Complex example


Example:

Var
  Row, Rows, Cols:integer;
  xls :TExcelWrapper;
Begin
  {document preparation}
  //...
  {managing worksheets}
  //...
  {setting cell values}
  //...  
  
  {formatting cells examples}
  xls.AutofitCol(1,Cols,true,1.05); 
  xls.AutofitRow(1,Rows,true,1.05); 
  
  xls.SetRowHeight(1,1,15);
  xls.SetColWidth_mm(3,Cols-2,20.00);  
  xls.SetOptimalColWidth(Cols-2,Cols);

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