实现步骤:
1 使用commons-fileupload上传文件
2 使用HSSFWorkBooK读取数据
所需jar包:
文件上传的jar下载 :点击这里
HSSFWorkbook所用jar包下载:点击这里
servlet.java
package cn.imports.com;
import java.io.IOException;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.excel.util.ImportUtil;
import cn.upload.util.FileUploadUtil;
/**
* 导入Excel数据表
* @author
*/
@SuppressWarnings("serial")
public class ImportServlet extends HttpServlet{
@SuppressWarnings({ "deprecation", "unchecked" })
@Override
public void doPost(HttpServletRequest request, HttpServletResponse resp)throws ServletException, IOException {
try {
String path = request.getRealPath("/upload");
String filename = FileUploadUtil.filesUpload(request, path);
System.out.println("upload success! reading...");
List list = ImportUtil.read(path + "/" + filename, 5);//从表的第5行开始读取
for(Iterator iterator = list.iterator();iterator.hasNext();){
Map perRecord = (Map) iterator.next();
String xuhao = (String)perRecord.get("1") == null ? &