I am creating a worksheet that has a column with some wide strings in it. I would like the column width tp be set so that all of the data within the column is shown. (i.e. The same as double clicking on the column separator within Excel ).
I assumed that I could use code like :
worksheet.Column(1).BestFit = true;
but this does not seem to work, the column is not resized.
I tried adding this code before I populate the worksheet, and then again afterwards - but neither seem to work.
Can anyone point out where I am going wrong.