/**
* 通过excel导入数据
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/importExcel", method = RequestMethod.POST)
public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
return super.importExcel(request, response, PunchCard.class);
}
}
实体类里空白地方 用一个空属性 做占位符 String value;
${value}
引用Spire.Xls.jar包,用下面代码删除Excel表格中的空白行然后再导入
import com.spire.xls.ExcelVersion;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
public class RemoveBlankRowsFromExcel {
public static void main(String[] args){
Workbook workbook = new Workbook();
//加载Excel
workbook.loadFromFile("Sample.xlsx");
//获取第一张工作表
Worksheet sheet = workbook.getWorksheets().get(0);
//获取总行数
int rowCount = sheet.getRows().length;
//遍历所有行
for (int i = rowCount - 1; i >= 0; i--)
{
//判断行是否为空
if (sheet.getRows()[i].isBlank())
{
//删除空白行
sheet.deleteRow(i + 1); //索引从1开始
}
}
//保存
workbook.saveToFile("DeleteBlankRows.xlsx", ExcelVersion.Version2013);
}
}