4.6.3.10 SetOptimalColWidth

SetOptimalColWidth procedure

Prototype:	procedure SetOptimalColWidth(const col1,col2 :integer; const Adjustment :double{e.g. 1.05});
Description:
Syntax:	xls.SetOptimalColWidth(col1,col2, 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 optimise the width
	col2	Variable declared as integer that represents column number of the last column to optimise the width
	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 rows will be adjusted to 110% percent of what their calculated height was. Use this parameter to fine-tune autofiting, if for example rows 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.