title: Programmatically alter an excel rows or columns heigh
body: <p>Probably easy one. How can i change rows or column heigh?</p>
  
  <pre><code> xlApp = new Excel.Application();
   xlApp.Visible = true;
   xlApp.DisplayAlerts = false;
   Excel.Workbooks xlWorkBooks = xlApp.Workbooks;
   xlWorkBook = xlWorkBooks.Open(directoryPath + "\\" + fileName, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
  
   xlWorkSheets = xlWorkBook.Worksheets; //Get all the sheets in the workbook
   xlWorkSheet = (Excel.Worksheet)xlWorkSheets.get_Item("Sheet1"); //Get the allready exists sheet
   Excel.Range range = xlWorkSheet.UsedRange;
   Excel.Range chartRange;
  
   int colCount = range.Columns.Count;
   int rowCount = range.Rows.Count;
  
    xlWorkSheet.Cells[rowCount + 5, 1] = "Name and surname";
    chartRange = xlWorkSheet.get_Range("a" + (rowCount + 5), "e" + (rowCount + 5));
    chartRange.Font.Bold = true;
  
   xlWorkBook.SaveAs(fileName, Excel.XlFileFormat.xlOpenXMLWorkbook, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
    xlWorkBook.Close(misValue, misValue, misValue);
    xlWorkSheet = null;
    xlWorkBook = null;
    xlApp.Quit();
  
    GC.WaitForPendingFinalizers();
    GC.Collect();
    GC.WaitForPendingFinalizers();
    GC.Collect();
  </code></pre>
  
  <p>Try it with <code>xlWorkSheet.UsedRange.EntireRow.Height = value;</code> but it doesn't work. <code>autoFit()</code> is working but i would like to work with my value.</p>