更改作者在 Excel 中生成 由 阿帕奇 poi 生成

Question

我需要更改由爪哇哇目前，所有由阿帕奇生成的作者姓名是“阿帕奇POI”，我需要更改它。任何人都可以帮我吗？

Answer 1

HSSFWorkbook是一个具有摘要信息的POI文档。XSSFWorkbook是一个具有POIXML属性的文件 - POIXML属性。用于为 和 设置作者（又名创建者）的代码：XSSFHSSFimport 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(); }}