Java解析Excel（JXL，仅支持Excel2003）

jxl工具包下载地址:http://download.csdn.net/my/uploads

java读写excel文件代码如下:

import java.io.FileInputStream;
    import java.io.FileOutputStream;
    import java.io.InputStream;
    import java.io.OutputStream;

    import jxl.Cell;
    import jxl.Sheet;
    import jxl.Workbook;
    import jxl.write.Label;
    import jxl.write.WritableCellFormat;
    import jxl.write.WritableFont;
    import jxl.write.WritableSheet;
    import jxl.write.WritableWorkbook;

    public class Excel {
        /**
         * 
         * @Description：读取excel文件
         * @param filePath
         * @throws Exception: 返回结果描述
         * @return void: 返回值类型
         * @throws
         */
        public void readExcel(String filePath) throws Exception{
            InputStream is=new FileInputStream(filePath);
            Workbook wb=Workbook.getWorkbook(is);
            Sheet st=wb.getSheet("Sheet1");
            int row=st.getRows();
            int col=st.getColumns();
            for (int i = 0; i < row; i++) {
                for (int j = 0; j < col; j++) {
                    Cell cell=st.getCell(j, i);
                    String content=cell.getContents();
                    System.out.print(content + "\t");
                }
                System.out.println();
            }
            wb.close();
            is.close();
        }

        /**
         * 
         * @Description：写excel文件
         * @param filePath
         * @throws Exception: 返回结果描述
         * @return void: 返回值类型
         * @throws
         */
        public void writeExcel(String filePath) throws Exception{
            OutputStream os = new FileOutputStream(filePath);
            WritableWorkbook wwb=Workbook.createWorkbook(os);
            WritableSheet ws=wwb.createSheet("Sheet1", 0);
            String[][] content={//初始化写入excel的数据
                    {"名字","性别","爱好","电话"},
                    {"xiaoyi","女","打羽毛球","123"},
                    {"xiaoming","男","打羽毛球","123"},
                    {"admin","女","打羽毛球","123"},
                    {"xiaohong","女","打羽毛球","123"}
            };
            Label label=null;
            WritableFont wf = new WritableFont(WritableFont.ARIAL,12,WritableFont.NO_BOLD,false);//字体,大小,加粗,倾斜
            WritableCellFormat wcf = new WritableCellFormat(wf);
            for (int i = 0; i < content.length; i++) {
                for (int j = 0; j < content[i].length; j++) {
                    label = new Label(j,i,content[i][j],wcf);//列,行,内容,样式
                    ws.addCell(label);
                }
            }
            wwb.write();
            wwb.close();
            os.close();
        }
    }