• Stars
    star
    190
  • Rank 198,901 (Top 4 %)
  • Language
    Java
  • License
    Apache License 2.0
  • Created over 6 years ago
  • Updated 12 months ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

❇️ Improve the productivity of the Excel operation library. https://hellokaton.github.io/excel-plus/#/

excel-plus

Easier to read and generate an excel file, supports XLSXXLSCSV.

EO principles respected here DevOps By Rultor.com

Javadocs

codecov SonarQube

中文文档

Feature

  • Easy to use
  • Annotation driven
  • Based java 8
  • Support xlsxlsxcsv
  • Support export by template
  • Support custom column style
  • High performance, only 30 seconds to read or write 1,000,000 lines

Usage

How to use. Latest version here

<dependency>
    <groupId>io.github.biezhi</groupId>
    <artifactId>excel-plus</artifactId>
    <version>1.0.8</version>
</dependency>

snapshot version

<repositories>
    <repository>
        <id>snapshots-repo</id>
        <url>https://oss.sonatype.org/content/repositories/snapshots</url>
        <releases>
            <enabled>false</enabled>
        </releases>
        <snapshots>
            <enabled>true</enabled>
        </snapshots>
    </repository>
</repositories>

<dependencies>
    <dependency>
        <groupId>io.github.biezhi</groupId>
        <artifactId>excel-plus</artifactId>
        <version>1.0.8-SNAPSHOT</version>
    </dependency>
</dependencies>

Read excel as List

public class Member {

    @ExcelColumn(title = "卡号", index = 0)
    private Long cardNo;

    @ExcelColumn(title = "卡类型", index = 1)
    private String cardType;

    @ExcelColumn(title = "领用状态", index = 2)
    private String requisitionStatus;

    @ExcelColumn(title = "状态", index = 3)
    private String status;

    @ExcelColumn(title = "余额(元)", index = 6)
    private BigDecimal amount;

    @ExcelColumn(title = "会员", index = 7)
    private String nickname;

    @ExcelColumn(title = "性别", index = 9)
    private String gender;

    @ExcelColumn(title = "手机", index = 10)
    private String mobile;

    @ExcelColumn(title = "发卡日期", index = 14, datePattern = "M/d/yyyy HH:mm")
    private Date sendCardTime;
    
    // getter setter 省略
}
List<Member> members = Reader.create(Member.class)
                 .from(new File("members.xlsx"))
                 .start(1)
                 .asList();

Write excel as file

public class Book {

    @ExcelColumn(title = "书名", index = 0)
    private String title;
    
    @ExcelColumn(title = "作者", index = 1)
    private String author;

    @ExcelColumn(title = "售价", index = 2)
    private Double price;

    @ExcelColumn(title = "出版日期", index = 3, datePattern = "yyyy年M月")
    private LocalDate publishDate;
    
    // getter setter 省略
}
Writer.create()
         .withRows(books)
         .headerTitle("书籍列表 V1")
         .to(new File("book.xlsx"));

Code See here

Browser download

Writer.create()
         .withRows(orders)
         .to(ResponseWrapper.create(HttpServletResponse, "order-list.xls"));

Examples

See here

Thanks

License

Apache2

More Repositories

1

java-bible

🍌 我的技术摘要
HTML
2,988
star
2

30-seconds-of-java8

30 seconds to collect useful Java 8 snippet.
Java
2,335
star
3

wechat-api

🗯 wechat-api by java7.
Java
1,813
star
4

learn-java8

💖《跟上 Java 8》视频课程源码
Java
1,381
star
5

oh-my-email

📪 可能是最小的 Java 邮件发送库了,支持抄送、附件、模板等功能。
Java
707
star
6

profit

🤔 biezhi 在线打赏系统,开启你的要饭生涯。
Java
403
star
7

write-readable-code

🗾 编写可读代码的艺术代码仓库
Java
395
star
8

elves

🎊 Design and implement of lightweight crawler framework.
Java
317
star
9

anima

Minimal database operation library.
Java
227
star
10

java-library-examples

💪 example of common used libraries and frameworks, programming required, don't fork man.
Java
215
star
11

gorm-paginator

gorm pagination extension
Go
153
star
12

java-tips

🍓 Java 语言编程技巧、最佳实践
Java
149
star
13

gitmoji-plugin

Choose the right emoji emoticon for git commit, make git log commit more interesting.
Kotlin
111
star
14

java11-examples

java 11 example code
Java
99
star
15

telegram-bot-api

🤖 telegram bot api by java, help you quickly create a little robot.
Java
84
star
16

lets-golang

《给 Java 程序员的 Go 私房菜》源码仓库
Go
63
star
17

oh-mybatis

🎈 A simple web app to generate mybatis code.
Java
60
star
18

code-fonts

编程语言中流行的 8 款代码字体
PHP
59
star
19

