Automatically Refresh Pivot Tables in an Excel File

Hi KNIME Community,

I’m working on a workflow where I need to process an Excel file (.xlsm). The data in this file is dynamically updated based on changes made by other teams who upload new/modified files into the SharePoint folder (yellow highlighted files ‘.xlsm’).

My process involves:

  1. Picking up the changes from SharePoint (3 excel files).
  2. Updating the corresponding sheets in the Excel file with the latest data from the sharepoint folder. ** I have pivots in my Excel file wherein the data from the pivot is coming from the files in the sharepoint folder.
  3. Automatically refreshing the pivot tables in these sheets after the dumping the updated files in the sharepoint folder.

I’m not sure if KNIME can directly trigger a pivot table refresh. Has anyone implemented something similar or knows if it’s possible to refresh pivot tables within an Excel file automatically as part of a KNIME workflow? If so, what nodes or additional tools did you use?

Any guidance or suggestions would be greatly appreciated!

Thanks in advance,

@Heldyyyyy question is if the pivot tables will get updated if you open the Excel file which you can do at the end of an Excel writer node.

I was able to at least detect pivot tables with Phyton in knime. Maybe it is possible to also update or refresh them. This most likely will require a temporary opening of the files in Excel in the background: