طريقة AutoFit

Workbook.Sheets[1].UsedRange.AutoFit(True);

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

Workbook.Sheets[1].UsedRange.AutoFit(False);

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