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();        }    }