Aspose.Cell篇章3，设置写入到Excel文件的各种样式及输出

Aspose.Cell的Style.Number设置全部设置

/// <summary>

/// 单元格样式编号

/// 0 General General

/// 1 Decimal 0

/// 2 Decimal 0.00

/// 3 Decimal #,##0

/// 4 Decimal #,##0.00

/// 5 Currency $#,##0;$-#,##0

/// 6 Currency $#,##0;[Red]$-#,##0

/// 7 Currency $#,##0.00;$-#,##0.00

/// 8 Currency $#,##0.00;[Red]$-#,##0.00

/// 9 Percentage 0%

/// 10 Percentage 0.00%

/// 11 Scientific 0.00E+00

/// 12 Fraction # ?/?

/// 13 Fraction # ??/??

/// 14 Date m/d/yy

/// 15 Date d-mmm-yy

/// 16 Date d-mmm

/// 17 Date mmm-yy

/// 18 Time h:mm AM/PM

/// 19 Time h:mm:ss AM/PM

/// 20 Time h:mm

/// 21 Time h:mm:ss

/// 22 Time m/d/yy h:mm

/// 37 Currency #,##0;-#,##0

/// 38 Currency #,##0;[Red]-#,##0

/// 39 Currency #,##0.00;-#,##0.00

/// 40 Currency #,##0.00;[Red]-#,##0.00

/// 41 Accounting _ * #,##0_ ;_ * -#,##0_ ;_ * "-"_ ;_ @_

/// 42 Accounting _ $* #,##0_ ;_ $* -#,##0_ ;_ $* "-"_ ;_ @_

/// 43 Accounting _ * #,##0.00_ ;_ * -#,##0.00_ ;_ * "-"??_ ;_ @_

/// 44 Accounting _ $* #,##0.00_ ;_ $* -#,##0.00_ ;_ $* "-"??_ ;_ @_

/// 45 Time mm:ss

/// 46 Time [h]:mm:ss

/// 47 Time mm:ss.0

/// 48 Scientific ##0.0E+00

/// 49 Text @

/// </summary>

举一个动态设定单元格数字样式的例子，通过GetStyle()方法获取单元格样式，然后，设置Number样式

Aspose.Cells.Style style = ws.Cells[i,j].GetStyle();//ws为WorkSheet实例

style.Number = 10 //这里设置为百分比

ws.Cells[i,j].SetStyle(style)

还可以设置整个Workbook的样式public Style GetStyle(Worksheet ws,SheetTemplateColumnEntity column)

{

     Aspose.Cells.Style style = ws.Workbook.Styles[ws.Workbook.Styles.Add()];

    style.Font.IsBold = true;

    style.Font.Size = 12;

    System.Drawing.Color bcolor = System.Drawing.ColorTranslator.FromHtml("");

    style.ForegroundColor = bcolor;//背景色

    System.Drawing.Color fcolor = System.Drawing.ColorTranslator.FromHtml("");

    style.Font.Color = fcolor;

    style.Font.Name = "微软雅黑";

    style.IndentLevel = 2;//缩进量

    style.Number = 10;

    style.HorizontalAlignment = (TextAlignmentType)(Enum.Parse(typeof(TextAlignmentType),""));

    style.VerticalAlignment = (TextAlignmentType)(Enum.Parse(typeof(TextAlignmentType),""));

    style.IsLocked = true;

    style.IsTextWrapped = false ; //获取或设置自动换行


    style.Borders.SetColor(System.Drawing.Color.Black);//边框颜色

    style.Borders[BorderType.LeftBorder].LineStyle = CellBorderType.Thin;//应用边界线 左边界线

    style.Borders[BorderType.RightBorder].LineStyle = CellBorderType.Thin;//应用边界线 右边界线

    style.Borders[BorderType.TopBorder].LineStyle = CellBorderType.Thin;//应用边界线 上边界线

    style.Borders[BorderType.BottomBorder].LineStyle = CellBorderType.Thin;//应用边界线 下边界线

    style.Pattern = BackgroundType.Solid;

    return style;

}

//锁定单元格，style.IsLocked使用的时候，锁定的设置为true，不锁定的设置为false。

ws.Protect(ProtectType.All,"654321",null)--设置解锁锁定后，需要设置sheet保护，才能生效

//设置折叠行

ws.Cells.GroupRow(startrow,endrow,false);

//设置折叠行后，需要设置SummaryRowBelow来使，折叠符号变正

ws.Outline.SummaryRowBelow = false;

ws.FreezePanes(startrow,startcol,rowcount,colcount);//冻结行列

ws.Protection.AllowSelectingLockedCell = false;

ws.Protection.AllowInsertingRow = true;

ws.Protection.AllowDeletingRow = true;

ws.Protection.AllowFormattingColumn = true;

ws.Protection.AllowFormattingRow = true;

ws.IsOutlineShown = true;//折线显示

wb.CalculateFormula();//刷新公式

添加一种新的输出方式，直接返回给网页

 XlsSaveOptions saveOptions = new XlsSaveOptions(SaveFormat.Xlsm);

 string excelname = Year + "年" + entity.FullName + "管理利润导入报表.Xlsm";

 if (HttpContext.Current.Request.UserAgent.ToLower().ToString().IndexOf("firefox") < 0)

 {

    wb.Save(System.Web.HttpContext.Current.Response, HttpUtility.UrlEncode(excelname, System.Text.Encoding.UTF8), ContentDisposition.Attachment, saveOptions);

 }

 else

 {

    wb.Save(System.Web.HttpContext.Current.Response, excelname, ContentDisposition.Attachment, saveOptions);

 }

Aspose.Cell篇章3，设置写入到Excel文件的各种样式及输出的相关教程结束。