UiPath Studio Web - Convert a PDF to XLSX (Google Sheets) and upload it to Drive

Help Studio Web
, , ,
1

Hello dear community,

I am a user of Studio Web and sometimes via email I get an invoice in pdf format.
I want to convert it to XLSX and then upload it to Google Drive.
At present I have the following flow:

For Each Email → Download Email Attachments → For Each currentGmailAttachment → Export a PDF to Other Formats (Output Format XLSX) → Upload Files ( variable Export_PDF) and tick True on Google Workspace file type

And in this last variable “Export pdf” I get an error:

The image displays a compiler error message indicating that the selected value is incompatible with the property type and providing specific details about the error, which involves an implicit conversion issue due to Option Strict On. (Captioned by AI)
The image displays a compiler error message indicating that the selected value is incompatible with the property type and providing specific details about the error, which involves an implicit conversion issue due to Option Strict On. (Captioned by AI)410×388 17.1 KB

I will deeply appreciate help on the matter with some Expression Editor solution or other more general approach.

Thank you a lot, and happy automation !

2

@Ivo_Peshev

May I know what is the variable type of export_pdf…can you check and tell…

Also to verify try to do export_pdf. And if you see locaresource or so can use that

{export_pdf.LocalResource}

Cheers

3

Seems like exportPdf is the wrong type.

4

Hey Anil_G
From the data manager this is what I can see:

The image shows a configuration window in a software interface, specifically for setting up an "exportPdf" component, with fields for Scope set to "Main," Type set to "exportPdf_Create," and a Default value initialized to a new UiPath integration object. (Captioned by AI)
The image shows a configuration window in a software interface, specifically for setting up an "exportPdf" component, with fields for Scope set to "Main," Type set to "exportPdf_Create," and a Default value initialized to a new UiPath integration object. (Captioned by AI)730×498 21 KB

P.S.
The local Resource is the following error

The image shows an error message indicating that "LocalResource" is not a member of "exportPdf_Create" and the system cannot infer an element type due to strict type checking in a file upload configuration interface. (Captioned by AI)
The image shows an error message indicating that "LocalResource" is not a member of "exportPdf_Create" and the system cannot infer an element type due to strict type checking in a file upload configuration interface. (Captioned by AI)1372×840 90.5 KB

5

Hi Silviu,
Thanks for jumping in. Do you have any ideas how can I make it the right type?

Cheers,
Ivo

6

@Ivo_Peshev

if you open advanced editor and do exportpdf. are you getting any suggestions?

Something like this?

The image shows an expression editor with a dropdown list of string methods highlighted, including "Compare," "Concat," and "Equals." (Captioned by AI)
The image shows an expression editor with a dropdown list of string methods highlighted, including "Compare," "Concat," and "Equals." (Captioned by AI)885×497 36.4 KB

also to know the exact type of variable…go to export pdf field…and open advanced editor on top it would display the type

cheers

7

I get the following:

The image shows a code editor's autocomplete feature listing available methods and properties for an object called "exportPdf". (Captioned by AI)
The image shows a code editor's autocomplete feature listing available methods and properties for an object called "exportPdf". (Captioned by AI)1170×358 20.8 KB

The image shows an error message in the Expression Editor stating, "Option Strict On disallows implicit conversions from 'Type' to 'IEnumerable(Of IResource)'." (Captioned by AI)
The image shows an error message in the Expression Editor stating, "Option Strict On disallows implicit conversions from 'Type' to 'IEnumerable(Of IResource)'." (Captioned by AI)1210×326 34.1 KB

8

@Ivo_Peshev

try giving {LocalResource.FromPath(exportpdf.location)}

better print exportpdf.location and check if it is proper location

cheers

9

Thanks again @Anil_G !

Here we are completely over my head, the output from {LocalResource.FromPath(exportpdf.location)} is:

UiPath.Platform.ResourceHandling.ILocalResource

1 Like
10

@Ivo_Peshev

so its working right?

cheers

11

@Anil_G unfortunately it is not working.

The image displays an error message indicating that a URL doesn't exist, and mentions multiple exceptions including UiPath GSuite exceptions and System.IO.FileNotFoundException. (Captioned by AI)
The image displays an error message indicating that a URL doesn't exist, and mentions multiple exceptions including UiPath GSuite exceptions and System.IO.FileNotFoundException. (Captioned by AI)458×600 48.5 KB

12

I found the solution, you need to add Download file (pdf) after the conversion and then Upload to G Drive.

Thank you all for the help @Anil_G !

2 Likes
13

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