What is the most elegant way to have the column width for each column be the size of the largest entry so no resizing is needed upon program runtime? Is there any built in feature that allows auto-sizing? If not I would recommend one in the new features forum. Any solutions please? Already I have tried measuring the size of the biggest string in each column by means of loops. Then trying to convert string length to pt which is very difficult as not all chars are the same length. Then setting the sheet.Columns[x].Width = xpt for each x columns. There has to be a better way? Hopefully a built in one.

Hi,

You can use the ResizeColumnToFit or ResizeColumnsToFit methods in the WorkbookView class to resize one or multiple columns to fit their content.

I hope this helps.

Regards,
Meppy