AbbyyFlexicapture

Hi, I have created the project using the AbbyyFlexicaptrue and AbbyyLayout.
When I run it’s working fine. And extracted the correct value from the invoice.

I have used the UiPath workflow to run and save the data in an excel. But it’s giving the default value to excel file.

Is there any way i can see the reall time value while abbyy capturing the data, basically I want to read the name from the extracted data from the invoice and save the excel with the name only.

@Palaniyappan @lakshman @Lahiru.Fernando @HareeshMR

2 Likes

Fine
What is that default value mean buddy
Kindly elaborate a bit more on what detail is needed in excel
Cheers @balkishan

2 Likes

This bro, Actually in this workflow it give the same name to all the excel,
suppose first extract from Invoice1.pdf
so it will create the folder with the same name of Invoice1 with additional info like data. Then inside it create the Excel with extracted information. I attached the snapshot.
If we have 10 invoice it will create 10 diff folder and same the each invoice data in each folder.
Like this bro.
image

But instead of the giving this name to the excel I want to read the name first from the abbyy extracted data then save the excel with that name.

Ex I have extracted the 5 field, CustomerName, Date, ArrivalTime and so on.
So I want to read the CustomerName and save this excel with the customer name.

2 Likes

Fantastic
So how the value of CustomerName is extracted as a individual value or as a table
—if it is obtained as individual value then no worries we can mention that as Filename path in the excel application scope activity
Or
—if we are getting that as datatable then we are get from the for each row loop and get the excel named assigned to a variable that can be used in excel application w
Or
If we are getting as a string as a whole then we can use regex or string manipulation method

Kindly correct me if I am wrong with the question
Cheers @balkishan

2 Likes

Individual only bro.

2 Likes

So we can directly mention that in excel application scope like this
“Folderpath”+CustomerName.ToString+”.xlsx”

Which will directly create a new file with that name

Cheers @balkishan

2 Likes

This CustomerName is created in AbbyyFlexilayout bro, Not in UiPath

1 Like