poi读excel

import java.awt.Color;
import java.awt.Font;
import java.awt.RenderingHints;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Date;

import org.apache.poi.hpsf.PropertySetFactory;
import org.apache.poi.hpsf.SummaryInformation;
import org.apache.poi.hssf.record.RecordInputStream;
import org.apache.poi.hssf.usermodel.EscherGraphics;
import org.apache.poi.hssf.usermodel.EscherGraphics2d;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFClientAnchor;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFPatriarch;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFShapeGroup;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellRangeAddress;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.poifs.eventfilesystem.POIFSReader;
import org.apache.poi.poifs.eventfilesystem.POIFSReaderEvent;
import org.apache.poi.poifs.eventfilesystem.POIFSReaderListener;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

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);
			POIFSFileSystem POIStream = new POIFSFileSystem(fis);
			HSSFWorkbook workBook = new HSSFWorkbook(POIStream);
			//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);
	}
}