Java Excel API

最新推荐文章于 2021-02-23 23:53:06 发布

seave

最新推荐文章于 2021-02-23 23:53:06 发布

阅读量805

点赞数

分类专栏： Java 文章标签： excel java string null api

本文链接：https://blog.csdn.net/seave/article/details/496334

版权

Java 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();

    //创建一个style
    HSSFCellStyle cs = wb.createCellStyle();

    //垂直居中
    cs.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
    //水平居中
    cs.setAlignment(HSSFCellStyle.ALIGN_CENTER);

    String sheetname=new String((new String()).getBytes("GBK"),"UTF-8");
    wb.setSheetName(0, "查询",HSSFWorkbook.ENCODING_UTF_16);

    int index=0,amount=1;

HSSFRow row = s.createRow(index);
HSSFCell cell = null;

    if(headDes != null)
    {
     row = s.createRow(index++);
        for (int i=0;i<headDes.length;i++)
     {
                cell = row.createCell((short)i);

      cell.setEncoding(HSSFCell.ENCODING_UTF_16);
      cell.setCellValue(headDes[i]);
     }
    }

    //合并单元格
    s.addMergedRegion(new Region(0,(short)0,1,(short)0));
    s.addMergedRegion(new Region(0,(short)1,1,(short)1));
    s.addMergedRegion(new Region(0,(short)2,0,(short)6));
    s.addMergedRegion(new Region(0,(short)7,0,(short)10));
    s.addMergedRegion(new Region(0,(short)11,0,(short)13));

wb.write(writer);
writer.close();

参考地址:http://dev2dev.bea.com.cn/bbs/thread.jspa?forumID=126&threadID=21476&tstart=0