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
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
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!!