C# 设置Excel单元格对齐方式

在Excel中对数据进行整理排版时，方式之一是通过调整单元格的对齐方式来优化页面排版结构。本经验将具体介绍C# 设置Excel单元格对齐方式的方法。

工具/原料

Free Spire.XLS for .NET（免费版）

Visual Studio

dll引用

1、可通过E-iceblue或Nuget官网下载安装Free Spire.XLS for .NET后，注意在项目程序中添加引用Spire.Xls.dll（dll文件可在安装路径下的Bin文件夹中获取）。

C# 代码示例（供参考）

1、using Spire.Xls;namespace CellsAlignment_XLS{ class Program { static void Main(string[] args) { //创建文档，并获取第一张工作表 Workbook wb = new Workbook(); Worksheet sheet= wb.Worksheets[0]; //添加文本到单元格 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[0].ColumnWidth = 15; sheet.Columns[1].ColumnWidth = 15; sheet.Columns[2].ColumnWidth = 15; sheet.Range["C3:C9"].RowHeight = 40; //保存文档 wb.SaveToFile("result.xlsx",FileFormat.Version2010); System.Diagnostics.Process.Start("result.xlsx"); } }}

2、完成代码后，调试程序，生成文档。如下：