How to select specific area in CV Extract Table?

[Sanket_Shinde1 (Sanket Shinde)]

Hi, I want to select / extract the data from excel remote desktop, I am using CV Extract table
activity but , it indicating the whole excel window, hence result is coming with blank excel columns.

I just want to select specific columns area by using CV extract table. How?

[mkankatala (Mahesh Kankatala)]

Hi @Sanket_Shinde1

Are you trying to extract the datatable in the excel or you want to extract the datatable structured elements.

[Sanket_Shinde1 (Sanket Shinde)]

this is excel

and i want to extract only this area of data

[Sanket_Shinde1 (Sanket Shinde)]

output is coming like this

[mkankatala (Mahesh Kankatala)]

It was extracting properly. It will extract all the possible rows and column which are visible.

After extraction we have to use the datatable activities or any other linQ Expressions to delete the unwanted rows and columns.

May I know your requirement which columns you want to delete what I mean is delete the empty rows and columns.

Hope you understand!! @Sanket_Shinde1

[Sanket_Shinde1 (Sanket Shinde)]

hi, Thank you so much for your valuable help,

Right now I just indicated only columns area in CV Screen Scope
and Cv Extract Table
so its working fine now,

also your solution is right that we have to deal with dt activities.

thank you so much.

[mkankatala (Mahesh Kankatala)]

Thank you @Sanket_Shinde1

I hope you find the solution for your query, Make my post mark as solution to close the loop.

Happy Automation!!