wxdChinese commented on issue #773:
URL: https://github.com/apache/fesod/issues/773#issuecomment-3708757070
> 为了更准确地找出问题所在，请您提供以下文件或一个最小可复现示例？
>
> * QuestionFailedExcel 和 QuestionExcel
> * questionFailedTemplate.xlsx
> * importTempFile.xlsx
```
@Data
public class QuestionExcel {
@ExcelProperty(value = "题目", index = 0)
@Size(max = 500, message = "题目长度不能超过{max}")
@NotBlank(message = "题目不能为空")
private String question;
@ExcelProperty(value = "题目图片", index = 1)
private String questionImg;
@ExcelProperty(value = "类型", index = 2)
@NotBlank(message = "类型不能为空")
private String type;
@ExcelProperty(value = "难易度", index = 3)
@NotBlank(message = "难易度不能为空")
private String difficulty;
@ExcelProperty(value = "选项A（正确）", index = 4)
@Size(max = 500, message = "选项A（正确）长度不能超过{max}")
private String optionA;
@ExcelProperty(value = "选项B（错误）", index = 5)
@Size(max = 500, message = "选项B（错误）长度不能超过{max}")
private String optionB;
@ExcelProperty(value = "选项C", index = 6)
@Size(max = 500, message = "选项C长度不能超过{max}")
private String optionC;
@ExcelProperty(value = "选项D", index = 7)
@Size(max = 500, message = "选项D长度不能超过{max}")
private String optionD;
@ExcelProperty(value = "选项E", index = 8)
@Size(max = 500, message = "选项E长度不能超过{max}")
private String optionE;
@ExcelProperty(value = "选项F", index = 9)
@Size(max = 500, message = "选项F长度不能超过{max}")
private String optionF;
@ExcelProperty(value = "选项G", index = 10)
@Size(max = 500, message = "选项G长度不能超过{max}")
private String optionG;
@ExcelProperty(value = "选项H", index = 11)
@Size(max = 500, message = "选项H长度不能超过{max}")
private String optionH;
@ExcelProperty(value = "选项I", index = 12)
@Size(max = 500, message = "选项I长度不能超过{max}")
private String optionI;
@ExcelProperty(value = "选项J", index = 13)
@Size(max = 500, message = "选项J长度不能超过{max}")
private String optionJ;
@ExcelProperty(value = "选项K", index = 14)
@Size(max = 500, message = "选项K长度不能超过{max}")
private String optionK;
@ExcelProperty(value = "选项L", index = 15)
@Size(max = 500, message = "选项L长度不能超过{max}")
private String optionL;
@ExcelProperty(value = "选项M", index = 16)
@Size(max = 500, message = "选项M长度不能超过{max}")
private String optionM;
@ExcelProperty(value = "选项N", index = 17)
@Size(max = 500, message = "选项N长度不能超过{max}")
private String optionN;
@ExcelProperty(value = "选项O", index = 18)
@Size(max = 500, message = "选项O长度不能超过{max}")
private String optionO;
@ExcelProperty(value = "选项P", index = 19)
@Size(max = 500, message = "选项P长度不能超过{max}")
private String optionP;
@ExcelProperty(value = "选项Q", index = 20)
@Size(max = 500, message = "选项Q长度不能超过{max}")
private String optionQ;
@ExcelProperty(value = "选项R", index = 21)
@Size(max = 500, message = "选项R长度不能超过{max}")
private String optionR;
@ExcelProperty(value = "选项S", index = 22)
@Size(max = 500, message = "选项S长度不能超过{max}")
private String optionS;
@ExcelProperty(value = "选项T", index = 23)
@Size(max = 500, message = "选项T长度不能超过{max}")
private String optionT;
@ExcelProperty(value = "解析", index = 24)
@Size(max = 500, message = "解析长度不能超过{max}")
private String parse;
@ExcelProperty(value = "答案", index = 25)
@NotBlank(message = "答案不能为空")
@Size(max = 20, message = "答案长度不能超过{max}")
@Pattern(regexp = "^(?!.*([A-T]).*\\1)[A-T]{1,20}$", message = "答案格式不正确")
private String answer;
@ExcelProperty(value = "精选", index = 26)
@NotBlank(message = "精选不能为空")
private String featured;
}
@Data
public class QuestionFailedExcel extends QuestionExcel {
@ExcelProperty("错误信息")
private String failedMessage;
}
```
[questionFailedTemplate.xlsx](https://github.com/user-attachments/files/24425974/questionFailedTemplate.xlsx)
[questionTemplate.xlsx](https://github.com/user-attachments/files/24425977/questionTemplate.xlsx)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
