Field-Map Scripting

4.6.3.19 GetCellWidth

GetCellWidth function


Prototype:

function GetCellWidth(const Row,Col :integer; const Format_ :string) :integer;  

Description:

Gets the total width of the specified cell of the specified format.

Syntax:

xls.GetCellWidth(row,col,format);  


Part

Description


xls

Variable declared as an instance of the TExcelWrapper class


Row

Variable declared as integer that represents row number


Col

Variable declared as integer that represents column number


Format

Variable declared as string that represents the format name

Return value:

The width of the specified cell of the specified format


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.