使用POI-HSSF读取excel文件

POI官方网址：http://poi.apache.org/
POI是Apache一个开源项目,主要解决使用java阅读和创建MS系列的Word,Excel,PowerPoint,Visio等文档
这里只附上使用POI读取Excel文件的一个小例子，如果需要使用POI的其他功能，请浏览 http://poi.apache.org/ ，有很多例子。

本程序读取的excel文件样本
[img]/upload/attachment/76338/9ada99dc-ae97-3a9f-9da4-28f200816bc1.jpg[/img]

本程序使用以下jar
[img]/upload/attachment/76340/36b18af4-cd93-3662-b4f8-fe5181b394ed.jpg[/img]

package com.wyh.excel.business;

import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

/**
 * @author azkaban
 * 2008-6-24
 */

public class ReadWorkbook {

    /**
     * @param args
     */
    public static void main(String[] args) {
        try {
            new ReadWorkbook().read();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void read() {

        try {
            List<String> artistList = new ArrayList<String>();
            List<String> songList = new ArrayList<String>();

            POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("E:\\workspace\\ex_Excel\\res\\workbook.xls"));
            HSSFWorkbook wb = new HSSFWorkbook(fs);
            HSSFSheet sheet = wb.getSheetAt(0);

            for (Iterator rit = sheet.rowIterator(); rit.hasNext(); ) {    //迭代行
                HSSFRow row = (HSSFRow)rit.next();
                int i = 0;
                for (Iterator cit = row.cellIterator(); cit.hasNext(); ) {//迭代列
                    HSSFCell cell = (HSSFCell)cit.next();
                    String strCell = "";  
                    switch (cell.getCellType()) {
                        case HSSFCell.CELL_TYPE_NUMERIC: strCell = String.valueOf(cell.getNumericCellValue());  
                            break;  
                        case HSSFCell.CELL_TYPE_STRING: strCell = cell.getStringCellValue();  
                            break;  
                        case HSSFCell.CELL_TYPE_BOOLEAN: strCell = String.valueOf(cell.getBooleanCellValue());  
                            break;  
                        default: strCell = "";  
                            break;  
                    }

                    if (i == 1) {
                        songList.add(strCell);
                    } else if (i == 2) {
                        artistList.add(strCell);
                    }
                    i++;
                }
            }
            System.out.println("songList.size:"+songList.size());
            System.out.println("artistList.size:"+artistList.size());
            for (String s : songList) {
                System.out.println(s);
            }
            for (String s : artistList) {
                System.out.println(s);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
}