使用Get-Content
和ConvertFrom-Json
读取JSON配置文件,以下是示例代码:
json
:
// settings.json
{
"RUN_DATE": null,
"xl": {
"xlWBATWorksheet": -4167,
"xlUp": -4162,
"xlCellTypeVisible": 12,
"xlPasteValuesAndNumberFormats": 12,
"XlFileFormat": {
"xlExcel8": 56
},
"XlCutCopyMode": {
"xlCopy": 1,
"xlCut": 2
},
"xlCalculationAutomatic": -4105,
"xlCalculationManual": -4135
}
}
powershell
:
$CONF = (Get-Content "settings.json") | ConvertFrom-Json
$xl = $CONF.xl
$RUN_DATE = $CONF.RUN_DATE
If($RUN_DATE -eq $null) {
$RUN_DATE = (Get-Date)
} Else {
$RUN_DATE = [datetime]::ParseExact($RUN_DATE, 'yyyyMMdd', $null)
}