How to use Powershell to enforce formatting of an Excel Column?

Question

I'm writing a Powershell script to enforce "General Formatting" of Column AI. This is what I have and it didn't appear to execute.

$worksheet.columns.items('AI').GeneralFormat = $true

What is the right Powershell code for such a task?

General Formatting:

G42 · Accepted Answer · 2017-05-22 16:02:44Z

4

The clue is in your screenshot; the tooltip specifies this is the "Number Format" setting.

$worksheet.Columns("AI").NumberFormat = "General"

Check out the MSDN page on NumberFormat. Unfortunately it doesn't list the allowed values; this StackOverflow q/a appears to cover that.

answered May 22, 2017 at 16:02

G42

10.1k2 gold badges22 silver badges36 bronze badges

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

Comments

Leo Louis · Accepted Answer · 2018-04-25 15:27:34Z

3

This works

$Excel01 = New-Object -ComObject Excel.Application
$Excel01.Visible = $True
$Workbook01 = $Excel01.Workbooks.Add()
$Worksheet01 = $Workbook01.Sheets.Item(1)
$Worksheet01.Activate()
$Excel01.Columns.item('d').NumberFormat = "0"

answered Apr 25, 2018 at 15:27

Leo Louis

311 bronze badge

1 Comment

Jean-François Corbett Over a year ago

What value does this add over the accepted answer posted a year earlier?

Collectives™ on Stack Overflow

How to use Powershell to enforce formatting of an Excel Column?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related