我正在尝试将文本垂直居中,但是无法实现。文本在合并单元格的底部显示。以下是未能正常工作的最小化代码。
// get handle to the existing worksheet
ExcelWorksheet worksheet = xlPackage.Workbook.Worksheets.Add("mysheet");
//[row,col]
worksheet.Cells[1, 1].Value = "a1";
worksheet.Cells[2, 1].Value = "a1";
worksheet.Cells[3, 1].Value = "a1";
worksheet.Cells[4, 1].Value = "a1";
worksheet.Cells[5, 1].Value = "a1";
worksheet.Cells[6, 1].Value = "a1";
//comment out below six lines to make it work
worksheet.Cells[1, 2].Value = "11";
worksheet.Cells[2, 2].Value = "12";
worksheet.Cells[3, 2].Value = "13";
worksheet.Cells[4, 2].Value = "14";
worksheet.Cells[5, 2].Value = "15";
worksheet.Cells[6, 2].Value = "16";
//comment out above six lines to make it work
worksheet.Cells["A1:A6"].Merge = true;
worksheet.Cells["A1:A6"].Style.VerticalAlignment = ExcelVerticalAlignment.Center;
xlPackage.Save();
请帮忙。
在结尾添加以下代码即可使其正常工作:
worksheet.Column(1).Style.VerticalAlignment = ExcelVerticalAlignment.Center; worksheet.Column(2).Style.VerticalAlignment = ExcelVerticalAlignment.Center;
这意味着我必须将所有列都居中对齐,才能将第一列居中对齐。