PowerShell脚本:将Json数据转换成表格格式输出
# 读取json文件,并将其转换为powershell对象
$result = Get-Content -Path "D:\data.json" | ConvertFrom-Json
# 定义一个函数,将powershell对象转换为表格格式,并指定列宽和对齐方式
function ConvertTo-Table {
param($obj)
$table = $obj | Format-Table -AutoSize -Property @{
label = "labelName"
expression = { $_.keyname }
width = 30
align = "center"
}, @{
label = "labelName"
expression = { $_.keyname }
width = 25
align = "center"
}, @{
label = "labelName"
expression = { $_.keyname }
width = 30
align = "center"
}
return $table
}
# 调用函数,将结果对象转换为表格
$table = ConvertTo-Table -obj $result
$table = $table | Out-String
# 将表格写入一个新的txt文件中,并指定编码格式
Set-Content -Path "D:\table.txt" -Value $table -Encoding UTF8
# 打印完成提示
Write-Output "结果已写入table.txt文件"```
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36