merging excel documents

PowerShell Help
1

Is there a powershell way to merge multiple excel documents?

I’m looking for a simple merging of multiple workbooks into one and on one tab.

So workbook 1

line 1 ABC

line 2 DEF

line 3 GHI

  • add workbook 2

line 1 JKL

line 2 MNO

line 3 PQR

–>

For the second workbook, line one should start at the next available (empty) line, so we would get:

New workbook:

line 1 ABC

line 2 DEF

line 3 GHI

line 4 JKL

line 5 MNO

line 6 PQR

2

With some coding and using ImportExcel module, this will be possible.