Extracting and Saving Embedded Excel File from a Password-Protected PDF

[Ajinya_jorwekar]

I have a password-protected PDF containing an embedded Excel file. (Password - Account#23) I need to extract the Excel file and save it to a specified location. Could you please assist me with this?
GASUIN01RPT_22205289696_0212202433262727.csv.pdf (38.1 KB)

[Kismet_Tosun (Kısmet Tosun)]

@Ajinya_jorwekar

it can be help to you. alsı are you try pdf activities?

[Ajinya_jorwekar]

@Kismet_Tosun How can we achieve this in UiPath? Which activities should we use, and is it possible to accomplish the desired solution using the Invoke Code activity?

[Kismet_Tosun (Kısmet Tosun)]

Try download pdf activities from manage pacage

[J0ska]

I do not think there is any activity in UiPath.PDF.Activities package.
You could try “iTextSharp” package for this task.
e.g. see c# - How do I extract attachments from a pdf file? - Stack Overflow

Cheers

[J0ska]

Alternatively, use package UiPath.PDF.Activities version 3.6.0 and below invoke code mockup

Dim doc As BitMiracle.Docotic.Pdf.PdfDocument 
Dim pass As String = "Account#23"
Dim file as String = "GASUIN01RPT_22205289696_0212202433262727.csv.pdf"

doc = New BitMiracle.Docotic.Pdf.PdfDocument(file,New BitMiracle.Docotic.Pdf.PdfStandardDecryptionHandler(pass)) 
doc.SharedAttachments.First.Contents.Save(doc.SharedAttachments.First.Description)

doc.Dispose 
doc = Nothing

Cheers