java - Java插入表在开始excel apache poi

Question

我想知道是否可以使用 java poi apache 插入工作表并将其放在工作簿的开头

标签： javaexcelapache-poi

Answer 1

在当前版本中apache poi 4.1.0 Workbook.setSheetOrder提供您想要的。

完整示例：

import org.apache.poi.ss.usermodel.*;

import java.io.FileInputStream;
import java.io.FileOutputStream;

public class ExcelInsertSheet {

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

  String fileName = "Excel.xlsx"; 
  String filePath = "./"; 

  Workbook workbook = WorkbookFactory.create(new FileInputStream(filePath + fileName));

  Sheet sheet = workbook.createSheet("New Sheet");

  workbook.setSheetOrder("New Sheet", 0);
  workbook.setSelectedTab(0);
  workbook.setActiveSheet(0);

  FileOutputStream out = new FileOutputStream(filePath + "Changed" + fileName);
  workbook.write(out);
  out.close();
  workbook.close();
 }

}