iis域名导出excel

# 导入IIS模块
Import-Module WebAdministration

# 获取所有网站信息
$sites = Get-ChildItem IIS:\Sites

# 创建Excel文件
$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Add()
$worksheet = $workbook.Worksheets.Item(1)

# 添加表头
$worksheet.Cells.Item(1, 1).Value2 = "网站名称"
$worksheet.Cells.Item(1, 2).Value2 = "物理路径"
$worksheet.Cells.Item(1, 3).Value2 = "绑定IP"
$worksheet.Cells.Item(1, 4).Value2 = "绑定端口"

# 填充数据
$row = 2
foreach ($site in $sites) {
    $bindings = $site.Bindings.Collection
    foreach ($binding in $bindings) {
        $worksheet.Cells.Item($row, 1).Value2 = $site.Name
        $worksheet.Cells.Item($row, 2).Value2 = $site.PhysicalPath
        $worksheet.Cells.Item($row, 3).Value2 = $binding.BindingInformation.Split(':')[0]
        $worksheet.Cells.Item($row, 4).Value2 = $binding.BindingInformation.Split(':')[1]
        $row++
    }
}

# 保存Excel文件
$workbook.SaveAs("C:\Path\To\Save\IIS_Sites_Config.xlsx")
$excel.Quit()