Exception when adding large pivot table range

Aspose.Cells Product Family
1

I’ve been receiving the following error when I try to create a pivot table from a large data set.

java.lang.IllegalArgumentException: Unkown Area: =Data1!A1:BI116010

which happens right after this block
PivotTables pivotTables = sheet.getPivotTables();
int index = pivotTables.add("=Data1!A1:" + lastCellName, “A1”, “PivotTable2”);

Funny thing is that I can create the pivot table just fine when I have fewer rows. I just created one successfully that has 59514 rows. I’m using version 2.5.4.17 of the jar which I think may be the latest one. Can you help?

2

Hi,


Could you attach your sample template Excel file here, we will check your issue soon.

Thank you.
3

Hi,

If the workbook is a newly created one or loaded from xls files, please set its file format to excel2007 such as XLSX before you use formulas whose row/column reference exceeds xls file’s row/column limit.

4

Saving the file beforehand and setting the filetype to xlsx worked. Thank you.

5

Hi,

It’s good to know your problem has been sorted out. If you have any other question, please feel free to post here.