• java生成excel


    package test.poi;
    
    import java.io.File;
    import java.io.FileOutputStream;
    import java.io.OutputStream;
    import java.util.ArrayList;
    import java.util.List;
    import java.util.Map;
    
    import jxl.Workbook;
    import jxl.format.Alignment;
    import jxl.format.Border;
    import jxl.format.BorderLineStyle;
    import jxl.format.Colour;
    import jxl.format.UnderlineStyle;
    import jxl.write.Label;
    import jxl.write.WritableCellFormat;
    import jxl.write.WritableFont;
    import jxl.write.WritableSheet;
    import jxl.write.WritableWorkbook;
    
    public class createExcel {
        public static void main(String[] args) {
            createExcel();
        }
        public static void createExcel() {
            try {
                File file = new File("f://text.xls");
                OutputStream os = new FileOutputStream(file);
                WritableWorkbook wwb = Workbook.createWorkbook(os);
                WritableSheet ws = wwb.createSheet("sheet1", 0);
                //根据月份获取对象集
                List<Map<String,String>> list=new ArrayList<Map<String,String>>();
                //设置单元格格式
                WritableFont wf = new WritableFont(WritableFont.ARIAL, 11,WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE,Colour.WHITE);
                WritableCellFormat cellFormat = new WritableCellFormat(wf);
                cellFormat.setBorder(Border.ALL, BorderLineStyle.THIN,Colour.BLUE_GREY);
                cellFormat.setAlignment(Alignment.CENTRE);
                cellFormat.setBackground(Colour.BLUE);
                //第一行
                Label label = new Label(0, 0, "序号");
                label.setCellFormat(cellFormat);
                ws.addCell(label);
                label = new Label(1, 0, "姓名 ");
                label.setCellFormat(cellFormat);
                ws.addCell(label);
                //合并单元格
                ws.mergeCells(2, 0, 3, 0);
                label = new Label(2, 0, "合并单元格");
                label.setCellFormat(cellFormat);
                ws.addCell(label);        
                
                //第二行
                label = new Label(0, 1, "1");
                ws.addCell(label);
                label = new Label(1, 1, "姓名");
                ws.addCell(label);
                label = new Label(2, 1, "合并1");
                ws.addCell(label);
                label = new Label(3, 1, "合并2");
                ws.addCell(label);
                //第三行
                label = new Label(0, 2, "2");
                ws.addCell(label);
                label = new Label(1, 2, "姓名");
                ws.addCell(label);
                label = new Label(2, 2, "合并1");
                ws.addCell(label);
                label = new Label(3, 2, "合并2");
                ws.addCell(label);
                //添加数据
                wwb.write();
                wwb.close();
                System.out.println("生成信息表(Excel格式)成功");
            } catch (Exception e) {
                System.out.println("生成信息表(Excel格式)时出错:");
                e.printStackTrace();
            }
        }
    }

    操作excel需用到jxl.jar这个jar包。

  • 相关阅读:
    自己动手制作symbian签名
    中移动陈大庆:中国移动JAVA4.1规范和SDK工具
    角色扮演游戏引擎的设计原理
    小团队开发J2ME游戏的阶段划分
    角色扮演游戏中敌人AI(人工智能)的设计方法
    入门:Android 文档的阅读顺序
    2016 MultiUniversity Training Contest 1
    真我
    DBA是我的梦想
    解决VS2010自带的C/C++编译器CL找不到mspdb100.dll的问题
  • 原文地址:https://www.cnblogs.com/xiufengd/p/4874360.html
Copyright © 2020-2023  润新知