Add extracted information in Excel

Help
, , ,
1

Friends help me, I need to read all PDFs that are in a folder, get the information and put the extracted information in Excel, adding and not overwriting.

2

hi @KarinaFreitas use write range activity ,inwhich remove the tik mark from the overwrite option then only the overwriting won’t be raised…

1 Like
3

Hai @KarinaFreitas…

  1. Read the pdf with the read pdf activity

2.In assign FileInside [] = Directory.GetFiles("\data\"*.*",SearchOption.AllDirectories)

If you want to read all files then mention “ . ” else specify like below for particular files.

Excel - “ .xlsx"
PDF - " .pdf”
etc…
3.Then use write range activity to write in excel
U can refer it Sequence.xaml (5.8 KB)

2 Likes
4

Thank you! But how do I use these variables in Excel? I’ll attach the prints here for you to see if it’s correct.
image
image
Which variable do I use in the output of the Write Range activity?

5

Haii @KarinaFreitas,
Which variable used for store the files, please use that variable in the output of the write range activity

2 Likes
6

@KarinaFreitas
1.use assign activity before the read pdf activity.
2.Within that assign activity create the variable as named FileInside and put this expression in VB expression field,
** Directory.GetFiles(“\data".”,SearchOption.AllDirectories)** as wat nandhuba said above…
3.now you use read pdf activity and pass the variable FileInside…

1 Like
7

You have the order of activities a little confusing… If excel will be the same, dont open it inside a For Each , but before it or you will have it opened several times causing your process to be slow and have more error possibilities… Process you pdf before the excel scope and never inside it.

1 Like
8

will this make you read all the PDFs in the directory? At the moment it is what I need to not only see the pdf that I select in the activity.