Powershell export to excel

Question

If we have Powershell script, can we export the result to xls file and not csv?

I try to use below command but not successful.

$Result | Export-Excel -Path $excelPath -AutoSize -BoldTopRow -FreezeTopRow -WorksheetName "Report1"

Answer 1

Hello Handian Sudianto, the AI suggestion above is a good approach, however, if it doesn't work out, you might wanna try some other troubleshooting steps:

First, make sure the module is up to date by running Update-Module ImportExcel. Also, check that the target Excel file isn’t open or locked—this can silently block the export. Running PowerShell as Administrator can help bypass permission issues, especially on corporate machines.

To isolate the problem, try exporting a simple object like this:
$Test = [PSCustomObject]@{Name="Test"; Value=123}

$Test | Export-Excel -Path "$env:USERPROFILE\Desktop\Test.xlsx"

If that works, the issue may be with the structure of your $Result data. Reinstalling the module (Uninstall-Module then Install-Module) can also help if something got corrupted.

Let me know if this helps—and if it does, feel free to hit “Accept Answer” in the corner 😊

Harry.

Answer 2

To export results from PowerShell to an Excel file, you can use the Export-Excel cmdlet, which is part of the ImportExcel module. This module allows you to create Excel files directly from PowerShell objects. If your command is not working, ensure that you have the ImportExcel module installed and imported into your PowerShell session. You can install it using the following command:

Install-Module -Name ImportExcel

After installing, make sure to import the module:

Import-Module ImportExcel

Then, you can use your command as follows:

$Result | Export-Excel -Path $excelPath -AutoSize -BoldTopRow -FreezeTopRow -WorksheetName "Report1"

If you are still facing issues, check for any errors in the command or ensure that $Result contains valid data to export. Also, verify that the path specified in $excelPath is correct and that you have permission to write to that location.