src/com/mwq/stat/tool/ExportTableToExcel.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.mwq.stat.tool;
import com.mwq.stat.dataform.DataFormInterface;
import java.io.File;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Colour;
import jxl.format.UnderlineStyle;
import jxl.format.VerticalAlignment;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
public class ExportTableToExcel implements DataFormInterface {
    public ExportTableToExcel(File file, String heading, String subheading,
            String inscribe) {
        try {
            WritableWorkbook workbook = null;// 创建工作薄
            if (file.exists()) {// 文件已经存在
                workbook = Workbook.createWorkbook(file, Workbook
                        .getWorkbook(file));
            } else {// 文件还不存在
                workbook = Workbook.createWorkbook(file);
            }
            WritableSheet sheet = workbook.createSheet(heading, workbook
                    .getNumberOfSheets());// 创建工作表
            int mergeNumberOfColumns = columnName.size();// 获取表格列数
            fillHeading(sheet, heading, mergeNumberOfColumns);// 填写主标题
            fillSubheading(sheet, subheading, mergeNumberOfColumns);// 填写副标题
            fillInscribe(sheet, inscribe, mergeNumberOfColumns);// 填写落款
            fillColumnName(sheet);// 填写列名
            fillCell(sheet);// 填写数据
            workbook.write();// 写入工作薄
            workbook.close();// 关闭工作薄
        } catch (Exception ex) {
            Logger.getLogger(ExportTableToExcel.class.getName()).log(
                    Level.SEVERE, null, ex);
        }
    }
    // 填写主标题
    private void fillHeading(WritableSheet sheet, String heading,
            int mergeNumberOfColumns) throws WriteException {
        WritableFont font = new WritableFont(WritableFont.ARIAL, 18,
                WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,
                Colour.RED);// 定义字体
        WritableCellFormat format = new WritableCellFormat(font);// 创建格式化对象
        format.setAlignment(Alignment.CENTRE);// 水平居中显示
        format.setVerticalAlignment(VerticalAlignment.CENTRE);// 垂直居中显示
        sheet.mergeCells(0, 0, mergeNumberOfColumns - 1, 0);// 合并单元格
        sheet.setRowView(0, 600);// 设置行高
        sheet.addCell(new Label(0, 0, heading, format));// 填写工作表
    }