Cell formatting in excell via powershell code

Question

I have the following Powershell code:

$users = Get-ADUser -Filter * -Properties * -SearchBase 'OU=User Accounts,DC=itiz-ct-cus3,DC=local' -SearchScope 2 | Sort-Object displayname

foreach ($user in $users)
{
$name = $user.displayname
$phone = $user.ipphone
$tele = $user.telephonenumber
if ($name -like "ctu")
{

}
else {
    "$name,$phone,$tele" | Out-File -FilePath '\\corp\fileshare\IT\Reports\test.csv' -Encoding ascii -Append 
    Write-Host $name $phone
}

}

I am trying to have the output format the cell size in excel. I tried using the Format-table -Autosize, however that was unsuccessful.
Any advice would be greatly appreciated

Answer 1

You'll have to use the Excel,Application COMObject or the ImportExcell PowerShell module to do that.

CSV file are text-only and contain no "formatting" at all.

You'll find plenty of examples on manipulating cell formatting using the Excel.Application by searching the for things like "powershell excel com object", "Powershell Excel Automation", etc. The problem with using that is that it can only be used on a machine that has Excel installed on it (which eliminates servers).

The ImportExcel module doesn't depend on the presence of Excel and is, to most people's way of thinking, easier to use.