How to convert an excel sheet to PDF

I have an excel sheet that contains all the required data and I want to save it as PDF like this

The data in the excel sheet is not formatted it is sample raw data with rows and columns

How can I achieve this?

Hi @Sami_Rajput

Please use this activity


What about the formatting part to make it something similar to the PDF report,which i have uploaded it here

Hi @Sami_Rajput

Create a template in this format…Then read the data from your excel and fill the template…Then use pdf conversion


@Sami_Rajput Use Powershell script - Call this script with inbuilt powershell UiPath activity , 100 % result

$path = "[your file path]"
$xlFixedFormat = “Microsoft.Office.Interop.Excel.xlFixedFormatType” -as [type]
$excelFiles = Get-ChildItem -Path $path -include *.xls, *.xlsx -recurse
$objExcel = New-Object -ComObject excel.application
$objExcel.visible = $false
foreach($wrkb in $excelFiles)
 $filepath = Join-Path -Path $path -ChildPath ($wrkb.BaseName + “.pdf”)
 $xlworkbook = $$wrkb.fullname, 3)
 $xlworkbook.Saved = $true
 $xlworkbook.ExportAsFixedFormat($xlFixedFormat::xlTypePDF, $filepath)

Please Refer and Thank below


Hello @Sami_Rajput

Please check the below video.