APACHE POI创建损坏的文件-无论我做了什么更改

Question

我正在尝试创建包含某些值的表的Excel文件。问题是，无论我做什么，Java都会创建损坏的Excel文件（.xlsx、.xlsm）。

更改现有表的列文件的名称已损坏，如果不进行修复，则无法打开它。名称已更改，但由于某些原因，必须修复该文件。创建新表或为现有表创建新列似乎会损坏文件，但我不知道为什么。

这是我的全部代码：

package pl.TiHerbatka.Ti.ExcelWriteReadTi.Main;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFTable;
import org.apache.poi.xssf.usermodel.XSSFTableColumn;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class Main {

    public static void main(String[] args) throws InvalidFormatException, IOException {
        File deleteOldFile = new File("E:\\Users\\PLACEHOLDER\\ExcelTestowy#2 — kopia.xlsx");
        if (deleteOldFile.exists()) {
            deleteOldFile.delete();
            System.out.println("Deleted!");
        }
        File fT = new File("E:\\Users\\PLACEHOLDER\\ExcelTestowy#2.xlsx");
        FileInputStream fTI = new FileInputStream(fT);
        if (deleteOldFile.exists()) {
            System.out.println("File exists!\n--------------");
        } else {
            System.out.println("File doesn't existst");
        }
        /////////////////////////////////

        XSSFWorkbook wb = new XSSFWorkbook(fTI);
        XSSFSheet sh = wb.getSheetAt(0);

        XSSFTable tb = sh.getTables().get(0);
        tb.setDisplayName("ExampleTableName"); //Works
        tb.getColumns().get(0).setName("ExampleColumnName"); // Doesn't work
        tb.createColumn("ExampleAdditionalColumnINeed"); //Doesn't work too.


        File fTO = new File("E:\\Users\\PLACEHOLDER\\ExcelTestowy#2 — kopia.xlsx");
        FileOutputStream fTOO = new FileOutputStream(fTO);
        wb.write(fTOO);


        fTOO.flush();
        fTOO.close();
        wb.close();
    }

}

附言：我是Java初学者——我在Java上有三年的Rest时间。我为我的语言道歉。

Answer 1

Apache POI无法创建。xlsm-与包含宏的excel文件一样。

请参阅：使用ApachePOI写入xlsm（Excel2007）

Answer 2

在更改了XSSFTable中的表标题后，我们还需要更改工作表中的单元格值，这是表标题的表示。即使在当前apache poi 4.1.2中，poi也无法保持两个部分的更新。

以下内容适用于使用ApachePOI4.1.2的我：

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFTable;

public class ExcelRenameTable {

    public static void main(String[] args) throws InvalidFormatException, IOException {

        File fT = new File("./ExcelTestowy.xlsm");
        FileInputStream fTI = new FileInputStream(fT);

        XSSFWorkbook wb = new XSSFWorkbook(fTI);
        XSSFSheet sh = wb.getSheetAt(0);

        XSSFTable tb = sh.getTables().get(0);
        tb.setDisplayName("ExampleTableName");

        tb.getColumns().get(0).setName("ExampleColumnName");
        //we also need changing the cell value in the sheet which is the representation of the table header
        int tbStartRow = tb.getStartRowIndex(); // start row of table = header row
        int tbStartCol = tb.getStartColIndex(); // start col of table = first col
        sh.getRow(tbStartRow).getCell(tbStartCol).setCellValue("ExampleColumnName");

        tb.createColumn("ExampleAdditionalColumnINeed");
        //we also need changing the cell value in the sheet which is the representation of the table header
        int tbEndCol = tb.getEndColIndex(); // end col of table = new created column
        XSSFCell cell = sh.getRow(tbStartRow).getCell(tbEndCol);
        //maybe we need creating the cell first since the column is new
        if (cell == null) cell = sh.getRow(tbStartRow).createCell(tbEndCol);
        cell.setCellValue("ExampleAdditionalColumnINeed");

        File fTO = new File("./ExcelTestowy — kopia.xlsm");
        FileOutputStream fTOO = new FileOutputStream(fTO);
        wb.write(fTOO);

        fTOO.close();
        wb.close();
    }

}