How to bold the particular row in CSV using PowerShell?

Question

I want to bold a particular row (for ex: row 1) present in CSV file but I cannot able to bold the row. I imported a CSV file in a variable and used System.Windows.Form.Label method to bold the row in CSV file. I am unable to figure out what went wrong.

$c = Get-Content ".\Documents\test\test.csv"
$LabelComputer = New-Object System.Windows.Forms.Label
$LabelComputer.Text = $c | Select-Object -First 1
$LabelComputer.Font = [System.Drawing.Font]::new("Microsoft Sans Serif", 12, [System.Drawing.FontStyle]::Bold)
$LabelComputer.Text | Add-Content ".\Documents\test\new.csv"

Number | Message | Mobile
1      | hello   | 1***6
2      |  hi     | 2**7

Expected: I expect the row 1 (1 hello 1**6) to be bold.

Output: Row1 is not getting bold.

See @Scepticalist answer. If you are displaying the csv in a Form it should be possible to show one line of text bolded, but then you need to edit your question and give us the whole code for building that form and displaying the CSV in there you have. — Theo
– Theo, Commented Aug 21, 2019 at 7:21
The formatting you create applies to the Label object. It is not preserved when you write the text of the Label object back to a file. Not to mention that CSV doesn't support formatting anyway. — Ansgar Wiechers
– Ansgar Wiechers, Commented Aug 21, 2019 at 8:27

Scepticalist · Accepted Answer · 2019-08-21 07:02:44Z

1

CSV doesn't support this - you can do it in Excel but it won't save the formatting.

If you need this kind of formatting, use xls or similar.

answered Aug 21, 2019 at 7:02

Scepticalist

3,9331 gold badge16 silver badges31 bronze badges

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

Comments

Modro · Accepted Answer · 2019-08-21 07:48:58Z

1

There's no way to do that in CSV. You could all caps the output, or you could use another format that supports text styles.

answered Aug 21, 2019 at 7:48

Modro

4563 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to bold the particular row in CSV using PowerShell?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related