Convert multiple excel sheets to Separate Pdf in Uipath

Help Activities
,
1

Hi All,

I have one excel with N number of sheets. I want to convert that sheets to separate pdf.

Can anyone assist?

Thanks,
Sayali

2

Hi @sayali_gujarathi1

You can use the Save excel file as pdf activity to convert the excel to pdf

Hope it helps!!

3

Hi @sayali_gujarathi1

Try this

image

I hope it helps!!

4

Hi @sayali_gujarathi1

Check the post below. It does seem to be the same requirement.
https://forum.uipath.com/t/spreadsheet-to-pdf/511395

Regards,

5

Hi @sayali_gujarathi1

Check this:

6

Hi @mkankatala @lrtetala @Tuannna1

Thanks for your reply.
I am using this activity but there are total 6 sheets and i want to generate 6 different pdf.
Any lead on this?

7

@sayali_gujarathi1

Use Get workbook sheets activity
image

8

@sayali_gujarathi1

Try this

image
image633×659 21.4 KB

9

Hi @sayali_gujarathi1

Then use the below workflow to convert the each sheet to different pdf.

Browser_Practice
Browser_Practice880×1959 150 KB

Browser_Practice.xaml (16.2 KB)

Hope it helps!!

10

Thanks for the quick response.

Let me try this out.

11

Okay @sayali_gujarathi1

I have given the count which changes the pdf names by pdf1, pdf2 like that.

In write range workbook activity check the add headers option.

Hope you got the solution for your query!!

12

@sayali_gujarathi1

  1. Use copy/paste range with sheet name only to create a separate file and then use that file to create the pdf
    or
  2. Use convert to pdf and then split the pdf pages separately

cheers

13

Hi @mkankatala ,

I am not able to open file that you attached. Can you please attached complete ZIP folder ?

14

Sorry @sayali_gujarathi1

Check the below one
Email Process.zip (152.1 KB)

I made the project in to zip. Unzip the file and open the workflow.

Hope it helps!!