jxls导入Excel的问题
发布网友
发布时间:2022-05-12 16:10
我来回答
共2个回答
热心网友
时间:2022-05-19 18:28
不知道时间是来及,但还是写个可能性解决方案吧,在<mapping>标签中加入属性nullAllowed="true"就可以了
热心网友
时间:2022-05-19 18:28
Workbook workbook = Workbook.getWorkbook(new File(filePath));
Sheet sheet = workbook.getSheet(0);
int col = sheet.getColumns();
int row = sheet.getRows();
String result[][] = new String[row][col];
Cell cell;
// i列 j行
System.out.println("col:"+col+" row: "+row);
for (int i = 0; i < row; i++) {
if(i!=0){
SubjectEntity sub=new SubjectEntity();
for (int j = 0; j < col; j++) {
cell = sheet.getCell(j, i);
result[i][j] = cell.getContents();
if(j==0){
sub.setQuestion(result[i][j]);