如何显示(或防止隐藏)从PowerShell创建的Excel工作表

# 安装必要的模块
Install-Module -Name ImportExcel

# 创建一个新的 Excel 文件并添加一个工作表
New-Excel -Path "C:\path\to\your\file.xlsx" -WorkSheetName "Sheet1"

# 显示所有工作表
$excel = [System.IO.File]::OpenRead("C:\path\to\your\file.xlsx")
$workbook = [System.IO.Packaging.Package]::Open($excel)
$workbook.WorkbookPart.WorksheetParts | ForEach-Object {
    $worksheet = $_.Worksheet
    $worksheet.Name
}
$excel.Close()

# 加载 Excel 文件
$excel = New-Object -ComObject Excel.Application
$excel.Visible = $false
$workbook = $excel.Workbooks.Open("C:\path\to\your\file.xlsx")

# 隐藏指定的工作表
$worksheet = $workbook.Worksheets["Sheet1"]
$worksheet.Visible = $xlVeryHidden

# 保存并关闭文件
$workbook.Save()
$workbook.Close($false)
$excel.Quit()

# 加载 Excel 文件
$excel = New-Object -ComObject Excel.Application
$excel.Visible = $false
$workbook = $excel.Workbooks.Open("C:\path\to\your\file.xlsx")

# 显示隐藏的工作表
$worksheet = $workbook.Worksheets["Sheet1"]
$worksheet.Visible = $xlSheetVisible

# 保存并关闭文件
$workbook.Save()
$workbook.Close($false)
$excel.Quit()

$worksheet = $workbook.Worksheets.Add()
$worksheet.Visible = $xlSheetVisible