话不多说,直接上码!!!
@RequestMapping(path="/upload", method=RequestMethod.POST)
public void upload(@RequestParam("excelFile")Part excelFile, PrintWriter out) throws Exception{
String filename = excelFile.getSubmittedFileName();//获取文件的名字
InputStream inputStream = excelFile.getInputStream();//获取文件流
transactionRecordsService.ReadyTransactionRecords(inputStream,filename);
out.write(1);
}
//判断Excel表格是07或者是03的,因为07与03的方法不一样
@Override
public void ReadyTransactionRecords(InputStream instream,String filename) {
try {
if(filename.endsWith(EXTENSION_XLS)) {
Ready03(instream);
}else {
Ready(instream);
}
} catch (IOException | ParseException e) {
e.printStackTrace();
}
}