java解析excel文件

function uploadMsg(msg){
			alert(msg);
		}

	<form name="ajax_form" action=smsManyImp.do enctype="multipart/form-data" target="hidden_frame" method="post">  
		<table cellpadding="0" cellspacing="0" class="DataShowTable">
			<tr>
				<td width="35%" class="TRight" >
					<b><srt:show>Excel文件</srt:show>：</b>
				<br></td>
				<td>
					<input class="MInputTT W150" type="file" name="excelFile" id="excelFile" />
				<br></td>
			</tr>

			<tr>
				<td colspan="2" style="text-align:center;">
				<iframe name='hidden_frame' id="hidden_frame" style="display:none"></iframe>
					<input type="submit" value="<srt:show>确定</srt:show>" id="uploadButton" class="BtnL2">
					<input type="button" value="<srt:show>取消</srt:show>" id="uploadCancel" class="BtnL2" onclick="$('#uploadDiv').window('close');">
				<br></td>
			</tr>
		</table>
		</form>

public String smsManyImp() throws IOException{
		HttpServletResponse response = ServletActionContext.getResponse();
		response.setHeader("pragma", "no-cache");
		response.setHeader("cache-control", "no-cache");
		response.setHeader("expires", "0");
		response.setHeader("content-type", "text/html;charset=utf-8");
		if(excelFile==null||excelFileFileName==null||excelFileFileName.equals("")){
			response.getWriter().write("<script>parent.uploadMsg('请选择导入的Excel文件！')</script>");   
			response.getWriter().flush();
			return NONE;
		}
		if(!checkFileExt()){
			response.getWriter().write("<script>parent.uploadMsg('导入的文件非Excel格式，请重新选择！')</script>");   
			response.getWriter().flush();
			return NONE;
		}
		try {
			is = new FileInputStream(excelFile);
			HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is); 
			StringBuffer sb = new StringBuffer(1024);
			for (int numSheet = 1; numSheet < hssfWorkbook.getNumberOfSheets(); numSheet++) {
				HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(numSheet); 
	            if (hssfSheet == null) { 
	                continue; 
	            } 
	            for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) { 
	                HSSFRow hssfRow = hssfSheet.getRow(rowNum); 
	                if (hssfRow == null) { 
	                    continue; 
	                }
	                HSSFCell mobile = hssfRow.getCell(0);
	                String mobileNo = mobile.getStringCellValue();
	                if(mobileNo!=null&&CommStr.isMobileNO(mobileNo))//校验是否为手机号
	                	sb.append(mobileNo).append(",").append(hssfRow.getCell(1)).append("|");
	            }
			}
			//清空占用内存
			clearData();
			response.getWriter().write("<script>parent.uploadCallback('"+sb.toString()+"')</script>");   
			response.getWriter().flush();
			return NONE;
		} catch (Exception e) {
			e.printStackTrace();
			response.getWriter().write("<script>parent.uploadCallback('"+e.getMessage()+"')</script>");   
			response.getWriter().flush();
			return NONE;
		}
	}