I have a requirement to merge specific 'export' tabs (worksheets) that are contained within folders that are within a SharePoint document library. The folders are 'top-level' items within list A. Within each folder are subfolders which contain list items that are of type excel. I would like to use powershell to iterate over list A and it's subfolders and grab the worksheet (tab) named 'export' merging them into a new excel workbook within List A (at the top level).
I can easily get the list of all folders/subfolders and list items (of type excel). What I can't figure out is how to get an object instance (for lack of a better term) to each excel workbook (the list items). To powershell, each item is just an item and not of type excel. Can someone advise on how I might do this? Thanks.