首页 \ 问答 \ 以编程方式更改excel行或列的高度(Programmatically alter an excel rows or columns heigh)

以编程方式更改excel行或列的高度(Programmatically alter an excel rows or columns heigh)

 可能很容易。 如何更改行或列高度？  
 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()正在工作，但我想用我的价值。 

Probably easy one. How can i change rows or column heigh? 
 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();
 
Try it with xlWorkSheet.UsedRange.EntireRow.Height = value; but it doesn't work. autoFit() is working but i would like to work with my value.

原文：https://stackoverflow.com/questions/9922720

更新时间：2022-01-16 11:01

最满意答案

 您可以使用INFORMATION_SCHEMA，如下所示：  
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'Database Name'
AND TABLE_NAME = 'Table Name' and any condition you want...;

you can use INFORMATION_SCHEMA instead as following: 
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'Database Name'
AND TABLE_NAME = 'Table Name' and any condition you want...;

以编程方式更改excel行或列的高度(Programmatically alter an excel rows or columns heigh)

最满意答案

相关问答

TCP/IP模型是一个________。[2023-10-02]

下列中不属于面向对象的编程语言的是?[2022-05-30]

使用相关的子查询(Use Of Correlated Subquery)[2023-11-01]

DES子查询中的DESCRIBE(DESCRIBE in a FROM subquery)[2022-06-01]

DELETE FROM (DELETE FROM )[2022-01-07]

加入中的子查询(subquery in join)[2022-10-03]

如何形成子查询(How to form a subquery)[2024-01-14]

MySQL加入Subquery(MySQL Join on Subquery)[2022-03-21]

MySQL在WHERE中使用FROM中的子查询(MySQL use subquery from FROM in WHERE)[2023-06-28]

子查询不在猪中(subquery NOT IN in Pig)[2022-01-08]

相关文章

最新问答