excel shell合成_Excel 合并至一个表

Function Merger-Excel{

param(

[parameter(mandatory=$true)][string]$SrcFolder,

[parameter(mandatory=$true)][string]$DstPath,

[parameter(mandatory=$true)][int]$SrcSheetIndex,

[parameter(mandatory=$true)][int]$DstcSheetIndex,

[parameter(mandatory=$true)][string]$StartColumn,

[parameter(mandatory=$true)][string]$EndColumn,

[parameter(mandatory=$true)][string]$ColumnIndex,

[parameter(mandatory=$true)][int]$StartRow

)

$files=Get-ChildItem -Path $SrcFolder -Filter *.xlsx

$xl=New-Object -ComObject excel.application

$xl.visible=$false

$xl.AlertBeforeOverwriting=$false

$xl.DisplayAlerts=$false

$wb_dst=$xl.Workbooks.Open($DstPath)

$ws_dst=$wb_dst.Sheets.Item($DstcSheetIndex)

for($i=0;$i -lt $files.Count;$i++){