How to extract specific unstructured data from excel file

Help Studio
, ,
1

i wanna extract particular data like PO# ,POExpiry and i couldnt find solution for it .so, can anybody help me out ? i have also shared file below

Screenshot (13)_LI
Screenshot (13)_LI1364×766 244 KB

2

Hello @kaavya

Is this a fixed template? Or this can be changed frequently?

Thanks,
Prankur

3

fixed template @PrankurJoshi

thanks,
kaavya

4

Is there any possibility that you can directly read that cell? Or you do not want to open excel?

5

see the whole process is like i have to download excel file from website and i wanna open excel file and extract particular values as i mentioned above and store in a different excel file. so now i don know how to extract it as it is not in a structured way.

6

Yes but if it’s a fixed template you can use Read Cell activity to get the value from those two fields and save it in a different excel.

7

thank you @PrankurJoshi , let me try and check.

1 Like
8

hi ! i used read cell activity and given range but still it din get values @PrankurJoshi

9

Can you tell me what activity you used may be a screenshot?

10

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