KO
|
EN
gitlite — search
Search
#javascript
#python
#hacktoberfest
#react
#ai
#typescript
#llm
#go
#golang
#android
#machine-learning
#rust
#deep-learning
#linux
mythpoi
★ 8
Open GitHub ↗
:battery:致力于 实现一个简单好用的 文档操作工具 基于POI
Download README (.md)
Explore Similar Repositories
ClassRoomExamples
:
No description available.
bioinformatics-pipeline
:
bioinformatics of mine and others
crm-oauth2-jwt
:
Spring MVC REST API with Spring Security, OAuth2, and JWT
react-programmable-chat
:
React Programmable Chat
Precise-hand-guiding-for-KUKA-iiwa-robot
:
No description available.
// repository documentation
Was this content helpful?
★ 0
(0 ratings)
Select Rating:
★
★
★
★
★
Submit Feedback
Recent Feedback
×
Download README
Do you want to download the
README.md
file for
mythpoi
?
Download (.md)
# myth-poi > More easy to Export & Import Excel&Word file. [](https://codeclimate.com/github/Kuangcp/mythpoi/maintainability) [](https://www.codacy.com/app/Kuangcp/mythpoi?utm_source=github.com&utm_medium=referral&utm_content=Kuangcp/mythpoi&utm_campaign=Badge_Grade) [](https://codebeat.co/projects/github-com-kuangcp-mythpoi-master) [](https://www.java.com/download/) ## 1. How to install ### A way: Build - Clone this Repo And install - `git clone https://github.com/Kuangcp/mythpoi.git` - `cd mythpoi && gradle install` ### Another way: Use gitee repository #### Gradle ```groovy repositories { maven{ url "https://gitee.com/kcp1104/MavenRepos/raw/master" } } ``` #### Maven ************ ## 2. Add Dependency _2.1 Maven_ ```xml <dependency> <groupId>com.github.kuangcp</groupId> <artifactId>myth-poi</artifactId> <version>0.2.4-SNAPSHOT</version> </dependency> ``` _2.2 Gradle_ ```groovy compile("com.github.kuangcp:myth-poi:0.2.4-SNAPSHOT") ``` _2.3 Jar_ Download About Jar http://mvnrepository.com/artifact/org.jyaml/jyaml http://mvnrepository.com/artifact/org.apache.poi/poi https://gitee.com/kcp1104/MavenRepos/tree/master/com/github/kuangcp/myth-poi ******************** ## 3. How to use ### Excel - 1.Implement Interface: - use annotation to define excelSheet column title and Sheet - *Just support BaseType field* ```java @Data @ExcelSheet(exportTitle = "雇员表", importTitle = "雇员表") public class Employee implements ExcelTransform{ @ExcelConfig("姓名") private String names; @ExcelConfig("住址") private String address; // not export this field @ExcelConfig(value = "QQ号码", exportFlag = false) private String qq; } ``` - 2.Export Excel file ```java List<Employee> originList = new ArrayList<>(); // add some Employee Object ... ExcelExport.exportExcel("/home/kcp/test/employee.xls", originList); ``` - 3.Import Excel file ```java List<Employee> result = ExcelImport.importExcel("/home/kcp/test/employee.xls", Employee.class); ``` _Excel File :_  ### Word ************* - [easy excel](https://github.com/alibaba/easyexcel)
