POI生成的excel的文件属性

最新推荐文章于 2024-02-27 13:14:30 发布

hellcw

最新推荐文章于 2024-02-27 13:14:30 发布

阅读量1.3k

点赞数

分类专栏： javaweb 文章标签： excel poi

本文链接：https://blog.csdn.net/hellcw/article/details/78066839

版权

javaweb 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

import org.apache.poi.hpsf.CustomProperties;
import org.apache.poi.hpsf.DocumentSummaryInformation;
import org.apache.poi.hpsf.SummaryInformation;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import java.io.FileOutputStream;
import java.io.OutputStream;

public class Test {

public static void main(String args[]) throws Exception {
    OutputStream out = null;
    //为文件添加用户名，ip，时间等信息
    try {
        HSSFWorkbook workbook = new HSSFWorkbook();
        workbook.createInformationProperties();
        SummaryInformation suminfoInformation = workbook.getSummaryInformation();
        DocumentSummaryInformation info = workbook.getDocumentSummaryInformation();
        //添加备注信息
        suminfoInformation.setComments("beizhu");
        suminfoInformation.setAuthor("zhangsan");
        //添加自定义属性
        CustomProperties customProperties = new CustomProperties();
        customProperties.put("IP","172.193.444");
        info.setCustomProperties(customProperties);
        out = new FileOutputStream("F://2.xls");
        workbook.write(out);
    } catch (Exception e) {
        e.printStackTrace();
    }finally{
        if (out!=null) {
            out.close();
        }
    }
}

}