Data extraction from table

hai
I need to extract a particular column in a table and to check whether the value is available are not? can anyone give some ideas to start with thanks in advance.

use a for each row to get the value of each row in the table and then use a if condition to check if the value matches or not.

hope this helps :slight_smile:

Hello,

I supposed you are working with Excel. For a better understanding, I recommend the following links:
https://forum.uipath.com/t/how-to-retrieve-one-column-from-data-table/31761/4
https://www.uipath.com/developers/video-tutorials/excel-and-datatables-automation

let us know if you need more guidance. :slight_smile:

1 Like

Use for each row
then use row.(“[columnname]”).ToString for checking

I need to get the table in a website where the particular column I have to scrape it!like I have to take the march month value alone

you can map the corresponding column index to march and thats it.

You just need to select the first and second row of March column. :slight_smile:

error

i got error like this

Hi! Can you upload your workflow? Thanks.

Main (9).xaml (8.6 KB)

Hi @priyankavivek
Try this .xaml file. Just update the workbook file path.
Main (9).xaml (7.7 KB)

Thanks and regards,
Despi

2 Likes

thank you very much sir ,i will look in to this for getting solution

No problem.
If you encountered some problems, feel free to reach out.
I will help you.
Regards!

2 Likes

hai ,
i need to get the technical skills(10 columns) based on user input(excel file).

  1. USER need to enter the skills like JAVA,RPA etc.,
  2. Based on the above condition , have to write output(all data eg.name,mail id…) into separate excel file.
    any idea on this please give some idea @Jan_Brian_Despi