poi读excel2003总结(一)

 

1、顺便读到对象模型中，一行是一个对象

public class ReadExcel{
    public static String fileName = "C:\\xls\\EXCEL.xls";
    public static void main(String argv[])
    {
        List list = readExcel();
    }

    /** *//**
     * 读取磁盘上的EXCEL文件的内容
     * @return List
     */
    public static List readExcel()
    {
        List<Person> list = null;
        Pserson p = null;
        try
        {
            HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(
                    fileName)); //得到excel对象
            HSSFSheet sheet = workbook.getSheetAt(0); //得到第一个sheet
            int rows = sheet.getPhysicalNumberOfRows(); //得到行数
            list = new ArrayList<Person>();
            for (int i = 1; i < rows; i++)
            {
                HSSFRow row = sheet.getRow(i);
                p = new Person();
                HSSFCell cell = row.getCell((short) 0); //得到列0(下标0,为第一列)
                p.setName(cell.getStringCellValue());
                cell = row.getCell((short) 1); //得到列 1
                p.setEmail(cell.getStringCellValue());
                cell = row.getCell((short) 2); //得到列2
                p.setPhone(cell.getStringCellValue());
                cell = row.getCell((short) 3); //得到列3
                p.setPasswd(cell.getStringCellValue());
                list.add(p);
            }
            return list;
        }
        catch (Exception e)
        {
            return null;
        }
    }

 参考:http://www.blogjava.net/jwin/archive/2007/12/11/167093.html

 

2、

public class POIExcelUtil {

	public static void main(String[] args) {
		POIExcelUtil excel = new POIExcelUtil();
		excel.readExcel();
		System.out.println("结束");
	}

		
	public void readExcel(){
		File file = new File("d:\\test.xls");
		String value = "";
		try {
			FileInputStream fis = new FileInputStream(file);
			HSSFWorkbook workBook = new HSSFWorkbook(fis);
			//HSSFSheet sheet1 = workBook.getSheet("sheet1");//按名称取得sheet
			HSSFSheet sheet1 = workBook.getSheetAt(0);//按索引号取得sheet1
			
			fis.close();
			int rows = sheet1.getLastRowNum();
			for(int i = 0; i <= rows; i++)
			{
				HSSFRow row = sheet1.getRow(i);
				if(row != null)
				{
					int cells = row.getLastCellNum();
					for(int j = 0 ; j < cells; j++)
					{
						HSSFCell cell = row.getCell(j);
						if(cell != null)
						{
							switch(cell.getCellType())
							{
							case HSSFCell.CELL_TYPE_BLANK:
								break;
							case HSSFCell.CELL_TYPE_BOOLEAN:
								value += "  " + cell.getBooleanCellValue();
								break;
							case HSSFCell.CELL_TYPE_ERROR:
								value += "  " + cell.getErrorCellValue();
								break;
							case HSSFCell.CELL_TYPE_FORMULA:
								value += "  " + cell.getCellFormula();
								break;
							case HSSFCell.CELL_TYPE_NUMERIC:
								value += "  " + cell.getNumericCellValue();
								break;
							case HSSFCell.CELL_TYPE_STRING:
								value += "  " + cell.getRichStringCellValue();
								break;
							default:
								value += "  cell类型不符";
							}
						}
					}
				}
			}
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		}catch(IOException ioe){
			ioe.printStackTrace();
		}
		System.out.println(value);
	}
}

参考：http://gzwfdy.iteye.com/blog/309592