Refresh Pivot Table

Refresh Pivot Table

Posted by: kmalyi on 4 March 2021, 7:54 am EST

• 

  kmalyi

  • Post Options:
  • Link
    Copy

  Posted 4 March 2021, 7:54 am EST

  Hello, help me with pivot tables please. So i:

  1. Added source data into Worksheet
  2. Added Pivot table
  3. Changed some values in source range
  4. Try to refresh pivot table but nothing happens.

  I used this documentation https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Pivot.PivotTable~refresh.html
  
  Also looks like ‘remove’ method doesn’t works as well.

• 

  kmalyi

  • Post Options:
  • Link
    Copy

  Posted 4 March 2021, 11:34 am EST

  Also please tell me working way to delete pivot table from WOrksheet

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 5 March 2021, 7:00 am EST

  Hi,

  Refreshing the data source is currently not supported with SJS. It is currently in our backlog and will be available in our upcoming stable release. Further, we have asked regarding the refresh method functionality to the concerned team we will update you once we have any information. The internal ID for this will be SJS-7861.

  Also please tell me working way to delete pivot table from WOrksheet

  You may use the remove method. Please refer to the following code snippet and attached sample that demonstrates the same.

  
  sheet1.pivotTables.remove("PivotTable");
  
  

  sample: https://codesandbox.io/s/spread-js-starter-forked-qeigq

  remove method: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Pivot.PivotTable~remove.html

  Regards
  
  Avinash

• 

  kmalyi

  • Post Options:
  • Link
    Copy

  Posted 9 March 2021, 8:05 am EST

  avinash.pathak, thank you for ‘remove’ function reference, hope to hear from you about refresh functionality