Excel Mapping Solution approach can be replaced by Document understanding?

[rds0511 (Rdssoftware0511)]

Hi Team,

Book2.xlsx (9.4 KB)

I have attached one excel file. Where I am using Excel mapping.
for example : with reference to excel attached

case 1 : if agency is Abaca then in order file , order value will be taken from C5 column. In this case order value will be “jkskd”

case 2 : if agency is Basava then in order file , order value will be taken from H4 cell .In this case order value will be “hsgg”. Here we are finding first cell value for “def” and then we are using offset values mentioned in excel mapping.

We have 1000 agencies. Can this be possible through Document Understanding.
We have already built in excel mapping for all agencies and it is getting modified.

If I can get any pro advice for best solution approach.

Thanks,
Rds

[Anil_G (Anil Gorthi)]

@rds0511

Welcome to the community

To read the excel file why do you need document understanding?

Is there some other requirement as well?

Cheers

[rds0511 (Rdssoftware0511)]

Hi Anil,

Template is same and unique for each agency. There are 1000 agencies and we have to use excel mapping. There are pdfs also and we are converting into excel. Just I was curious if we can take leverage of DU.

Regards,
rds

[Anil_G (Anil Gorthi)]

@rds0511

Please leverage the steps given in another thread …

Click Based on excel data mapping

@rds0511 Follow the steps In click activity first give innertext in selector and use variable in it Use a for each row in datatable Row.ByField("ColumnName").StringValuewill be the value you need….so first check if it is a cell number System.Text.RegularExpressions.Regex.IsMatch(Row.ByField("ColumnName").StringValue,"[A-Z]+\d+") this will give true when the value is a cell number els eit gives false On then side use in range On else side use find/replace first to search and then using next co…

cheers

[rds0511 (Rdssoftware0511)]

Yes . I am on it. Thanks for your reply. Will update that in thread. But can we train excels also in DU.

[Anil_G (Anil Gorthi)]

@rds0511

No Excel cannot be trained as du model…

cheers