# EasyExcel

**Repository Path**: ren-chenglei/easy-excel

## Basic Information

- **Project Name**: EasyExcel
- **Description**: EasyExcel demo
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 2
- **Created**: 2024-08-01
- **Last Updated**: 2024-08-01

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README



# 核心函数

## 导入数据

```
String filePath = "C:\\Users\\fkjas\\Desktop\\lixl\\test.xlsx";
EasyExcel.read(filePath, User.class, new ExcelListener()).sheet().doRead();
```

## 导出数据

```
String filePath = "C:\\Users\\fkjas\\Desktop\\lixl\\test.xlsx";
EasyExcel.write(filePath, User.class).sheet("学生信息表").doWrite(list);
```

# 项目实际应用

## 导入数据

```
List<User> userList = EasyExcel.read(newBufferedInputStream(file.getInputStream())).head(User.class).sheet().doReadSync();
```

## 导出数据

```
EasyExcel.write(httpServletResponse.getOutputStream(), User.class).sheet("用户信息").doWrite(userList);
```

# 相关注解

## @ExcelProperty

### 作用

标注列名以及各列的前后顺序

### 示例

```
@ExcelProperty(index = 0, value = "姓名")
private String userName;
```