SimoneC# 设置Excel单元格对齐方式
的有关信息介绍如下：
在Excel中对数据进行整理排版时，方式之一是通过调整单元格的对齐方式来优化页面排版结构。本经验将具体介绍C# 设置Excel单元格对齐方式的方法。
可通过E-iceblue或Nuget官网下载安装Free Spire.XLS for .NET后，注意在项目程序中添加引用Spire.Xls.dll（dll文件可在安装路径下的Bin文件夹中获取）。
using Spire.Xls;
namespace CellsAlignment_XLS
{
class Program
{
static void Main(string[] args)
{
//创建文档，并获取第一张工作表
Workbook wb = new Workbook();
Worksheet sheet= wb.Worksheets;
//添加文本到单元格
sheet.Range["A1"].Text = "水平对齐方式";
sheet.Range["C1"].Text = "垂直对齐方向";
sheet.Range["A1:C1"].Style.Font.IsBold = true;
//设置文本对齐方式
sheet.Range["A3"].Text = "左对齐";
sheet.Range["A3"].Style.HorizontalAlignment = HorizontalAlignType.Left;
sheet.Range["A5"].Text = "水平居中对齐";
sheet.Range["A5"].Style.HorizontalAlignment = HorizontalAlignType.Center;
sheet.Range["A7"].Text = "右对齐";
sheet.Range["A7"].Style.HorizontalAlignment = HorizontalAlignType.Right;
sheet.Range["A9"].Text = "水平分散对齐";
sheet.Range["A9"].Style.HorizontalAlignment = HorizontalAlignType.Distributed;
sheet.Range["B4"].Text = "水平居中+垂直居中对齐";
sheet.Range["B4"].Style.HorizontalAlignment = HorizontalAlignType.Center;
sheet.Range["B4"].Style.VerticalAlignment = VerticalAlignType.Center;
sheet.Range["C3"].Text = "垂直居上";
sheet.Range["C3"].Style.VerticalAlignment = VerticalAlignType.Top;
sheet.Range["C5"].Text = "垂直居中";
sheet.Range["C5"].Style.VerticalAlignment = VerticalAlignType.Center;
sheet.Range["C7"].Text = "垂直居下";
sheet.Range["C7"].Style.VerticalAlignment = VerticalAlignType.Bottom;
sheet.Range["C9"].Text = "垂直分散对齐";
sheet.Range["C9"].Style.VerticalAlignment = VerticalAlignType.Distributed;
//调整列宽、行高
sheet.Columns.ColumnWidth = 15;
sheet.Columns.ColumnWidth = 15;
sheet.Columns.ColumnWidth = 15;
sheet.Range["C3:C9"].RowHeight = 40;
//保存文档
wb.SaveToFile("result.xlsx",FileFormat.Version2010);
System.Diagnostics.Process.Start("result.xlsx");
}
}
}
完成代码后，调试程序，生成文档。如下：
