exel表处理

         /**获取指定工作簿的数据
	 * 
	 * @param excelPath    文件路径
	 * @param sheetName    文件工作簿名
	 */
	public static void getExcelDatas(String excelPath,String sheetName) {
		File file = new File(excelPath);
		try {
                        //获取Workbook 对象
			Workbook workbook = WorkbookFactory.create(file);
			Sheet sheet = workbook.getSheet(sheetName);
			int lastRowNum = sheet.getLastRowNum();
                        
			for (int i = 0; i <= lastRowNum; i++) {
                                //获取行对象
				Row row = sheet.getRow(i);
				int lastCellNum = row.getLastCellNum();
                                //循环获取列对象
				for (int j = 0; j < lastCellNum; j++) {
					Cell cell = row.getCell(j, MissingCellPolicy.CREATE_NULL_AS_BLANK);
                                        //列类型转换为字符串
					cell.setCellType(CellType.STRING);
                                        //获取列值
					String value = cell.getStringCellValue();
					System.out.print("【"+value+"】");
				}
				System.out.println();
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}