powershell XML数据保存为HTML

最新推荐文章于 2023-01-17 15:14:34 发布

符号会飞

最新推荐文章于 2023-01-17 15:14:34 发布

阅读量230

点赞数

分类专栏： powershell 文章标签： powershell xml

本文链接：https://blog.csdn.net/winterye12/article/details/107332998

版权

powershell 专栏收录该内容

13 篇文章 2 订阅

订阅专栏

1.设置html头和尾

beginning内包含表格表头

$beginning = {
	'<html>
	<head>
					
	<meta charset="utf-8" />
	<title>Report</title>
	<STYLE type="text/css">
		h1 {font-family:SegoeUI, sans-serif; font-size:30}
		th {font-family:SegoeUI, sans-serif; font-size:20}
		td {font-family:Consolas, sans-serif; font-size:16}
				 
	</STYLE>
				 
	</head>
					
	<h1>Report</h1>
	<table border="1">
	<tr><th>No</th><th>name</th><th>result</th><th>filePath</th><th>time</th><th>mark</th></tr>
'
}

$end = {
'
	</table>
	</html>
	</body>	
'				 				 
}

2.设置内容

$process = {
	
    $number=$_.number				
	$name=$_.name
	$result=$_.result
	$filePath=$_.filePath
	$time=$_.time
	$mark=$_.mark

	'<tr>'
    '<td>{0}</td>' -f $number
	'<td>{0}</td>' -f $name
	'<td>{0}</td>' -f $result
	'<td> <a href="{0}"> {0}</a></td>' -f $filePath
	'<td>{0}</td>' -f $time
	'<td>{0}</td>' -f $mark
	'</tr>'
					
}

3.导入数据

$xmldata =[XML](Get-Content $xmlPath -Encoding UTF8)
$points=$xmldata.case.point



$points |ForEach-Object -Begin $beginning -Process $process -End $end |Out-File -FilePath $htmlPathData -Encoding utf8