Using extract table data function

Help StudioX
,
1

Hello all, I have been having trouble using the extract table data function in ui path. My goal is to extract certain cells in excel to another excel file. Basically want to copy the cells from one file into another file. Thanks in advance

2

Hey

Are you trying to use the extract table to read a open excel file?

Inside the UiPath we have the Excel activity to do that

3

Hi @trevor.thenga

Welcome to Uipath community

You can try with Read Cell activity

Check out the document

After that Use Write cell activity to Write the data into another excel file

Check out the document

Regards
Gokul

4

HI @trevor.thenga

Welcome to UiPath Community!

Can you share your sample input and output?

Also try like this

  • Use Read range and read the data
  • Use Filter datatable and filter the wanted rows
  • Use Write range and write them in another excel.

Regards
Sudharsan

5

Hello @trevor.thenga, Welcome to UiPath Community :smiley:
you can use the read cell activity to read the data from the Excel cell value as a string and can write into different sheets or file using the Write cell activity get some idea
Refer to this thread, you may get some idea

image