一个例子让你学会使用jxl

/**
     * excel
     * @param teacherComments
     * @throws IOException
     * @throws WriteException
     */
    private void writeExcel(List<ClassTeacherComment> teacherComments) throws IOException, WriteException {
        String title = ScUtil.stringEncode(commentVO.getTitle(), "iso-8859-1", "utf-8");
        OutputStream os = ScUtil.getOs(getResponse(), title);
        WritableWorkbook wwb = Workbook.createWorkbook(os);
        RGBColor.initialize(wwb);
        WritableSheet sheet = wwb.createSheet("sheet 1", 0);
        for(int i = 0; i < 3; i++) {
            sheet.setColumnView(i, 15);
        }

// 设置列的宽度
        sheet.setColumnView(3, 100);
        sheet.setRowView(0, 350);

```java
// 设置行的高度

sheet.setRowView(1, 350);sheet.mergeCells(0, 0, 3, 1);Label sheetTitle = new Label(0, 0, title, getHeaderFont(14));sheet.addCell(sheetTitle);WritableCellFormat headerFormmate = getHeaderFont(11);

// 格式化背景色
        headerFormmate.setBackground(RGBColor.BLUE2);
        sheet.setRowView(2, 500);
        Label header1 = new Label(0, 2, "用户名", headerFormmate);
        Label header2 = new Label(1, 2, "学号", headerFormmate);
        Label header3 = new Label(2, 2, "姓名", headerFormmate);
        Label header4 = new Label(3, 2, "评语", headerFormmate);
        sheet.addCell(header1);// 向sheet中添加一个Label
        sheet.addCell(header2);
        sheet.addCell(header3);
        sheet.addCell(header4);

        WritableCellFormat dataFormmate = getDataFont(10);
        dataFormmate.setWrap(true);
        ClassTeacherComment comment = null;
        User user = null;
        for (int i = 0; i < teacherComments.size(); i++) {
            comment = teacherComments.get(i);
            user = comment.getStudent();
            Label col0 = new Label(0, i + 3, user.getAccount(), dataFormmate);
            Label col1 = new Label(1, i + 3, user.getStudentNumber(), dataFormmate);
            Label col2 = new Label(2, i + 3, user.getName(), dataFormmate);
            Label col3 = new Label(3, i + 3, comment.getComment(), dataFormmate);
            sheet.setRowView(i + 3, 1000);
            sheet.addCell(col0);
            sheet.addCell(col1);
            sheet.addCell(col2);
            sheet.addCell(col3);
        }

        wwb.write();
        wwb.close();
        os.close();
    }
    /**
     * 获得excel标题或表头格式
     * @param fontSize 字体大小
     * @return
     * @throws WriteException
     */
    private WritableCellFormat getHeaderFont(int fontSize) throws WriteException {
        WritableFont titleFont = new WritableFont(WritableFont.createFont("宋体"),  
                fontSize, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE); 
        WritableCellFormat titleFormat = new WritableCellFormat(titleFont);
        titleFormat.setAlignment(Alignment.CENTRE); // 水平居中对齐
        titleFormat.setVerticalAlignment(VerticalAlignment.CENTRE); // 竖直方向居中对齐
        titleFormat.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN, Colour.GRAY_25);
        return titleFormat;
    }
    /**
     * 获得excel数据格式
     * @param fontSize 字体大小
     * @return
     * @throws WriteException
     */
    private WritableCellFormat getDataFont(int fontSize) throws WriteException {
        WritableFont bodyFont = new WritableFont(WritableFont.createFont("宋体"),  
                fontSize, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE); 
        WritableCellFormat bodyFormat = new WritableCellFormat(bodyFont);
        bodyFormat.setAlignment(Alignment.LEFT); // 水平居中对齐
        bodyFormat.setVerticalAlignment(VerticalAlignment.CENTRE); // 竖直方向居中对齐
        bodyFormat.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN, Colour.GRAY_25);
        return bodyFormat;
    }

```