wicket框架下如何将表格数据导出Excel

将页面一的表格导出Excel,需要专门写一个Excel类和几个附属操作类，同时，在页面一的java代码里面写一个方法，此过程比较复杂，不过大部分代码copy就可以用，只需要改自己要替换的内容就可以了。

java代码如下：

首先是方法的创建

public void createExcel(){

//创建Excel类的对象，可以自定义带参构造，传入参数
//我的项目里传入了三个参数，大家可以参考自己的需求
//selectedYear,selectedMonth,monthDay
final ExportPersonalPageExcel excelExport = new ExportPersonalPageExcel(selectedYear,selectedMonth,monthDay);

//国际化文件，里面是自定义中文索引，nav.report.userWorkday的内容为导出Excel的文件名
String filename =new ResourceModel("nav.report.userWorkday").getObject()+".xls";

//通过数据库查询将结果放入集合中（此步骤只是为了说明要获取数据，里面的集合泛型和数据获取方法不讨论，大家根据自己需求设计）
final List<PersonalProElement> personalProElements = personalservice.getResult(selectedYear,selectedMonth,monthDay);
getRequestCycle().scheduleRequestHandlerAfterCurrent(new ExcelRequestHandler(filename, new Function<byte[]>() {
                        @Override
                        public byte[] apply() {
                            return excelExport.getExcelData(personalProElements);
                        }
                    }));
}

Excel类的创建

public class ExportPersonalPageExcel {
    private List<PersonalProElement> list;
    private HSSFRow hssf_w_r = null;//创建一行
    private HSSFCell hssf_w_c = null;//每个单元格
    HSSFWorkbook hssf_w_wk = null;
    HSSFSheet hssf_w_s = null;
    int j = 0;
    private Integer selectedYear;
    private Integer selectedMonth;
    private int monthday;

    public ExportPersonalPageExcel(Integer selectedYear,Integer selectedMonth,int monthday){
        this.selectedYear=selectedYear;
        this.selectedMonth=selectedMonth;
        this.monthday=monthday;
    }


    public byte[] getExcelData(List<PersonalProElement> list) {
        this.list = list;
        ExcelWorkbook workbook = createWorkbook();
        try {
            return PoiUtil.getWorkbookAsBytes(workbook);
        } catch (IOException e) {
            return new byte[0];
        }
    }

    private ExcelWorkbook createWorkbook() {

        ExcelWorkbook workbook = new ExcelWorkbook();
        Excelbookshell.setExcelbook("your_name");

        List<String> head = new ArrayList<String>();
        //设计Excel的表头名称，同样用的是国际化文件
        head.add(new ResourceModel("daysQuery.table.project").getObject());
        head.add(new ResourceModel("daysQuery.stage").getObject());
        head.add(new ResourceModel("printMonth.help.header").getObject());
        head.add(new ResourceModel("op.lock.admin.affectedUsers.name.label").getObject());
        head.add(new ResourceModel("personProject.trueWorkDay").getObject());
        head.add(new ResourceModel("personProject.resources").getObject());
        try {

            hssf_w_s = workbook.createSheet(new ResourceModel("nav.report.userWorkday").getObject());
            //填写内容
            int col_count = 0;
            int row_count = 0;
            row_count = list.size();
            col_count = head.size();

            //标题
            int titleRows = 0; //标题占据的行数
            hssf_w_r = hssf_w_s.createRow(0);
            //第一行写入标题行
            hssf_w_r = hssf_w_s.createRow(0+titleRows);

            for(int i = 0; i < col_count; i++){
                hssf_w_c = hssf_w_r.createCell((short)i);
                hssf_w_c.setCellType(HSSFCell.CELL_TYPE_STRING);
                HSSFRichTextString hssfString = new HSSFRichTextString(head.get(i));
                hssf_w_c.setCellValue(hssfString);

//                hssf_w_s.autoSizeColumn((short)i);
            }
            //第二行开始写入数据
            hssf_w_s.setColumnWidth(0,5000);
            hssf_w_s.setColumnWidth(1,5000);
            hssf_w_s.setColumnWidth(2,5000);
            hssf_w_s.setColumnWidth(3,16000);
            hssf_w_s.setColumnWidth(4,5000);
            hssf_w_s.setColumnWidth(5,5000);

            //遍历表格的每一行,依次写入数据
            for(int i = 1; i <= row_count; i++){
                hssf_w_r = hssf_w_s.createRow(i+titleRows);
                PersonalProElement element = list.get(i-1);
                //大家根据自己传过来的集合取出对象来get出属性填充每一行数据
                setStringStyle(element.getProject());
                setStringStyle(element.getProjectStage();   
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

        return workbook;
    }

    private void setStringStyle(String value) {
        hssf_w_c = hssf_w_r.createCell((short)j);
        j++;
        hssf_w_c.setCellType(HSSFCell.CELL_TYPE_STRING);
        if(value==null) {
            value="";
        }
        HSSFRichTextString hssfString = new HSSFRichTextString(value);
        hssf_w_c.setCellValue(hssfString);
    }

同时，还要写三个操作类
第一个操作类：

public class ExcelWorkbook {
    private static final String FONT_NAME = "Arial";

    private Map<CellStyle, HSSFCellStyle> pregeneratedStyles;

    private HSSFWorkbook workbook;
    private HSSFWorkbook workbook1;

    public ExcelWorkbook() {
        init();
    }

    private void init() {
        workbook = new HSSFWorkbook();

        pregenerateStyles(workbook);

    }
    private void pregenerateStyles(HSSFWorkbook workbook) {
        pregeneratedStyles = new HashMap<CellStyle, HSSFCellStyle>();

        CellStyle[] styleses = CellStyle.values();

        HSSFFont font = workbook.createFont();
        font.setFontName(FONT_NAME);

        for (CellStyle stylese : styleses) {
            HSSFCellStyle cellStyle = workbook.createCellStyle();
            cellStyle.setFont(font);

            stylese.apply(workbook, cellStyle);

            pregeneratedStyles.put(stylese, cellStyle);
        }
    }

    public HSSFCellStyle getCellStyle(CellStyle forCellStyle) {
        return pregeneratedStyles.get(forCellStyle);
    }

    public HSSFSheet createSheet(String sheetName) {
        return workbook.createSheet(sheetName);
    }
    public HSSFSheet createSheet1(String sheetName) {
        return workbook.createSheet(sheetName);
    }

    public int addPicture(byte[] image, int imageType) {
        return workbook.addPicture(image, imageType);
    }

    public void write(ByteArrayOutputStream output) throws IOException {
        workbook.write(output);
    }
}

第二个操作类：

public class PoiUtil
{
    public static byte[] getWorkbookAsBytes(ExcelWorkbook workbook) throws IOException
    {
        ByteArrayOutputStream output = new ByteArrayOutputStream();
        workbook.write(output);

        return output.toByteArray();
    }

    public static int getImageType(String type)
    {
        if (type.equalsIgnoreCase("png"))
        {
            return HSSFWorkbook.PICTURE_TYPE_PNG;
        }
        else
        {
            return HSSFWorkbook.PICTURE_TYPE_JPEG;
        }
    }
}

第三个操作类：

public class Excelbookshell {
    private static String Excelbook ="";

    public static String getExcelbook() {
        return Excelbook;
    }

    public static void setExcelbook(String excelbook) {
        Excelbook = excelbook;
    }

}

参考：wicket框架下如何将表格数据导出Excel