Field-Map Scripting

4.6.3.15 SetColWidth_mm

SetColWidth_mm procedure


Prototype:

procedure SetColWidth_mm(const col1,col2 :integer; const Width_mm :integer);

Description:

Sets the width of columns¨in mm.

Syntax:

xls.SetColWidth(col1,col2,Width_mm)


Part

Description


xls

Variable declared as an instance of the TExcelWrapper class


col1

Variable declared as integer that represents column number of the first column to set width


col2

Variable declared as integer that represents column number of the last column to set width


Width_mm

Variable declared as integer that represents width in mm

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.