Field-Map Scripting

4.6.3.11 SetColWidth

SetColWidth procedure


Prototype:

procedure SetColWidth(const col1,col2 :integer; const Width :integer);

Description:

Sets the width of columns in pixels.

Syntax:

xls.SetColWidth(col1,col2,Width)


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

Variable declared as integer that represents width 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.