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

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

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、完成代码后，调试程序，生成文档。如下：