导入Excel读取数据的小例子

package uploadgetdata; import java.io.File; import java.io.IOException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.Iterator; import java.util.List; import javax.servlet.ServletConfig; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import jxl.Cell; import jxl.CellType; import jxl.DateCell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; import org.apache.commons.fileupload.FileItem; import org.apache.commons.fileupload.disk.DiskFileItemFactory; import org.apache.commons.fileupload.servlet.ServletFileUpload; import net.sf.json.JSONArray; @SuppressWarnings("serial") public class UploadGetDataServlet extends HttpServlet { private ServletContext sc; private String uploadDir = "temp"; public void init(ServletConfig config) { sc = config.getServletContext(); } public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { response.setContentType("text/html;charset=UTF-8");// 防止中文乱码 DiskFileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); String filepath = ""; List alist = new ArrayList(); try { List items = upload.parseRequest(request); Iterator itr = items.iterator(); while (itr.hasNext()) { FileItem item = (FileItem) itr.next(); if (item.isFormField()) { System.out.println("表单参数名：" + item.getFieldName() + ",表单参数值：" + item.getString("UTF-8")); } else { if (item.getName() != null && !item.getName().equals("")) { System.out.println("上传文件的大小：" + item.getSize()); System.out.println("文件的类型：" + item.getContentType()); System.out.println("上传文件的名称：" + item.getName());// 返回上传文件在客户端的完整路径名称 filepath = sc.getRealPath("/") + File.separatorChar + uploadDir + File.separatorChar + item.getName(); File file = new File(filepath); item.write(file); } else { response.getWriter().println("nofile"); } } } } catch (Exception e) { response.getWriter().println("expfail！"); e.printStackTrace(); } // 读取excel的内容 if (!"".equals(filepath)) { try { Workbook book = Workbook.getWorkbook(new File(filepath)); // 获到第一个工作表对象 Sheet sheet = book.getSheet(0); int cols = sheet.getColumns(); int rows = sheet.getRows(); for (int i = 0; i < rows; i++) { List blist = new ArrayList(); for (int j = 0; j < cols; j++) { String data = ""; Cell cell = sheet.getCell(j, i); //读取的日期自动格式为“yy-MM-dd”，需要转换一下格式 if (cell.getType() == CellType.DATE) { DateCell dc = (DateCell) cell; Date date = dc.getDate(); SimpleDateFormat ds = new SimpleDateFormat("yyyy-MM-dd"); data = ds.format(date); }else{ data = cell.getContents(); } blist.add(data); System.out.println("读出单元格的内容为" + data); } alist.add(blist); } book.close(); JSONArray data = JSONArray.fromObject(alist); System.out.println("jsondata:" + data); response.getWriter().println("jsondata:" + data); } catch (BiffException e) { response.getWriter().println("readfail！"); System.out.println(e); } } } }