$In_dtInOak = [System.Data.DataTable]::new();
# Add Column Name
$xlApp = New-Object -ComObject Excel.Application;
$xlApp.visible = $true;
$xlBook = $xlApp.Workbooks.Open("C:\Users\XXX.xlsx");
$xlSheet = $xlBook.Worksheets.Item(1);
$cMax = $xlSheet.UsedRange.Columns.Count;
for($cTemp = 1;$cTemp -le $cMax;$cTemp++){
$ret = $In_dtInOak.Columns.Add($xlSheet.Cells.Item(1,$cTemp).Value2);
}
# Add Row
$rMax = $xlSheet.UsedRange.Rows.Count;
for($rTemp = 2;$rTemp -le $rMax;$rTemp++){
#$arr = @($xlSheet.Cells.Item($rTemp,1).Value2,$xlSheet.Cells.Item($rTemp,2).Value2,$xlSheet.Cells.Item($rTemp,3).Value2);
#$ret = $In_dtInOak.Rows.Add($arr);
$arr = @();
for($cTemp = 1;$cTemp -le $cMax;$cTemp++){
$arr += $xlSheet.Cells.Item($rTemp,$cTemp).Value2;
}
$ret = $In_dtInOak.Rows.Add($arr);
}
$xlSheet = $null;
$xlBook.Close($false);
$xlBook = $null;
$xlApp.Quit();
$xlApp = $null;
[System.GC]::Collect();