hanzhaoxin / excelreport Goto Github PK

This reporting engine is built on NPOI.

License: MIT License

C# 100.00%

excelreport's Introduction

快速入门

ExcelReport是什么？

ExcelReport是一个Excel模板渲染引擎。它基于关注点分离的理念，将数据与表格样式、字体格式分离。
其中模板承载的表格样式、字体格式在可视化的情况下编辑。开发人员只需要绑定数据与目标标签的对应关系。ExcelReport就可以以数据驱动的方式渲染出目标报表。

模块组成

ExcelReport家族现在有四个成员。
ExcelReport负责报表的渲染逻辑。ExcelReport.Driver为ExcelReport提供了操作Excel文档的抽象接口。
ExcelReport.Driver.NPOI是使用NPOI对ExcelReport.Driver的实现。支持xls、xlsx两种格式的Excel文档。ExcelReport.Driver.CSV是针对csv格式的Excel文档对ExcelReport.Driver的实现。

渲染模型

Template：模板承载的表格样式、字体格式、占位标签等。
Render：指定模板标签与数据的关系。
Data：注入模板的数据。整个渲染过程也是数据驱动渲染的。
Output：输出文件

入门示例

步骤一：新建入门项目QuickStart，并引入nuget包：

步骤二：创建并编辑模板

步骤三：编写代码

internal class Program
{

       private static void Main(string[] args)
       {
           // 项目启动时，添加
           Configurator.Put(".xlsx", new WorkbookLoader());

           var num = 1;
           ExportHelper.ExportToLocal(@"templates\student.xlsx", "out.xlsx",
                   new SheetRenderer("Students",
                       new RepeaterRenderer<StudentInfo>("Roster", StudentLogic.GetList(),
                           new ParameterRenderer<StudentInfo>("No", t => num++),
                           new ParameterRenderer<StudentInfo>("Name", t => t.Name),
                           new ParameterRenderer<StudentInfo>("Gender", t => t.Gender ? "男" : "女"),
                           new ParameterRenderer<StudentInfo>("Class", t => t.Class),
                           new ParameterRenderer<StudentInfo>("RecordNo", t => t.RecordNo),
                           new ParameterRenderer<StudentInfo>("Phone", t => t.Phone),
                           new ParameterRenderer<StudentInfo>("Email", t => t.Email)
                           ),
                        new ParameterRenderer("Author", "hzx")
                       )
                   );
           Console.WriteLine("finished!");
           Console.ReadKey();
       }
}

public class StudentInfo
{
       public string Name { get; set; }
       public bool Gender { get; set; }
       public string Class { get; set; }
       public string RecordNo { get; set; }
       public string Phone { get; set; }
       public string Email { get; set; }
}

public static class StudentLogic
{
       public static List<StudentInfo> GetList()
       {
           List<StudentInfo> list = new List<StudentInfo>();
           list.Add(new StudentInfo() { Class = "一班", Name = "XXX01", Gender = true, RecordNo = "YYY0001", Phone = "158******01", Email = "[email protected]" });
           list.Add(new StudentInfo() { Class = "二班", Name = "XXX02", Gender = false, RecordNo = "YYY0002", Phone = "158******02", Email = "[email protected]" });
           list.Add(new StudentInfo() { Class = "一班", Name = "XXX03", Gender = true, RecordNo = "YYY0003", Phone = "158******03", Email = "[email protected]" });
           list.Add(new StudentInfo() { Class = "一班", Name = "XXX04", Gender = true, RecordNo = "YYY0004", Phone = "158******04", Email = "[email protected]" });
           return list;
       }
}

输出结果

excelreport's People

Contributors

Stargazers

Watchers

Forkers

asd1355215911 huaan011 dalesdream ciker w55156 flyingliang huchundong strongshao ppsurcao 403016605 wxtech haoljp kinggod jetzfly xiluo huangfu jiailiuyan williambryan777 ranfu dreamxwang yanghuijie weiguang3100 zhaosichao wilfredzhangzp robinlu msincenselee y1024866464 qcjxberin jsonruby brucezhang80 tinkerc jt123456 maoliguo tangshining hoku850 yuniansheng codekgithub wyerp ropean fuwei199006 vebin jackwangcumt geekmi carelnie huoxudong125 zhangxi-zhangxi alencc2015 try3 su-fenggy zhangxi839 dut3062796s newlysoft abennet1314 zhangjays stelephony yisansky gary2008 duanshuaimin lydx9876 lingkobe 15070217668 wcenjan inic timmxc superlidd show027 times21 oviovi lopnor325 liangfeixu lishewen jzh8708 smodin ithanshui wondial andyshao guojianbin bryant1410 xiaopohou hero106wen ioriwellings bekci78 vincentroole chxaitz shenhx mrlai kingboy2008 gzwplato caizikun hsxiaoma barongeng lrcchuan2016 xiangde112 hobosoft liy2016 zhaoqinglong leojim dclwode jsjxrj pangfd

excelreport's Issues

数据导入，在你这版本又应该怎么支持呢？

你好，数据导入，在你这版本又应该怎么支持呢？

性能问题

1000多条数据还是比较正常，4000多条数据耗时10分钟。

ParameterRenderer的cell修改style后,所有cell都运用了该样式

public override void Render(SheetContext sheetContext, T dataSource)后
Cell cell = sheetContext.GetCell(location) as Cell;
cell.NpoiCell.CellStyle.FillForegroundColor = HSSFColor.Red.Index;
cell.NpoiCell.CellStyle.FillPattern = FillPattern.SolidForeground;
对cell设置底色,但是没设置底色的cell也跟这个设置了底色的cell一样底色了.