如何修改我的EXCEL工作表中所有非空行的行高?谢谢! w.
...EntireRow.RowHeight = value;
xlWorkSheet.Rows.RowHeight = height;
xlWorkSheet.StandardWidth = width;
Microsoft.Office.Tools.Excel.NamedRange
,而不是所讨论的对象。 - AlainMySheet.UsedRange.EntireRow.Height = value;
MySheet.UsedRange.EntireRow.Height
似乎是只读属性,无法进行设置。 - bdharMySheet.UsedRange.EntireRow.Height
只读模式。
不幸的是,它无法工作。
请尝试以下方法:
NamedRange.RowHeight = X;
var SomeCell = (Excel.Range)_xlSheet.Cells[1, 1];
SomeCell.Value2 = "What was D.D. Eisenhower's Gettysburg Address?";
SomeCell.RowHeight = 32;
试试这个
sampleRange.Resize.RowHeight=x; //x的类型必须是int
using (XLWorkbook xLWorkbook = new XLWorkbook())
{
var wordsheet = xLWorkbook.Worksheets.Add(dtEmpDetail, status);
wordsheet.Row(2).Height = 50;
wordsheet.Range("A1:d2").Merge();
}
尝试这个,你可以使用类似以下的for循环来遍历所有行:
int i = 0;
for (var i = 0; i < column.Count(); i++)
{
worksheet.Row(i).Height = 100;
}