Welcome Forums General PowerShell Q&A Merge multiple XLSX files into one

Viewing 0 reply threads
  • Author
    • #172069
      Topics: 1
      Replies: 0
      Points: 1
      Rank: Member

      Hi all,

      I’m trying to merge a bunch of XLSX files into one (all have the same number of columns and column headers). All files have columns that are filtered differently, so i only want to copy the filtered data. Is this possible? Code i have so far:

      $ExcelObject=New-Object -ComObject excel.application
      $ExcelFiles=Get-ChildItem -Path C:\Users\filePath...
      foreach($ExcelFile in $ExcelFiles){
Viewing 0 reply threads
  • The topic ‘Merge multiple XLSX files into one’ is closed to new replies.