Pdf to excel activities and properties

[vijayalakshmi8 (vijayalakshmi)]

hi
when ever iam trying to apped the data from pdf to excel sheet it is not get appended.here iam sending screen shots of the activities along with the properties one by one please chech where i made a mistake that is not getting appended.

[vijayalakshmi8 (vijayalakshmi)]

finally iam getting this as output ony the coloumns are appended in the sheet not there values plz check the reason.

[AshwinS2 (Ashwin S)]

Hi @vijayalakshmi8

Have you use build datatable activity and add data row

Have a try

Thanks
Ashwin.S

[vijayalakshmi8 (vijayalakshmi)]

can you suggest me what should i give in properties as i have never tried using this activity this is my first time using this

this is what i got

[vijayalakshmi8 (vijayalakshmi)]

@Myshudhage @venkatmalla6 @Palaniyappan any suggestions what i have created as im unable to extract the data in columns in the excel sheet from the provided PDF

pls Help!!!

thanks in adv

[AshwinS2 (Ashwin S)]

Hi @vijayalakshmi8
Pass the value datatable value and use array row value

Thanks
Ashwin.S

[vijayalakshmi8 (vijayalakshmi)]

@sne check this solution it might work for you or can u help me with this solution which we are looking for

[vijayalakshmi8 (vijayalakshmi)]

@AshwinS2 can u give a brief so that i can st those as i’m new into this

thanks in adv

[AshwinS2 (Ashwin S)]

Hi @vijayalakshmi8

Use add data row activity

In array row {textvalue}

Datatable give the datatable name and print the datatable with output datatable

Thanks
Ashwin.S

[vijayalakshmi8 (vijayalakshmi)]

did do right this time>>???

[AshwinS2 (Ashwin S)]

Hi @vijayalakshmi8

Give the column headers in build datatable
Give the values in array row like string variables

Thanks
Ashwin.S

[vijayalakshmi8 (vijayalakshmi)]

Main.xaml (6.3 KB)

[vijayalakshmi8 (vijayalakshmi)]

@AshwinS2

Give the column headers in build datatable
Give the values in array row like string variables

i didn’t quite understand what u have said can you give a brief about it???

thanks in adv
@vijayalakshmi8

[vijayalakshmi8 (vijayalakshmi)]

i have gone through this solution for you rply but i have given the same yet their is no O/p

Array of strings as a data table column

See your problem was you were not able to insert array in column now that we have inserted the array, how do you want to retrieve? See the attached sample in which I have inserted an array of strings {“1”,“2”,“3”} in data table, then retrieved the same in for each row of data table - Main.xaml (10.7 KB)

[vijayalakshmi8 (vijayalakshmi)]

hi
how should i fill this property, i have no idea about add data row activity so plz can you suggest me how to fill

[meenuknd100 (Meenu)]

Sir, In my uipath studio, properties does not contain keywords? Please help me how to solve it.

[tamim1640 (Tamim)]

Hello
Do you know how can I get the Pdf To Excel Package ?
I can’t find it in the manage packages in uipath studio.

[Paul_Waine]

Manage Packages > Settings > Tick all the default package sources. Then search!