初始化代码

wangxinhui

2026-03-26 ad05ef2341fe19a4220f7ada1987636f9ec4a1a9

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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
using NPOI.SS.UserModel;
using NPOI.Util.Collections;
using NPOI.XSSF.UserModel;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
 
namespace WIDESEAWCS_Common.Helper
{
    public static class TExportHelper
    {
        /// <summary>
        /// 导出
        /// </summary>
        public static string GetExport<T>(string savePath, PropertyInfo[] properties, List<T> dataList)
        {
            string filePath = "";
            try
            {
                // 创建 Excel 工作簿
                IWorkbook workbook = new XSSFWorkbook();
                ISheet sheet = workbook.CreateSheet("x");
                // 创建表头行
                IRow headerRow = sheet.CreateRow(0);
                sheet.DefaultColumnWidth = 15;
                // 设置表头样式
                ICellStyle headerStyle = workbook.CreateCellStyle();
                IFont headerFont = workbook.CreateFont();
                headerFont.Boldweight = (short)FontBoldWeight.Bold;
                headerFont.FontHeightInPoints = 12;
                headerStyle.SetFont(headerFont);
                headerStyle.FillForegroundColor = IndexedColors.LightBlue.Index;
                headerStyle.FillPattern = FillPattern.SolidForeground;
                headerStyle.BorderBottom = BorderStyle.Thin;
                headerStyle.BorderTop = BorderStyle.Thin;
                headerStyle.BorderLeft = BorderStyle.Medium;
                headerStyle.BorderRight = BorderStyle.Medium;
 
                // 设置数据样式
                ICellStyle dataStyle = workbook.CreateCellStyle();
                dataStyle.BorderBottom = BorderStyle.Thin;
                dataStyle.BorderTop = BorderStyle.Thin;
                dataStyle.BorderLeft = BorderStyle.Thin;
                dataStyle.BorderRight = BorderStyle.Thin;
 
                // 填充表头
                for (int i = 0; i < properties.Length; i++)
                {
                    var columnName = AttributeHelper.GetExporterDisplayName(properties[i]);
                    var cell = headerRow.CreateCell(i);
                    cell.SetCellValue(columnName);
                    cell.CellStyle = headerStyle;
                }
 
                // 填充数据
                for (int rowIdx = 0; rowIdx < dataList.Count; rowIdx++)
                {
                    IRow dataRow = sheet.CreateRow(rowIdx + 1);
                    var item = dataList[rowIdx];
 
                    for (int colIdx = 0; colIdx < properties.Length; colIdx++)
                    {
                        var cell = dataRow.CreateCell(colIdx);
                        var value = properties[colIdx].GetValue(item);
 
                        // 处理不同类型的值
                        if (value == null)
                        {
                            cell.SetCellValue("");
                        }
                        else if (value is DateTime dateTime)
                        {
                            cell.SetCellValue(dateTime.ToString("yyyy-MM-dd HH:mm:ss"));
                        }
                        else if (value is bool boolValue)
                        {
                            cell.SetCellValue(boolValue);
                        }
                        else
                        {
                            cell.SetCellValue(value.ToString());
                        }
                        cell.CellStyle = dataStyle;
                    }
                }
                // 保存文件
                string fileName = "x.xlsx";
                filePath = Path.Combine(savePath, fileName);
                using (var fs = new FileStream(filePath, FileMode.Create, FileAccess.Write))
                {
                    workbook.Write(fs);
                }
            }
            catch (Exception)
            {
 
                throw;
            }
            return filePath;
        }
    }
}