Row Height

Oct 4, 2014 at 9:18 AM
Having trouble setting row height

oWorksheet.Cells(1, 1).Row.Height =20

Doesn't actually set the height???
Oct 5, 2014 at 8:38 AM
Actually I was does set the ht value when you look inside the XML file just when the file is opened in Excel the row heights don't seem to match.

a value of <row r="1" ht="20"> is sheet1.xml appears as a row height in Excel of 16.5