江苏龙网

  1. 主页 > 生活百科 > >

周末撸了个Excel框架，现已开源，yyds( 二 )

Excel框架

周末撸了个Excel框架，现已开源，yyds
文章插图
 
注解方式导出Excel
如果是普通的Java项目，以注解方式将Excel文件导出到本地磁盘，则只需要在项目的pom.xml文件中增加如下配置
io.mykit.excel mykit-excel-common 1.0.0-SNAPSHOT
创建测试JavaBean
(1) 创建父类JavaBean
@Datapublic class Person implements Serializable { private static final long serialVersionUID = 3251965335162340137L; @ExcelColumn(isExport = true, title = "编号", sort = 2) private String id ; @ExcelColumn(isExport = true, title = "姓名", sort = 3) private String name; public Person(){ } public Person(String id, String name){ this.id = id; this.name = name; }}
(2) 创建子类JavaBean
@Datapublic class Student extends Person{ private static final long serialVersionUID = -6180523202831503132L; @ExcelColumn(isExport = false, title = "班级编号", sort = 1) private String classNo; private Integer score; @ExcelColumn(isExport = true, title = "爱好", sort = 5) private String hobby; public Student(){ } public Student(String id, String name, String classNo, Integer score, String hobby){ super(id, name); this.classNo = classNo; this.score = score; this.hobby = hobby; }}
接下来，在程序中按照如下方式导出Excel文件即可
public class TestAnnotationExportExcelUtils { public static void main(String[] args) throws FileNotFoundException { // 准备数据 List list = new ArrayList(); for (int i = 1; i <= 10; i++) { list.add(new Student("00" + i, "张三", "001", 100, "篮球")); } AnnotationExcelExportUtils utils = new AnnotationExcelExportUtils(); utils.exportExcel("用户导出", list, new FileOutputStream("e:/E:/test.xls"), Student.class, AnnotationExcelExportUtils.EXCEL_FILE_2003); }}
导出的文件如下所示

周末撸了个Excel框架，现已开源，yyds

文章插图
 
Web方式导出Excel
如果是基于Java Web或Spring MVC项目，需要导出Excel，则需要在项目的pom.xml文件中，加入如下配置
io.mykit.excel mykit-excel-servlet 1.0.0-SNAPSHOT
创建测试JavaBean
@Datapublic class Student implements Serializable { private static final long serialVersionUID = -2987207599880734028L; private int id; private String name; private String sex; public Student(){ } public Student(int id, String name, String sex){ this.id = id; this.name = name; this.sex = sex; }}
接下来，在程序中按照如下方式导出Excel文件即可
@RequestMapping("/excel")public void getExcel(HttpServletRequest request, HttpServletResponse response) throws Exception { // 准备数据 List list = new ArrayList(); for (int i = 0; i < 10; i++) { list.add(new Student(111,"张三","男")); list.add(new Student(111,"李四","男")); list.add(new Student(111,"王五","女")); } String[] columnNames = { "ID", "姓名", " 性别"}; String fileName = "springboot_excel"; ExportExcelWrapper util = new ExportExcelWrapper(); util.exportExcel(fileName, fileName, columnNames, list, response, ExportExcelUtils.EXCEL_FILE_2003);}
导出的文件如下所示
周末撸了个Excel框架，现已开源，yyds

文章插图
 
基于注解的Web方式导出Excel
如果是基于Java Web或Spring MVC项目，需要基于注解导出Excel，则需要在项目的pom.xml文件中，加入如下配置
io.mykit.excel mykit-excel-servlet 1.0.0-SNAPSHOT
创建测试JavaBean
(1) 创建父类JavaBean
@Datapublic class Person implements Serializable { private static final long serialVersionUID = 3251965335162340137L; @ExcelColumn(isExport = true, title = "编号", sort = 2) private String id ; @ExcelColumn(isExport = true, title = "姓名", sort = 3) private String name; public Person(){ } public Person(String id, String name){ this.id = id; this.name = name; }}
(2) 创建子类JavaBean
@Datapublic class Student extends Person{ private static final long serialVersionUID = -6180523202831503132L; @ExcelColumn(isExport = false, title = "班级编号", sort = 1) private String classNo; private Integer score; @ExcelColumn(isExport = true, title = "爱好", sort = 5) private String hobby; public Student(){ } public Student(String id, String name, String classNo, Integer score, String hobby){ super(id, name); this.classNo = classNo; this.score = score; this.hobby = hobby; }}


推荐阅读


上一篇：mac图片压缩怎么弄?mac电脑怎么压缩图片大小

下一篇：千万不要一辈子靠技术生存