@srinivass you can use recorder or just the proper activities to go to the desired web app(Open browser, Type into username, Type secure text for the password, Click Login button).
Then you can use a For each activity to iterate the datatable and get your desired data from there. Ex: For each row in DT - Type into (some text box field you have there) row.toString.
I hope i got the main idea. What is the information you want to enter and where(what are the fields)? For example, data from Row1 in a form in the web app.
So you mean to say first i should create another sequence which logs into the third party system via a web url and then use the datatable variables which was
created after the excel application is saved, to be input into the system.
thats what i get in the excel file, i just need to logon to the web based system and then enter the information for that person there
what is the best practice in this kind of scenario, so that we split into different sequences and then call from main workflow
You can have a sequence to read the excel file and extract the data you need. And another one to logon and enter data. Then invoke from the main workflow.
the third party system is a desktop application. if i have to pass the data which i have extracted, do i have to use a data table and store it and then when i invoke the desktop application access the values from the data table. Is my understanding right here
I keep getting this error, can someone point me in the right direction
OutLookAttachement has thrown an exception
Source: Read Range
Message: The sheet does not exist
Exception Type: ArgumentException
System.ArgumentException: The sheet does not exist
at UiPath.Excel.WorkbookApplication.SetSheet(String sheetName, Boolean createNew)
at UiPath.Excel.Activities.ExcelInteropActivity`1.BeginExecute(AsyncCodeActivityContext context, AsyncCallback callback, Object state)
at System.Activities.AsyncCodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
Your excel file looks empty now? Even when you open it manually?
I have the same workflow with the same data as you and the output is displayed in the message box: test.zip (8.1 KB)
I have one more question, if i need to pass this information to a desktop application system. how do transfer data from this data table.
I have to use desktop recording for the application to login and navigate, but i m not sure of passing the excel information from data table to the desktop.
How can I select a date one day before if there is only clicking option .
For ex : If I want to run a report on 25th September 2017 I need to select a one day before date i.e 24th Sep2017.