4.6.3.8 AutofitCol

AutoFitCol procedure

Prototype:	procedure AutofitCol(const col1,col2 :integer; const ignoreStrings :boolean; const adjustment :double);
Description:	Autofits a column so it adapts its height to show all the text inside.
Syntax:	xls.AutofitCol(col1,col2,ignoreStrings,adjustment);
	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 autofit
	col2	Variable declared as integer that represents column number of the last column to autofit
	ignoreStrings	Variable declared as boolean. When true, strings will not be considered for the autofit. Only numbers will.
	adjustment	Variable declared as double. You will normally want to set this parameter to 1, which means that autofit will be made with standard measurements. If you set it to for example 1.1, then columns will be adjusted to 110% percent of what their calculated width was. Use this parameter to fine-tune autofiting, if for example columns are too small when opening the file in Excel.
Return value:	none

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.