terse

🍋 my typecho blog theme, Concise UI
CSS
59
star
20

hellokaton.com

✍️ https://hellokaton.com source code
HTML
46
star
21

webp-io

🌚 general format images and webp transform each other
Java
44
star
22

oh-my-request

🔮 simple request library by java8
Java
43
star
23

redis-dqueue

redis base delay queue
Java
43
star
24

oh-my-session

🍖 distributed session storage scheme, using redis to store data.
Java
42
star
25

swing-generate

🙊 Swing development code generator
Java
36
star
26

ss-panel

🐒 java shadowsocks panel(java版本shadowsocks面板)
HTML
35
star
27

industry-glossary

汇集行业英文术语,让你命名不在困难。
34
star
28

freechat

🐶 online anonymous chat application.
CSS
29
star
29

grice

🐜 A simple web document engine written by java.
CSS
29
star
30

goinx

💞 Multi-domain proxy by golang, fuck gfw proxy
Go
28
star
31

springmvc-plupload

🍃 Springmvc and servlet shard to upload demo
JavaScript
27
star
32

lowb

🤦🏻‍♂️ teach you to develop command-line source code using NodeJS
JavaScript
27
star
33

geekbb

😎 Geek dev club.
JavaScript
26
star
34

keeper

Java
25
star
35

mini-jq

🍣 mininal jquery, you don't need jquery!
JavaScript
21
star
36

spring-boot-examples

🕷 spring boot and spring cloud examples
Java
20
star
37

bye-2017

👋 Bye! my 2017
CSS
19
star
38

weather-cli

💊 weather command-line programs written in Golang.
Go
18
star
39

go-examples

🍄 learning golang code
Go
16
star
40

oh-my-jvm

☕️ using golang write jvm
Go
16
star
41

nice

🐹 使用blade开发的一款简洁的图片社交应用
Java
16
star
42

blog

blog source code
SCSS
16
star
43

learn-cute-netty

《可爱的Netty》源码仓库
Java
15
star
44

eve

👻 everyday explore, Github / HackNews / V2EX / Medium / Product Hunt.
Go
13
star
45

blade-cli

🐳 blade mvc cli application
Go
13
star
46

agon

🦉 my golang utilities, log json config and other
Go
12
star
47

wechat-api-examples

wechat-api examples, used java8.
Java
12
star
48

java8-best-practices

java8 best practices source code.
Java
11
star
49

telegram-lottery

🤖 A telegram lottery bot that helps you achieve random rewards for group activities.
Go
10
star
50

dbkit

🚧 convenient implement of Database timing backup tool.
Go
10
star
51

runcat_pyside

Python PySide6 of RunCat_for_windows
Python
9
star
52

lets-python

🍭 learning Python code
Python
9
star
53

mapper-spring-boot-starter

通用mapper+pagehelper的spring boot starter
Java
9
star
54

java-2048

🎲 Java swing of 2048
Java
9
star
55

blade-lattice

🔐 lightweight authentication and authorization, born for Blade.
Java
9
star
56

writty

🌝 A garbage writing platform, has given up.
Java
9
star
57

java-clojure-syntax-comparison

⚔️ Comparison of some code snippets in the Java and Clojure.
9
star
58

emojis

this is emoji images
8
star
59

show-code

🌝 show github repositories card with html
JavaScript
7
star
60

probe

exploring the world beyond the wall, netty4 based proxy service.
Java
7
star
61

ppocr-api

飞桨 OCR API Docker 镜像
Python
6
star
62

oh-my-monitor

🌈 C/S mode server monitoring (discontinuation of maintenance)
Java
6
star
63

moe

😛 simple cli spinner by golang.
Go
5
star
64

witty

🐝 witty is a smart golang robot
Go
5
star
65

gow

🙄 gow!!! a micro go web framework.
Go
5
star
66

primer-series

从入门到放弃系列衬衫生成器
CSS
5
star
67

spring-boot-starter-jetbrick

🐥 jetbrick-template的spring-boot starter
5
star
68

fastapi-tutorial

Here are some sample programs for me to learn fastapi.
Python
5
star
69

helidon-examples

💣 helidon framework example
Java
5
star
70

hellokaton

3
star
71

vite-react-mpa-example

React + Vite multi page application example
TypeScript
3
star
72

bar

🍺 static website builder written by golang
Go
3
star
73

tomato-clock

JavaScript
2
star
74

findor

🌟 let the world find you !
2
star
75

typecho-theme-modernist

a typecho theme modernist
PHP
2
star
76

homebrew-tap

Homebrew tap for biezhi/eve
Ruby
1
star
77

clojure-todo-list

The todo-list application that used clojure + ring
Clojure
1
star
78

juejun-alfred-workflow

a simple juejin alfred workflow example
Python
1
star