Insert Rows

Aspose.Cells Product Family
1

I tried to insertRows into xls template which has autofilter set, got the following exception...

java.lang.ArrayIndexOutOfBoundsException: 21
at com.aspose.cells.bx.c(Unknown Source)
at com.aspose.cells.bx.d(Unknown Source)
at com.aspose.cells.cd.a(Unknown Source)
at com.aspose.cells.I.a(Unknown Source)
at com.aspose.cells.Cells.b(Unknown Source)
at com.aspose.cells.Cells.l(Unknown Source)
at com.aspose.cells.Cells.insertRows(Unknown Source)

Oh, the issue is with the subtotal column in that xls template. How to remove the subtotal while inserting rows and to recalculate subtotal at the end using java.

2

Hi,

We are not very clear about your issue, but, could you try the attached version. If the problem still persists, please post your template file with your sample code to reproduce the issue, we will check it soon.

Thank you.

3

ya it's working with the attached version. Thanks for reply.