Convert CSV to Excel file in PowerShell

Question

I'm using the following to save a CSV file of output from Event Logs on several Windows Servers:

    Get-EventLog -LogName $logName -ComputerName $servers -Newest 2 -Entry 'Error', 'Warning' -ErrorAction SilentlyContinue | Sort MachineName, TimeWritten | Select MachineName, Source, TimeWritten, EventID, EntryType, Message | Export-CSV $csvFile #ConvertTo-CSV #Format-Table -Wrap -Property Source, TimeWritten, EventID, EntryType, Message -Autosize |

I then remove the first line (as it starts with #Type and is unneeded!):

$file = Get-Content $csvFile 
$file[1..($file.length-1)] | Out-File $csvFile -Encoding ascii

When opened in Excel, it isn't formatted very nice. I'd like to convert this to Excel and format the cells to fit contents, change font size.

Can this be done from within my script?

manojlds · Accepted Answer · 2012-03-29 11:56:35Z

1

When you are calling export-csv, add the -NoTypeInformation flag and that will remove the line type information line.

Try that, and as such, the csv file should be properly opened in excel and you won't need to do anything more.

To do more formatting like fit contents and change font size will be more work. You will have to use COM and do some manipulation.

Have a look here for some examples and further guidance - http://www.petri.co.il/export-to-excel-with-powershell.htm

answered Mar 29, 2012 at 11:56

manojlds

303k66 gold badges482 silver badges426 bronze badges

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

1 Comment

neildeadman Over a year ago

Thanks for the tip regarding the TypeInformation, but I'm looking for the method to do excel formatting etc...

Collectives™ on Stack Overflow

Convert CSV to Excel file in PowerShell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related