在Apache poi生成的excel中更改作者

Question

我需要在java中更改apache poi生成的excel的作者姓名。目前apache生成的所有内容的作者名称都是"Apache POI"，我需要更改它。有人能在这方面帮我吗？

在进阶阶段谢谢。Generated by Apache poi

Answer 1

HSSFWorkbook是一个带有SummaryInformation的POIDocument。

XSSFWorkbook是一个带有POIXMLProperties - POIXMLProperties.CoreProperties的POIXMLDocument。

为XSSF和HSSF设置作者(也称为创建者)的代码

import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

class CreateExcelAuthor {

 public static void main(String[] args) throws Exception {

  String author = "Axel Richter";

  Workbook workbook = new XSSFWorkbook(); 
  //Workbook workbook = new HSSFWorkbook();

  workbook.createSheet(); 

  if (workbook instanceof XSSFWorkbook) {
   ((XSSFWorkbook)workbook).getProperties().getCoreProperties().setCreator(author); 
  } else if (workbook instanceof HSSFWorkbook) {
   ((HSSFWorkbook)workbook).createInformationProperties();
   ((HSSFWorkbook)workbook).getSummaryInformation().setAuthor(author);
  }

  String fileName = (workbook instanceof XSSFWorkbook)?"Excel.xlsx":"Excel.xls";
  try (FileOutputStream out = new FileOutputStream(fileName) ) {
   workbook.write(out);
  }
  workbook.close();

 }
}