增加商品字段，订单字段

移动系统liao

2024-07-30 306ab8865840b2637590abb6e670e5614446f24d

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
using System;
using System.Collections.Generic;
using System.Text;
using NPOI.HSSF.UserModel;
using NPOI.HSSF.Util;
using NPOI.SS.UserModel;
 
namespace CoreCms.Net.Utility.Helper
{
    public static class ExcelHelper
    {
        /// <summary>
        /// 获取头部样式
        /// </summary>
        /// <param name="hs"></param>
        /// <returns></returns>
        public static ICellStyle GetHeaderStyle(HSSFWorkbook hs)
        {
            //样式
            ICellStyle headerStyle = hs.CreateCellStyle();//创建样式
            headerStyle.VerticalAlignment = VerticalAlignment.Center;//垂直居中 方法1 
            //style.Alignment = HorizontalAlignment.CenterSelection;//设置居中 方法2
            headerStyle.Alignment = HorizontalAlignment.Center;//设置居中 方法3 
            HSSFFont headerfont = (HSSFFont)hs.CreateFont();//创建字体
            headerfont.Color = HSSFColor.Black.Index;//给字体设置颜色
            headerfont.FontName = "宋体";
            headerfont.IsBold = true;
            headerfont.FontHeight = 11;
            headerfont.FontHeightInPoints = 11;
            headerStyle.SetFont(headerfont);
 
            headerStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;    //下边框线
            headerStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;      //左边框线
            headerStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;     //右边框线
            headerStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;       //上边框线
            return headerStyle;
        }
        /// <summary>
        /// 获取通用列样式
        /// </summary>
        /// <param name="hs"></param>
        /// <returns></returns>
        public static ICellStyle GetCommonStyle(HSSFWorkbook hs)
        {
            //样式
            ICellStyle commonCellStyle = hs.CreateCellStyle();//创建样式
            commonCellStyle.VerticalAlignment = VerticalAlignment.Center;//垂直居中
            //commonCellStyle.Alignment = HorizontalAlignment.CenterSelection;//设置居中
            commonCellStyle.Alignment = HorizontalAlignment.Center;//设置居中
 
            HSSFFont commonFont = (HSSFFont)hs.CreateFont();//创建字体
            commonFont.FontName = "宋体";
            commonFont.FontHeight = 10;
            commonFont.FontHeightInPoints = 10;
            commonCellStyle.SetFont(commonFont);
 
            commonCellStyle.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;    //下边框线
            commonCellStyle.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;      //左边框线
            commonCellStyle.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;     //右边框线
            commonCellStyle.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;       //上边框线
            return commonCellStyle;
        }
 
    }
}