How to copy data from Excel sheet to Data table

Hi,

The task is to copy data from one excel to another excel based on a condition.
I’m trying to first copy into a data table. But I’m unable to do this operation.
Is there a way to directly copy into excel in the same process.
Can someone please help me with this.

Regards,
Chandana

Hi,

Use import Data Table activity. It should work to convert your excel to data table.

Regards,
Amit Anand

Hi Anand,

Can you elaborate a little more and give an outline of the process? How to copy data based on certain conditions from one excel to another?

I also want to execute the same process. I’m new to assistedge. Thanks for the help!

Hi Chandana,

If you were able to execute the process, can you give an outline of how you did it?

Thanks

HI,

First convert your Excel to Data Table usin gImport Data Table activity.
Then iterate over each row of the Data Table and fetch the value of cell in which you want to put some condition
If the condition passed insert that row in another data table

Finally export the data table

Regards,
Amit Anand

Hi Amit,

What argument should I give here? I’m using the advanced loop to loop over the imported datatable.

Thanks

Why am I not able to select my table here even after importing?