# Load the Microsoft.Office.Interop.Excel assembly
Add-Type -AssemblyName Microsoft.Office.Interop.Excel
# ファイルを開く
$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open("C:\\path\\to\\file.xlsx")
# シートを取得
$worksheet = $workbook.Sheets.Item(1)
# セルを取得
$range = $worksheet.Range("A1:C3")
# セルの罫線を取得
foreach ($cell in $range.Cells) {
Write-Host "Left border: $($cell.Borders.Item(7).LineStyle)"
Write-Host "Right border: $($cell.Borders.Item(10).LineStyle)"
Write-Host "Top border: $($cell.Borders.Item(8).LineStyle)"
Write-Host "Bottom border: $($cell.Borders.Item(9).LineStyle)"
Write-Host "-------------------------------"
}
# Clean up
$workbook.Close()
$excel.Quit()
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | Out-Null