Convert Excel worksheets to a PDF

Help Studio
, , , ,
1

Hello Community,

i am trying to convert multiple Excel worksheets to a own PDF.

I am useing a for each loop and the Studio activity ‘Save Excel As PDF’.

image
image570×535 32.4 KB

Is it possible to loop through all Worksheets with a counter variable and print every worksheet to PDF within the used activity? [E.g. Excel.Sheet(“Worksheet”+counter+) ]

Unfortunately i cannot create a dynamic counter variable because it keeps giving me this error.

image
image804×310 13.8 KB

2

HI @MWB

I don’t this so we can able pass the counter in the Save Excel file as PDF activity.

  1. Use Excel process scope
  2. Use Excel file
  3. Save Excel File As PDF

Just Use as Excel

Look out the screenshot

image

Refer this video link

Regards
Gokul

3

Hello @MWB ,

Read all the sheet one by one and create new excel file and write data into that and save that file as pdf.

Hope this will help you.

Thanks,
Sanjit

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.