How to add formatting to header column of csv file using powershell

Question

I am able to run a stored procedure and export it to csv using the following code:

function TestSQLStoredPrc()
{
$connString = "Data Source=xxxxxx,1433;Initial Catalog=TestDB;User Id=TestUser; Password=YYYYYYY;"
$Reference = Read-Host "Enter Name";
$QueryText = "exec dbo.GetUsersCountByName 'Test'"; 
$SqlConnection = new-object System.Data.SqlClient.SqlConnection;
$SqlConnection.ConnectionString = $connString;

$SqlCommand = $SqlConnection.CreateCommand();
$SqlCommand.CommandText = "EXEC dbo.GetUsersCountByName 'Test'";
$DataAdapter = new-object System.Data.SqlClient.SqlDataAdapter $SqlCommand
$dataset = new-object System.Data.Dataset 
Write-Host $DataAdapter.Fill($dataset) ' records have been exported.' 
$dataset.Tables[0] | Export-CSV C:\MyReport.csv -Force -NoTypeInformation
Write-Host 'New report C:\MyReport.csv has been successfully generated'
}

TestSQLStoredPrc

I am able to get a csv file as output. But I need to apply background color and formatting to the header column of the output csv file.

Can anyone help me to resolve this issue by providing some sample example.

Thanks & Regards, Santosh Kumar Patro

As per mjolinor's answer below you can't, the format does not support what you're asking of it. I would suggest you look at converting your CSV to XLS/XLSX format or another format which supports the desired formatting. — nimizen
– nimizen, Commented Oct 22, 2013 at 21:24

mjolinor · Accepted Answer · 2013-10-22 20:30:48Z

4

You can format it and save it as HTML, but you cannot do that and have it remain a .csv file. CSV is, by definition plaint text - there is no provision for storing foratting information in the file, only header names and values.

answered Oct 22, 2013 at 20:30

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add formatting to header column of csv file using powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related