Pivot Creation

Posted by: srinivas.varma on 21 July 2019, 5:11 pm EST

  • Posted 21 July 2019, 5:11 pm EST

    Hi,
    i am not able to find a solution for creating Pivot Table when range (ex : A1 :F16) is dynamic , so how to give range when its dynamic as like apache POI i.e
    AreaReference areaRefer = new AreaReference("$A$2:$" + ColumnName + "$3", SpreadsheetVersion.EXCEL2007);


    But Grapecity we have to give range like below :
    IPivotCache pivotcache = workbook.getPivotCaches().create(worksheet.getRange("A1:F16"));
    IPivotTable pivottable = worksheet.getPivotTables().add(pivotcache, worksheet.getRange("H7"), "pivottable1");
  • Replied 21 July 2019, 5:12 pm EST

    	AreaReference areaRefer = new AreaReference("$A$2:$" + ColumnName + "$3", SpreadsheetVersion.EXCEL2007);


    using above it will automatically consider all rows in give columns range ..
    so in same manner will grapecity works??
  • Replied 22 July 2019, 5:22 pm EST

    Hello,

    We could observe your issue and we have added it as an enhancement request and we will update you as soon as we hear any update from our concerned team.

    Tracking id for your issue is DOCXLS-1268.

    Thanks,
    Reeva
  • Replied 24 July 2019, 6:08 pm EST

    Hello,

    Our developers looked into your issue and according to them GcExcel totally follow VSTO api style, so it does not have concept like "AreaReference".

    We regret the inconvenience.

    Thanks,
    Reeva
  • Replied 6 August 2019, 3:55 pm EST

    can you suggest me a workaround for solving this issue..
  • Marked as Answer

    Replied 7 August 2019, 8:15 pm EST

    Hello,

    Unfortunately, we don't have any workaround for the same else we would have shared it with you earlier.

    We regret the inconvenience.

    Thanks,
    Reeva
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels