CONVERT A SPECIFIC RANGE OF EXCEL SHEET INTO PDF

I need to convert a specific range of excel into pdf…

Hi @Usha_Jyothi

Welcome to our community!

Use a read range activity with the range you want
Create an empty excel file and add the datatable you’ve extracted above
read the new excel file and save it as PDF like this

Hope this helps
Regards

Hey @Usha_Jyothi
Hope you find this helpful
pdf forum.zip (84.1 KB)

Cheers.

2 Likes

this saves entire excel as pdf,
but i need to save only specific range in excel and to convert into pdf

Then You must read range of that what you need and write range of that excel use that same excel to conver to pdf.
This is the updated workflow.
taskk pdf.zip (73.5 KB)
Hope this helps.
Regards

5 Likes

Hi @Usha_Jyothi

=> Use read range workbook activity to read the excel file. In the range field you can mention the range and sheet field you can give the sheet name in the excel. The read range workbook activity will store the data in a datatable. Let call it as dt_Excel.
=> After Read range workbook activity insert the Write range workbook activity to write the datatable to a dummy excel. In the Workbook path field give the dummy path to store this excel.
=> After Write Range activity Insert the Use excel file activity and pass the dummy excel path.
=> Inside Use excel file activity insert the Save excel file as pdf activity to write all the excel data to the pdf.

Hope it helps!!