How to set Auto width

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

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

Jan 16, 2012 at 3:51 PM

WS.Column(1).BestFit = true;

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

hope this will for for you...