使用 SXSSFWorkbook 在进行操作 Excel 的行进行向下移动时会报错...

//创建一个 Excel
Workbook workbook = new SXSSFWorkbook();
// excel 的生成过程: excel --> sheet --> row --> cell
Sheet sheetA = workbook.createSheet("片区 A");
Row rowA = sheetA.createRow(0);
Cell cellAA = rowA.createCell(0);
Cell cellAB = rowA.createCell(2);
cellAA.setCellValue("单元格 cellAA");
cellAB.setCellValue("单元格 cellAB");
//第二行
Row rowB = sheetA.createRow(1);
Cell cellBA = rowB.createCell(1);
cellBA.setCellValue("单元格 cellBA");
//合并
CellRangeAddress cellRangeAddress = new CellRangeAddress(0, 0, 0, 1);
sheetA.addMergedRegion(cellRangeAddress);
//移位
int lastRowNum = sheetA.getLastRowNum();
sheetA.shiftRows(0, lastRowNum, 1);

//测试结果
workbook.write(new FileOutputStream("D:/test.xlsx"));

发生的异常是:

java.lang.RuntimeException: NotImplemented

    at org.apache.poi.xssf.streaming.SXSSFSheet.shiftRows(SXSSFSheet.java:945)
    at com.yh.ss.utils.excel.ExportExcelTest.testSXSSF(ExportExcelTest.java:94)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
    at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
    at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
    at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)

吾辈试着将 SXSSFWorkbook 换成了 HSSFWorkbook 就立即能够正常运行了, Google 了一下貌似是因为 SXSSFWorkbook API 做不到移位操作(然而却没有禁用...), 那么有什么好的建议么? (((o(ﾟ▽ﾟ)o)))