Pipeworks | Making Tables With Out-HTML

Making Tables With Out-HTML

1 of 3

The example below renders a quick 'Person' object with Out-HTML.

New-Object PSObject |            
    Add-Member NoteProperty FirstName John -PassThru |            
    Add-Member NoteProperty LastName Smith -PassThru |            
    Add-Member NoteProperty Addresss '1234 Nowhere St' -PassThru |            
    Out-HTML

FirstName	LastName	Addresss
John	Smith	1234 Nowhere St

2 of 3

You can also run existing commands in PowerShell and use the Select-Object command to pick and choose properties

Get-Date  |            
    Select-Object DayOfWeek, Month, Day, Year |            
    Out-HTML

DayOfWeek	Month	Day	Year
Tuesday	12	5	2023

3 of 3

Select-Object can also caculate properties on the fly:

Get-Command -Module Pipeworks |             
    Select-Object Name,            
    @{            
        Name='Verb';            
        Expression={            
            ($_.Name -split "-")[0]            
        }            
    }, @{            
        Name='Noun';            
        Expression={            
            ($_.Name -split "-")[1]            
        }            
    } |            
    Out-Html

Name	Verb	Noun
Publish-WebService	Publish	WebService
Remove-Service	Remove	Service

Name	Verb	Noun
Add-AzureLocalResource	Add	AzureLocalResource
Add-AzureRole	Add	AzureRole
Add-AzureSetting	Add	AzureSetting
Add-AzureStartupTask	Add	AzureStartupTask
Add-AzureWebSite	Add	AzureWebSite
Add-Deployment	Add	Deployment
Add-Interaction	Add	Interaction
Add-SecureSetting	Add	SecureSetting
Add-SqlTable	Add	SqlTable
Close-Port	Close	Port
Compress-Data	Compress	Data
Confirm-Person	Confirm	Person
ConvertFrom-InlinePowerShell	ConvertFrom	InlinePowerShell
ConvertFrom-Markdown	ConvertFrom	Markdown
ConvertTo-DataTable	ConvertTo	DataTable
ConvertTo-ModuleService	ConvertTo	ModuleService
ConvertTo-ServiceUrl	ConvertTo	ServiceUrl
Expand-Data	Expand	Data
Expand-Zip	Expand	Zip
Export-Blob	Export	Blob
Export-DataTable	Export	DataTable
Export-PSData	Export	PSData
Find-Factual	Find	Factual
Get-Blob	Get	Blob
Get-Bootstrapped	Get	Bootstrapped
Get-Deployment	Get	Deployment
Get-Email	Get	Email
Get-FTP	Get	FTP
Get-FunctionFromScript	Get	FunctionFromScript
Get-Hash	Get	Hash
Get-Paid	Get	Paid
Get-Person	Get	Person
Get-PhoneCall	Get	PhoneCall
Get-PipeworksManifest	Get	PipeworksManifest
Get-SecureSetting	Get	SecureSetting
Get-SQLTable	Get	SQLTable
Get-TextMessage	Get	TextMessage
Get-Translation	Get	Translation
Get-Walkthru	Get	Walkthru
Get-Web	Get	Web
Get-WebConfigurationSetting	Get	WebConfigurationSetting
Get-WebInput	Get	WebInput
Get-WebTemplateEditableRegion	Get	WebTemplateEditableRegion
Import-Blob	Import	Blob
Import-DataTable	Import	DataTable
Import-Deployment	Import	Deployment
Import-PSData	Import	PSData
Import-StoredProcedure	Import	StoredProcedure
Install-PSNode	Install	PSNode
Invoke-Office365	Invoke	Office365
Invoke-Parallel	Invoke	Parallel
Invoke-WebCommand	Invoke	WebCommand
Join-Website	Join	Website
New-AzureServiceDefinition	New	AzureServiceDefinition
New-DataTable	New	DataTable
New-PipeworksManifest	New	PipeworksManifest
New-RDPFile	New	RDPFile
New-Region	New	Region
New-RssItem	New	RssItem
New-SQLDatabase	New	SQLDatabase
New-WebPage	New	WebPage
Open-Port	Open	Port
Out-AzureService	Out	AzureService
Out-Daemon	Out	Daemon
Out-HTML	Out	HTML
Out-RssFeed	Out	RssFeed
Out-Zip	Out	Zip
Publish-AzureService	Publish	AzureService
Publish-Deployment	Publish	Deployment
Publish-Website	Publish	Website
Push-Deployment	Push	Deployment
Push-FTP	Push	FTP
Remove-Blob	Remove	Blob
Remove-Daemon	Remove	Daemon
Remove-Deployment	Remove	Deployment
Remove-SecureSetting	Remove	SecureSetting
Remove-SQL	Remove	SQL
Request-CommandInput	Request	CommandInput
Resolve-Location	Resolve	Location
Search-Engine	Search	Engine
Search-WolframAlpha	Search	WolframAlpha
Select-Datatable	Select	Datatable
Select-SQL	Select	SQL
Select-Wmi	Select	Wmi
Send-Email	Send	Email
Send-PhoneCall	Send	PhoneCall
Send-TextMessage	Send	TextMessage
Set-AWSConnectionInfo	Set	AWSConnectionInfo
Show-WebObject	Show	WebObject
Start-At	Start	At
Start-MapReduce	Start	MapReduce
Start-PSNode	Start	PSNode
Switch-TestDeployment	Switch	TestDeployment
Test-W3C	Test	W3C
Update-DataTable	Update	DataTable
Update-Sql	Update	Sql
Update-Wmi	Update	Wmi
Use-Less	Use	Less
Use-Schematic	Use	Schematic
Wait-Deployment	Wait	Deployment
Watch-Daemon	Watch	Daemon
Write-Ajax	Write	Ajax
Write-AspDotNetScriptPage	Write	AspDotNetScriptPage
Write-CRUD	Write	CRUD
Write-CSS	Write	CSS
Write-Host	Write	Host
Write-Link	Write	Link
Write-PowerShellHashtable	Write	PowerShellHashtable
Write-ScriptHTML	Write	ScriptHTML
Write-WalkthruHTML	Write	WalkthruHTML