Board index » delphi » Excel-Command for formatting columnwidth

Excel-Command for formatting columnwidth

Does anybody knows the command for formattings colums with their optimal
size?

Thanks in advance

--
Regards
Nicolas Bronke

 

Re:Excel-Command for formatting columnwidth


<<Nicolas Bronke:
Does anybody knows the command for formattings colums
with their optimal size?

Quote

The Autofit method of a range can do this. So you could
do something like:
Worksheet.Range['A1', 'H1'].Columns.AutoFit;

--
Deborah Pate

Re:Excel-Command for formatting columnwidth


Quote
> <<Nicolas Bronke:
> Does anybody knows the command for formattings colums
> with their optimal size?

> The Autofit method of a range can do this. So you could
> do something like:
> Worksheet.Range['A1', 'H1'].Columns.AutoFit;

Thanks a lot

--
Regards
Nicolas Bronke

Other Threads