HotXLS-documentatie
Startpagina Inhoud Overzicht

AutoFit methode

Changes the width of the columns in the range of the height of the rows in the range to achieve the best fit

Syntaxis

procedure AutoFit(Columns: boolean);
Columns boolean. true to change the width of the columns; False to change the height of the rows

Voorbeeld

this example changes the width of the columns in the used range to achieve the best fit 

Workbook.Sheets[1].UsedRange.AutoFit(True);
This example is the same to the previous 

Workbook.Sheets[1].UsedRange.Columns.AutoFit;
this example changes the height of the rows in the used range to achieve the best fit 

Workbook.Sheets[1].UsedRange.AutoFit(False);
This example is the same to the previous 

Workbook.Sheets[1].UsedRange.Rows.AutoFit;