I have 23 csv files. Each file contains two columns. I only want second column to be an output (output can be either csv or xlsx file; Name of the file = Banks\_2008\_2014.some extension). I want to get the second column of the first file and place it into the first column of the output file. 

```
$excel_test = New-Object -ComObject Excel.Application
$excel_test.visible =$true
$excel_test.DisplayAlerts =$true

$excel_test|select-object |format-table -autosize

$excelFiles = Get-ChildItem -Path     C:\SNOWPACK\Samarth\1_Banks\AllPro_Banks_Point1 -Include *.csv -Recurse

Freach ($i in $excelFiles)
{
$excel_test.workbook.worksheet.column.item($i) = $i[1]
}

```

Error: Unable to index into (System.IO).File.Info

**Examples:**

File\_1

```
Column_1 Column_2
  0.1      0.11
  0.2      0.45
  0.35     0.6
  0.25     0.8
  0.33     0.1

```

File\_2

```
Column_1 Column_2
 0.9       0.2   
 0.2       0.11
 0.45      0.4
 0.34      0.6

```

Result should look like this

```
Column_1 Column_2
  0.11     0.2
  0.45     0.11
  0.6      0.4
  0.8      0.6
  0.1

```