How to set Auto width

Topics: Developer Forum
Mar 4, 2011 at 3:53 AM

Hi i need to set the auto width to my excel output can anyone give soln fot this

Jan 16, 2012 at 2:51 PM

WS.Column(1).BestFit = true;

Mar 19, 2013 at 4:12 PM
Any idea why this doesn't work? I'm using Excel 2010.
Sep 29, 2013 at 11:28 AM
Use WS.Columns().AdjustToContents();

hope this will for for you...