Excel sheets to PDFs conversion

Help Studio
, ,
1

Hi team

I want to implement DU on some excels but before that, I need to convert them to PDFs there are 2 types of sheets in the excels that I want to convert to PDF and name them accordingly so how can I do it

suppose I have an excel with sheets 1,2,3,4 but I only want 1 & 2 sheet data to get converted to pdf and the name should become pdf_sheetname eg. pdf_1 and pdf_2

so how should I do it?

2

Hi

There is a activity in to convert from pdf to excel but in vice versa I hope there is no direct activity

But still you can make with multiple other options

—read the excel file with read range activity
Get the output as datatable variable as dt

Then click in MANAGE PACKAGE and install Word.Activities

—Then use WORD ACTIVITY under which use EXPORT TO PDF and mention the file name you want

Cheers @Aishwarya_Bhargava

3

Hi @Aishwarya_Bhargava
You can try this activity for converting the excel to pdf

Regards,
Nived N
Happy Automation