I am having an excel name “CS1” and another “sheet1”
…Now for CS1 sheet i have value in column A… i am extracting data from web page on the basis of value of cells in column A and doing all activity in for each and writting into excel but sometime my website get crash for that i put all the process in retry scope
Now my problem is when bot took retry loop started from cell A2…Because row 1 is header…
and bot maximum taking 4-5 entry…
i thought a solution: — Read excel file…
FOR each row…
if currentRow(“xyx”).ToString <> “”
then cut the entrie active row and paste it to the 1st non empty cell of column A of sheet1…
please help me with solution how to cut and paste these value…because i am not getting any activity and expression for it…
or if there is any other solution please let me know…
I think I might have misunderstood your situation. But let me clarify:
- You have line items/transaction items in an Excel file and they are located in column A.
- You read the Excel file into a datatable and iterate using for each row in datatable.
- You extract information from the webpage and write it into your Excel file one by one
Are these correct? So you are asking, what is the best practices for this process, correct?
Cheers,
Azeem
Simple is that
i have an excel sheet name “CS1”…and row 1 is header row…values are from cell A2
now i want if in cell A2 has value then cut the entire row and paste it to “Sheet1” and this process should repeat…for multiple time…and value should paste one after another…everytime…
Regards.
Ex. Input
you want Output like this?
if yes, try this.
Extract.xaml (12.7 KB)
Thanks for the flow…but i cannot delete the sheet…
because according to my flow… I am taking employee id one by one from web page…i am entering “Full Name”… into excel
Please help me with correct solution.
you can use this
Extract.xaml (15.0 KB)