jxl创建、解析Excel-01

import java.io.File;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;


public class jxlExpExcel {

    /**
     * JXL创建Excel
     * @param args
     * 
     * 行：row,单元格：cell
     * （注：首先添加jxl.jar）
     */
    public static void main(String[] args) {

        String[] title = {"id","name","sex"};

        // 创建Excel文件
        File file = new File("e:/jxl_test.xls");
        try {
            file.createNewFile();
            //创建工作薄
            WritableWorkbook workbook = Workbook.createWorkbook(file);
            //创建sheet页
            WritableSheet sheet = workbook.createSheet("sheet1", 0);
            Label label = null;
            //第一行设置列名
            for(int i=0;i<title.length;i++){
                label = new Label(i,0,title[i]);//第几列，第几行，内容
                sheet.addCell(label);
            }
            //追加数据
            for(int i=1;i<10;i++){
                label = new Label(0,i,"a"+1);
                sheet.addCell(label);

                label = new Label(1,i,"user"+i);
                sheet.addCell(label);

                label = new Label(2,i,"男");
                sheet.addCell(label);
            }

            //写入数据
            workbook.write();
            workbook.close();

        } catch (Exception e) {
            e.printStackTrace(); 
        }


    }

}

以下是解析操作，同样是新建测试类

import java.io.File;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;


public class jxlReadExcel {

    /**
     * jxl解析Excel
     * @param args
     */
    public static void main(String[] args) {

        try {
            //创建workbook
            Workbook workbook = Workbook.getWorkbook(new File("e:/jxl_test.xls"));
            //获取第一个工作表sheet
            Sheet sheet = workbook.getSheet(0);
            //获取数据
            for(int i=0;i<sheet.getRows();i++){//遍历行
                for(int j=0;j<sheet.getColumns();j++){//遍历列
                    Cell cell = sheet.getCell(j, i);//第几列，第几行
                    System.out.print(cell.getContents()+"   ");
                }
                System.out.println();
            }
            workbook.close();

        } catch (Exception e) {
            e.printStackTrace();
        }

    }

}