Apache POI で シートのならび順を設定したい場合、Workbook.setSheetOrder
を利用します。
例: XXX→YYY→ZZZの順番でシートをならべる
Sheet xxx = workbook.createSheet("XXX");
Sheet yyy = workbook.createSheet("YYY");
Sheet zzz = workbook.createSheet("ZZZ");
workbook.setSheetOrder(xxx.getSheetName(), 0);
workbook.setSheetOrder(yyy.getSheetName(), 1);
workbook.setSheetOrder(zzz.getSheetName(), 2);
環境情報
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>5.3.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>5.3.0</version>
</dependency>