NPOI.Extension/samples/Program.cs at develop · rigofunc/NPOI.Extension · GitHub

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
using System;
using NPOI.Extension;

namespace samples
{
    class Program
    {
        static void Main(string[] args)
        {
            // global call this
            FluentConfiguration();

            var len = 10;
            var reports = new Report[len];
            for (int i = 0; i < len; i++)
            {
                reports[i] = new Report
                {
                    City = "ningbo",
                    Building = "世茂首府",
                    HandleTime = new DateTime(2015, 11, 23),
                    Broker = "rigofunc 18957139**7",
                    Customer = "rigofunc 18957139**7",
                    Room = "2#1703",
                    Brokerage = 125M,
                    Profits = 25m
                };
            }

            var excelFile = @"/Users/rigofunc/Documents/sample.xlsx";

            // save to excel file
            reports.ToExcel(excelFile);

			// load from excel
			var loadFromExcel = Excel.Load<Report>(excelFile);
		}

		/// <summary>
        /// Use fluent configuration api. (doesn't poison your POCO)
		/// </summary>
		static void FluentConfiguration()
        {
            var fc = Excel.Setting.For<Report>();

            fc.HasStatistics("合计", "SUM", 6, 7)
              .HasFilter(firstColumn: 0, lastColumn: 2, firstRow: 0)
              .HasFreeze(columnSplit: 2,rowSplit: 1, leftMostColumn: 2, topMostRow: 1);

            fc.Property(r => r.City)
              .HasExcelIndex(0)
              .HasExcelTitle("城市")
              .IsMergeEnabled();

            fc.Property(r => r.Building)
              .HasExcelIndex(1)
              .HasExcelTitle("楼盘")
              .IsMergeEnabled();

			fc.Property(r => r.HandleTime)
			  .HasExcelIndex(2)
			  .HasExcelTitle("成交时间")
              .HasDataFormatter("yyyy-MM-dd");

			fc.Property(r => r.Broker)
			  .HasExcelIndex(3)
			  .HasExcelTitle("经纪人");

			fc.Property(r => r.Customer)
			  .HasExcelIndex(4)
			  .HasExcelTitle("客户");

			fc.Property(r => r.Room)
			  .HasExcelIndex(5)
			  .HasExcelTitle("房源");

			fc.Property(r => r.Brokerage)
			  .HasExcelIndex(6)
			  .HasExcelTitle("佣金(元)");

            fc.Property(r => r.Profits)
			  .HasExcelIndex(7)
			  .HasExcelTitle("收益(元)");
        }
    }
}