Excel Data to SAP upload

Hi Team,

I am in need of your advise.I am stuck in a query where I have to read excel data(for each row) and put the data in SAP accordingly and if the data in SAP gets updated I have to update the status as Success in the same excel sheet.
If by any issue the bot run fails, and I run the Workflow it should not start running from the first line item of the excel instead from the column where the Status column is blank.

image

As in the above picture I am just trying to demonstrate how basically the BOT needs to update the line item and if it fails and I run the flow again it should run from the line where the Status is not updated.

I have total 5 sheets in an excel file and the process needs to be same.

Looking for your support Team.

Hi @Rahulsinha

For success you may know how to update the status as success bcz at that time bot is itself running right ??

For third Situation where if your bot has process few records and when next time it should start with where the blank status is present then put the condition as below.
If row(“Status”) = NOTHING then perform further steps.

For 2nd situation der must be some exception u might handlings so as per that you can put the status as Fail

Mark as solution and like it if it helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

Thanks @Pratik_Wavhal, Ok so if row(“Status”) = NOTHING, then when the flow started it will create a new data table starting from the empty cell of column status which is blank, right?

Could you also let me know how can I use "Add Data row " under for each row activity I mean at the end of updating the data in sap to create a excel report. I just need to update column Status as “Success” or “Fail”.

Hi @Rahulsinha

Yes. Initially also when 1st time bot will start running at that time also from 1st row itself have the status NOTHING and even though if bot gets stuck somewhere and restarted again it is gonna check the row from where the Status value is NOTHING.

But why u r using datarow ??

Instead if you are looping through each row you can just update the Status column value for that particular running row by using Write Cell Activity.

So once that row get processed as SUCCESS/FAIL depending on some rule/condition it will automatically update the particular value for Status column by using write cell activity.

Do as shown in below SS

Mark as solution and like it if it helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Its not proceed to the next @Pratik_Wavhal.

I used the same suggested by you.

image
unable to use = Nothing so here mentioned as Is NOTHING

HI @Rahulsinha

You haven’t used the “.ToString” der so it was not allowing you for “= NOTHING”

Do as i have shown below. It should work.

image

Mark as solution and like it if it helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer: