Pivot Creation

Pivot Creation

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

• 

  srinivas.varma

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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");
  

• 

  srinivas.varma

  • Post Options:
  • Link
    Copy

  Posted 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??

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  ravi.jasti

  • Post Options:
  • Link
    Copy

  Posted 6 August 2019, 3:55 pm EST

  can you suggest me a workaround for solving this issue…

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 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