How to convert an excel sheet to PDF

Help Studio
1

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

image
image496×525 95.8 KB

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

How can I achieve this?
Thanks!

2

Hi @Sami_Rajput

Please use this activity

https://docs.uipath.com/activities/docs/save-as-pdf-x

Cheers

3

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

4

Hi @Sami_Rajput

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

cheers

5

@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 = $objExcel.workbooks.open($wrkb.fullname, 3)
 $xlworkbook.Saved = $true
 $xlworkbook.ExportAsFixedFormat($xlFixedFormat::xlTypePDF, $filepath)
 $objExcel.Workbooks.close()
}
$objExcel.Quit()

Please Refer and Thank below

Thanks,
Sri

6

Hello @Sami_Rajput

Please check the below video.

Thanks