Skip to content

This repo contains the extension of NPOI, which provides IEnumerable<T> has excel functionality.

License

Notifications You must be signed in to change notification settings

geomatics-io/NPOI.Extension

 
 

Repository files navigation

Overview

The extensions of NPOI, which provides IEnumerable<T> save to and load from excel functionality.

NPOI.Extension demo

Get Started

  1. Using Package Manager Console to install NPOI.Extension

     PM> Install-Package NPOI.Extension
    
  2. Reference NPOI.Extension in code

     using NPOI.Extension;
    
  3. Apply attribute to the model

     [Filter(FirstCol = 0, FirstRow = 0, LastCol = 2)]
     [Freeze(ColSplit = 2, RowSplit = 1, LeftMostColumn = 2, TopRow = 1)]
     [Statistics(Name = "合计", Formula = "SUM", Columns = new[] { 6, 7 })]
     public class Report {
         [Column(Index = 0, Title = "城市", AllowMerge = true)]
         public string City { get; set; }
         [Column(Index = 1, Title = "楼盘", AllowMerge = true)]
         public string Building { get; set; }
         [Column(Index = 2, Title = "成交时间")]
         public DateTime HandleTime { get; set; }
         [Column(Index = 3, Title = "经纪人")]
         public string Broker { get; set; }
         [Column(Index = 4, Title = "客户")]
         public string Customer { get; set; }
         [Column(Index = 5, Title = "房源")]
         public string Room { get; set; }
         [Column(Index = 6, Title = "佣金(元)")]
         public decimal Brokerage { get; set; }
         [Column(Index = 7, Title = "收益(元)")]
         public decimal Profits { get; set; }
     }
    
  4. Using extension methods

     var len = 1000;
     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
         };
    
         // other data here...
     }
    
     // save the excel file
     reports.ToExcel(@"C:\demo.xls");
    
  5. Load IEnumerable≶T> from excel

     // load from excel
     var loadFromExcel = Excel.Load<Report>(@"C:\demo.xls");
    

About

This repo contains the extension of NPOI, which provides IEnumerable<T> has excel functionality.

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C# 100.0%