Apache Poi - 在Excel表格中插入行

I have this Excel file:

我有这个Excel文件：

I want to simulate with Apache POI, the excel operations "Insert Row" for the table. Table style (alternating color rows) should also be maintained.

我想用Apache POI模拟表格的excel操作“Insert Row”。还应保持表格样式（交替颜色行）。

With:

附：

sheet.shiftRows(10, rowCount, size);
sheet.createRow(1);

The style of the table is not maintained, because the row is outside the table.

不维护表的样式，因为行在表外。

How can I maintain the style?

我该如何保持风格？

1 个解决方案

#1

I solved the problem by rewriting a new excel file and including all the rows in a new table.

我通过重写一个新的excel文件并在新表中包含所有行来解决了这个问题。