c# - 以编程方式更改 Excel 行或列的高度

应该很容易吧。如何更改行高或列高？

 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();

用 xlWorkSheet.UsedRange.EntireRow.Height = value; 试试，但它不起作用。 autoFit() 正在工作，但我想利用我的值(value)。

最佳答案

我想你可能正在寻找 RowHeight ...

http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.namedrange.rowheight(v=vs.80).aspx

关于c# - 以编程方式更改 Excel 行或列的高度，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/9922720/