Export Oracle Query Output To Html

[Reflection.Assembly]::LoadFile('E:\oracle\product\11.2.0\ODP.NET\bin\2.x\Oracle.DataAccess.dll') $constr = 'User Id=system;Password=pass;Data Source=API' $conn= New-Object Oracle

Solution 1:

For exporting objects to HTML instead of CSV use ConvertTo-Html instead of Export-Csv and write the output to a file:

$style = @"
<style type='text/css'>
th {
  font-weight: bold;
  color: red;
}
</style>
"@

$someArray | ConvertTo-Html -Head $style | Out-File 'C:\temp\someFile.html'