Java上传Excel
写的Execl上传包含了很多逻辑和需求,如果业务不需要那么复杂的话可以省略一些判断,只用看readSheet、excData这两个方法,一个读数据,一个讲数据转换为我们需要的实体类
- 尬包
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
- 代码
@Service
@Transactional
public class ExcelUploadServiceImpl implements ExcelUploadService
{
//判断excel的大小
public static final int FILE_MAX_SIZE = 1024 * 1024 * 50;
private String fileFileName;
public File readFile = null;
private File file;
public File getFile() {
return file;
}
public void setFile(File file) {
this.file = file;
}
public String getFileFileName() {
return fileFileName;
}
public void setFileFileName(String fileFileName) {
this.fileFileName = fileFileName;
}
public String excelUpload() throws Exception {
this.readFile = readFile;
Map<String, Object> mapresult = new HashMap<String, Object>();
//判断文件是否是xls文件
if (!(fileFileName.endsWith("xls"))) {
msg = getText("请上传xls格式");
mapresult.put("msg", msg);
mapresult.put("result", "0");
if (request.getAttribute("token") == "false-null") {
mapresult.put("token", "false-null");
}
//为angularJS返回值替换为你们用到的前端返回值就行
this.setResponseJson(mapresult);
return SUCCESS;
}
//msg为解析