//初始化Workbook对象
Workbook workbook = new Workbook();
//获取第一个工作表
Worksheet sheet = workbook.Worksheets[0];
//写入文本到B1,C1
sheet.Range["B1"].Text = "数字格式";
sheet.Range["C1"].Text = "数字±12345678应用格式后的效果";
sheet.Range["B1"].Style.Font.IsBold = true;
sheet.Range["C1"].Style.Font.IsBold = true;
//在B3中写入文本(即数字格式),在C3中写数字并应用数字格式
sheet.Range["B3"].Text = "0";
sheet.Range["C3"].NumberValue = 12345678;
sheet.Range["C3"].NumberFormat = "0";
//重复上面的步骤写入更多格式及对应效果
sheet.Range["B4"].Text = "0.00";
sheet.Range["C4"].NumberValue = 12345678;
sheet.Range["C4"].NumberFormat = "0.00";
sheet.Range["B5"].Text = "#,##0.00";
sheet.Range["C5"].NumberValue = 12345678;
sheet.Range["C5"].NumberFormat = "#,##0.00";
sheet.Range["B6"].Text = "¥#,##0.00";
sheet.Range["C6"].NumberValue = 12345678;
sheet.Range["C6"].NumberFormat = "¥#,##0.00";
sheet.Range["B7"].Text = "0;[Red]-0";
sheet.Range["C7"].NumberValue = -12345678;
sheet.Range["C7"].NumberFormat = "0;[Red]-0";
sheet.Range["B8"].Text = "0.00;[Red]-0.00";
sheet.Range["C8"].NumberValue = -12345678;
sheet.Range["C8"].NumberFormat = "0.00;[Red]-0.00";
sheet.Range["B9"].Text = "#,##0;[Red]-#,##0";
sheet.Range["C9"].NumberValue = -12345678;
sheet.Range["C9"].NumberFormat = "#,##0;[Red]-#,##0";
sheet.Range["B10"].Text = "#,##0.00;[Red]-#,##0.000";
sheet.Range["C10"].NumberValue = -12345678;
sheet.Range["C10"].NumberFormat = "#,##0.00;[Red]-#,##0.00";
sheet.Range["B11"].Text = "0.00E+00";
sheet.Range["C11"].NumberValue = 12345678;
sheet.Range["C11"].NumberFormat = "0.00E+00";
sheet.Range["B12"].Text = "0.00%";
sheet.Range["C12"].NumberValue = 12345678;
sheet.Range["C12"].NumberFormat = "0.00%";
//设置[B3:B12]、[C3:C12]背景颜色
sheet.Range["B3:B12"].Style.KnownColor = ExcelColors.Gray25Percent;
sheet.Range["C3:C12"].Style.KnownColor = ExcelColors.Gray50Percent;
//设置2、3列列宽
sheet.Columns[1].ColumnWidth = 25;
sheet.Columns[2].ColumnWidth = 30;
//保存文档
workbook.SaveToFile("output.xlsx", ExcelVersion.Version2013);
C# Excel 中设置文字对齐方式、方向和换行
在Excel表格中输入文字时,我们常常需要调整文字对齐方式或者对文字进行换行。接下来将介绍如何通过编程的方式设置文字对齐方式,改变文字方向以及对文字进行换行。
//创建Workbook对象 Workbook wookbook = new Workbook(); Worksheet sheet = wookbook.Worksheets[0]; //添加说明文字 sheet.Range["B1"].Text = "文字对齐方式"; sheet.Range["D1"].Text = "文字方向"; sheet.Range["F1"].Text = "文字换行"; sheet.Range["B1:F1"].Style.Font.IsBold = true; //左对齐 sheet.Range["B3"].Text = "左对齐"; sheet.Range["B3"].Style.HorizontalAlignment = HorizontalAlignType.Left; //水平居中 sheet.Range["B4"].Text = "水平居中"; sheet.Range["B4"].Style.HorizontalAlignment = HorizontalAlignType.Center; //右对齐 sheet.Range["B5"].Text = "右对齐"; sheet.Range["B5"].Style.HorizontalAlignment = HorizontalAlignType.Right; //居上 sheet.Range["B7"].Text = "居上"; sheet.Range["B7"].Style.VerticalAlignment = VerticalAlignType.Top; //居中 sheet.Range["B8"].Text = "垂直居中"; sheet.Range["B8"].Style.VerticalAlignment = VerticalAlignType.Center; //居下 sheet.Range["B9"].Text = "居下"; sheet.Range["B9"].Style.VerticalAlignment = VerticalAlignType.Bottom; //分散对齐并居中 sheet.Range["B10"].Text = "水平分散对齐+垂直居中"; sheet.Range["B10"].Style.HorizontalAlignment = HorizontalAlignType.Distributed; sheet.Range["B10"].Style.VerticalAlignment = VerticalAlignType.Center; //逆时针旋转45° sheet.Range["D7"].Text = "旋转45°"; sheet.Range["D7"].Style.Rotation = 45; //逆时针旋转90° sheet.Range["D8"].Text = "旋转90°"; sheet.Range["D8"].Style.Rotation = 90; //顺时针旋转45° sheet.Range["D9"].Text = "旋转-45°"; sheet.Range["D9"].Style.Rotation = 135; //顺时针旋转90° sheet.Range["D10"].Text = "旋转-90°"; sheet.Range["D10"].Style.Rotation = 180; //添加‘\n’进行文字换行 sheet.Range["F9"].Text = "这是\n手动\n换行"; //自动换行 sheet.Range["F10"].Text = "这是自动换行(额外测试文字)"; sheet.Range["F10"].Style.WrapText = true; //设置列宽、行高 sheet.Columns[1].ColumnWidth = 15; sheet.Columns[3].ColumnWidth = 15; sheet.Columns[5].ColumnWidth = 15; sheet.Range["B3:B5"].RowHeight = 15; sheet.Range["B7:B10"].RowHeight = 50;
: 调用BorderInside()和BorderAround()方法将样式应用于范围内和范围的边界。 若要将边框添加到顶部,底部,左侧和右侧,请使用边框[BordersLineType.EdgeTop] .LineStyle属性,边框[BordersLineType.EdgeBottom] .LineStyle属性等。 range.BorderInside(LineStyleType.Thin, Color.Blue); range.BorderAround(LineStyleType.Medium, Color.Blue)
//保存文档 wookbook.SaveToFile("TextAlignment.xlsx", FileFormat.Version2013);