EXCEL

(0) Share

Report

Posted on by fjmatosnog

Is there any action in POWER AUTOMATE DESKTOP so I can turn an excel file (xlsm) into a PDF?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @fjmatosnog

You can use run powershell script to run the below script which converts excel to pdf

# Load the required assemblies Add-Type -Path "C:\Program Files\Microsoft Office\Office16\Excel.dll" Add-Type -Path "C:\Program Files\Microsoft Office\Office16\microsoft.office.interop.excel.dll" # Create a new Excel application object $excelApp = New-Object -ComObject Excel.Application $excelApp.Visible = $false # Open the Excel file $workbook = $excelApp.Workbooks.Open("C:\path\to\your\excel_file.xlsx") # Save the workbook as PDF $pdfPath = "C:\path\to\output\pdf_file.pdf" $workbook.ExportAsFixedFormat([Microsoft.Office.Interop.Excel.XlFixedFormatType]::xlTypePDF, $pdfPath) # Close the workbook and quit Excel $workbook.Close() $excelApp.Quit() # Release the COM objects [System.Runtime.Interopservices.Marshal]::ReleaseComObject($workbook) | Out-Null [System.Runtime.Interopservices.Marshal]::ReleaseComObject($excelApp) | Out-Null [System.GC]::Collect() [System.GC]::WaitForPendingFinalizers() Write-Host "Excel file converted to PDF successfully."

Let me know whether this helps !

Was this reply helpful? Yes No
fjmatosnog 2 on at

Like (0)

Report
Copy link

Link copied!
Hi Nived, when I ran the first command I got an error message saying that the Excel.dll and microsoft.office.interop.excel.dll files don't exists at this path. The first part of the error is in Portuguese, but it's saying this. After that, the others commands also raises erros messages
Add-Type : Não é possível associar o parâmetro 'Path' ao destino. Exceção ao definir "Path": "Não é possível localizar o caminho 'C:\Program Files\Microsoft Office\Office16\Excel.dll' porque ele não existe." No linha:1 caractere:16 + Add-Type -Path "C:\Program Files\Microsoft Office\Office16\Excel.dll" + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (:) [Add-Type], ParameterBindingException + FullyQualifiedErrorId : ParameterBindingFailed,Microsoft.PowerShell.Commands.AddTypeCommand

Add-Type : Não é possível associar o parâmetro 'Path' ao destino. Exceção ao definir "Path": "Não é possível localizar o caminho 'C:\Program Files\Microsoft Office\Office16\microsoft.office.interop.excel.dll' porque ele não existe." No linha:1 caractere:16 + ... -Type -Path "C:\Program Files\Microsoft Office\Office16\microsoft.off ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (:) [Add-Type], ParameterBindingException + FullyQualifiedErrorId : ParameterBindingFailed,Microsoft.PowerShell.Commands.AddTypeCommand

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @fjmatosnog

do you have excel installed on the machine on which you are trying to run the flow ?

Was this reply helpful? Yes No