# xslx

**Repository Path**: wt123/xslx

## Basic Information

- **Project Name**: xslx
- **Description**: 基于注解-简洁版EXCEL输出框架，不支持合并单元格
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2019-06-01
- **Last Updated**: 2021-01-07

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# xlsx
基于POI实现，注解试简易版Excel输出和解析框架，一行代码实现输出和解析。

# frame 包

Excel输出模块，包名没取好（因为最近加入了解析模块搞得不太好取名字）。

## demo
> 输出实体
```java
@Excel(type = ExcelType.XLS, sheetName = "xlsSheet", maxRow = 80)
public class XlsEntity extends TestBaseEntity {
    @CellColumn(cellType = CellType.STRING, header = "名字", order = 1, valueParser = StringValueParser.class)
    protected String name;
    @CellColumn(cellType = CellType.STRING, header = "年龄", order = 3, valueParser = DefaultValueParser.class)
    protected String age;
    @CellColumn(cellType = CellType.STRING, header = "性别", order = 2)
    protected String sex;
    @CellColumn(header = "创建时间", order = 0, dateFormat = "yyyy-MM-dd HH:mm:ss")
    protected Date date;
    @CellColumn(header = "boolean", order = 0, method = "isBt")
    protected boolean b;
    ...
}
```
> 输出核心代码

```java
List<XlsEntity> list = new ArrayList<XlsEntity>();
    for (int i = 0; i < 100; i++) {
        list.add(new XlsEntity("wt" + i, "age" + i, "sex" + i));
    }
new AnnoXlsxCreater().datas(list).createAndWrite(new FileOutputStream("D:/test/anonTest.xls"));
```

# parse 包

Excel解析模块，本来想新开个模块的，想想代码实在太少了，就放一起了。

> 解析到java实体

```java
public class ExcelReadEntity {
	@ColumnIndexMapping(cellIndex = 1)
	private String corpName;
	@ColumnIndexMapping(cellIndex = 2)
	private String businessName;
	@ColumnIndexMapping(cellIndex = 0)
	private String corpId;
	@ColumnIndexMapping(cellIndex = 3)
	private String username;
	@ColumnIndexMapping(cellIndex = 4)
	private String nickname;
	@ColumnIndexMapping(cellIndex = 5)
	private String maxDialog;
	@ColumnIndexMapping(cellIndex = 6)
	private String name;
```

> 解析核心代码

```java
List<ExcelReadEntity> entities = ExcelParseTool.parseExcel("D:\\test\\test.xlsx", ExcelReadEntity.class);
```