biezhi / Excel Plus
Licence: apache-2.0
❇️ Improve the productivity of the Excel operation library. https://git.io/vNjQy
Stars: ✭ 160
Programming Languages
java
68154 projects - #9 most used programming language
Labels
Projects that are alternatives of or similar to Excel Plus
Functional Data Grid
Data grids in functional style with ReactJS
Stars: ✭ 125 (-21.87%)
Mutual labels: excel
Vue Xlsx Table
Not need upload, view xlsx or xls file in your browser, Supported by js-xlsx.
Stars: ✭ 136 (-15%)
Mutual labels: excel
Docxtemplater
Generate docx pptx and xlsx (Microsoft Word, Powerpoint, Excel documents) from templates, from Node.js, the Browser and the command line / Demo: https://www.docxtemplater.com/demo
Stars: ✭ 1,990 (+1143.75%)
Mutual labels: excel
Jxls
Java library for creating Excel reports using Excel templates
Stars: ✭ 128 (-20%)
Mutual labels: excel
X Spreadsheet
A web-based JavaScript(canvas) spreadsheet
Stars: ✭ 12,046 (+7428.75%)
Mutual labels: excel
Tui.grid
🍞🔡 The Powerful Component to Display and Edit Data. Experience the Ultimate Data Transformer!
Stars: ✭ 1,859 (+1061.88%)
Mutual labels: excel
Php Ext Xlswriter
🚀 PHP Extension for creating and reader XLSX files.
Stars: ✭ 1,734 (+983.75%)
Mutual labels: excel
Yii2 Export
A library to export server/db data in various formats (e.g. excel, html, pdf, csv etc.)
Stars: ✭ 153 (-4.37%)
Mutual labels: excel
Elasticsearch Dataformat
Excel/CSV/BulkJSON downloads on Elasticsearch.
Stars: ✭ 135 (-15.62%)
Mutual labels: excel
Xlsx
Fast and reliable way to work with Microsoft Excel™ [xlsx] files in Golang
Stars: ✭ 132 (-17.5%)
Mutual labels: excel
Npoi
A .NET library for reading and writing Microsoft Office binary and OOXML file formats.
Stars: ✭ 1,751 (+994.38%)
Mutual labels: excel
Weihanli.npoi
NPOI Extensions, excel/csv importer/exporter for IEnumerable<T>/DataTable, fluentapi(great flexibility)/attribute configuration
Stars: ✭ 157 (-1.87%)
Mutual labels: excel
Test files
📚 SheetJS Test Files (XLS/XLSX/XLSB and other spreadsheet formats)
Stars: ✭ 150 (-6.25%)
Mutual labels: excel
excel-plus
Easier to read and generate an excel file, supports XLSX
、XLS
、CSV
.
Feature
- Easy to use
- Annotation driven
- Based java 8
- Support
xls
、xlsx
、csv
- 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
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].