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:
- Picking up the changes from SharePoint (3 excel files).
- 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.
- 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,