@Data
public class ExcelEntity {
@ExcelProperty("一")
private String one;
@ExcelProperty("二")
private String two;
@ExcelProperty("三")
private String three;
@ExcelProperty("四")
private String four;
@ExcelProperty("五")
private String five;
@ExcelProperty("六")
private String six;
}
/**
* 小学数学加减发生生Excel文档
*/
public class ExcelTest {
@Test
public void ExcelWrite(){
String filename = "C:\\Users\\86159\\Desktop\\算术题.xlsx";
ExcelWriter excelWriter = EasyExcel.write(filename,ExcelEntity.class).build();
WriteSheet writeSheet = EasyExcel.writerSheet("模板").registerWriteHandler(new SimpleColumnWidthStyleStrategy(12)).build();
for (int i = 0; i < 10; i++) {
List<ExcelEntity> data = data();
excelWriter.write(data,writeSheet);
}
excelWriter.finish();
}
private List<ExcelEntity> data(){
List<ExcelEntity> list = new ArrayList<>();
for (int i = 0; i < 5; i++) {
ExcelEntity excelEntity = new ExcelEntity();
for(int j=0;j<10;j++) {
int a = (int) (Math.random() * 50 + 1);
int minus = (int) (Math.random() * 50 + 1);
int as = (int) (Math.random() * 50 + 1);//决定是加法还是减法算式;
if (as % 2 == 0) {//执行加法运算
excelEntity.setOne(a + "+" + minus + "=");
} else {//执行减法
if (a < minus) {
excelEntity.setOne(minus + "-" + a + "=");
} else {
excelEntity.setOne(a + "-" + minus + "=");
}
}
}
for(int j=0;j<10;j++) {
int a = (int) (Math.random() * 50 + 1);
int minus = (int) (Math.random() * 50 + 1);
int as = (int) (Math.random() * 50 + 1);//决定是加法还是减法算式;
if (as % 2 == 0) {//执行加法运算
excelEntity.setTwo(a + "+" + minus + "=");
} else {//执行减法
if (a < minus) {
excelEntity.setTwo(minus + "-" + a + "=");
} else {
excelEntity.setTwo(a + "-" + minus + "=");
}
}
}
for(int j=0;j<10;j++) {
int a = (int) (Math.random() * 50 + 1);
int minus = (int) (Math.random() * 50 + 1);
int as = (int) (Math.random() * 50 + 1);//决定是加法还是减法算式;
if (as % 2 == 0) {//执行加法运算
excelEntity.setThree(a + "+" + minus + "=");
} else {//执行减法
if (a < minus) {
excelEntity.setThree(minus + "-" + a + "=");
} else {
excelEntity.setThree(a + "-" + minus + "=");
}
}
}
for(int j=0;j<10;j++) {
int a = (int) (Math.random() * 50 + 1);
int minus = (int) (Math.random() * 50 + 1);
int as = (int) (Math.random() * 50 + 1);//决定是加法还是减法算式;
if (as % 2 == 0) {//执行加法运算
excelEntity.setFour(a + "+" + minus + "=");
} else {//执行减法
if (a < minus) {
excelEntity.setFour(minus + "-" + a + "=");
} else {
excelEntity.setFour(a + "-" + minus + "=");
}
}
}
for(int j=0;j<10;j++) {
int a = (int) (Math.random() * 50 + 1);
int minus = (int) (Math.random() * 50 + 1);
int as = (int) (Math.random() * 50 + 1);//决定是加法还是减法算式;
if (as % 2 == 0) {//执行加法运算
excelEntity.setFive(a + "+" + minus + "=");
} else {//执行减法
if (a < minus) {
excelEntity.setFive(minus + "-" + a + "=");
} else {
excelEntity.setFive(a + "-" + minus + "=");
}
}
}
for(int j=0;j<10;j++) {
int a = (int) (Math.random() * 50 + 1);
int minus = (int) (Math.random() * 50 + 1);
int as = (int) (Math.random() * 50 + 1);//决定是加法还是减法算式;
if (as % 2 == 0) {//执行加法运算
excelEntity.setSix(a + "+" + minus + "=");
} else {//执行减法
if (a < minus) {
excelEntity.setSix(minus + "-" + a + "=");
} else {
excelEntity.setSix(a + "-" + minus + "=");
}
}
}
list.add(excelEntity);
}
return list;
}
}
<dependencies>
<dependency>
<groupId>com.github.majiweihappy</groupId>
<artifactId>easyexcel</artifactId>
<version>1.0-RELEASE</version>
</dependency><--这个有没有都行-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
</dependency>
</dependencies>