I am working on a demo project where I have to send the reports of the stock market to different clients. The company’s whose stock price they want are stored in different excel, for example, client1’s requirements are in excel 1 and client2’s requirements are in excel 2 and so on. I am collecting stock market data from Moneycontrol.com.
I have to create a queue to push the stock report data.
Read all excel one by one, fill the data corresponding to company names in excel.
Send mail to all clients with their excels attached.
I have done some part of it but not getting the output.
I have these 2 excel files in a folder and I have to read them one by one and push the data to the queue… getting either of the following two errors.
1.Source: Bulk Add Queue Items
Message: The value for argument ‘Data Table’ is not set or is invalid.
Exception Type: UiPath.OrchestratorClient.Utilities.ArgumentValueNotSetException
Source: Bulk Add Queue Items
Message: Operation returned an invalid status code ‘BadRequest’
Exception Type: Microsoft.Rest.HttpOperationException
@AshwinS2 i build the process again on a flowchart it worked.
I don’t know why that file is giving error.
Again my next problem is… i have to fill data in the client excel sheet through a website…
i have fetched data from website… but not getting how to write again everything in the excel for different clients.
can u plz throw some light.
For this, kindly check once with the datatable variable passed to this activity under the property “Datatable” . I hope it’s a datatable variable
And I hope it’s not about the Result property
And then
This usually occurs when we are trying to process large set of data. Is that so
Or are we using data from asset of such large size
Kindly provide these details buddy
We are almost done
Cheers @Shanky_Bhatnagar
Fine
If we are getting with same set of columns from the website scrapped data which is similar to that of our datatable and it’s column we can directly use merge datatable activity or append range activity
Or
If we want to get only certain columns from the scrapped datatable then
— we can use for each row loop and pass that scrapped datatable as input
— inside the loop use som assign activity and assign the required column values one by one like this Out_value1 = row(“yourcolumnname”).Tostring
And Out_value2 = row(“yourcolumnname”).Tostring
And
It goes on as required
— now still being inside the for each row loop next to these assign activities use a activity called add to datarow activity and mention our source datatable (the one we got from excel) name as one input parameter and then pass the above obtained variables as Array of value in ArrayRow property like this (in the order of column in our source datatable) {Out_value1,Out_value2,…,Outvaluen}
@Palaniyappan can u suggest, if i have number of excel files in a folder, i have pushed their data in the queue and corresponding to each company (data in queue) i have gathered data from website , how to rebuild the excel with all the data.
Excel application scope
-Read range
For each row loop
-Open browser
—Search for Data
—Extract Datatable (still we are in loop)
-For each row loop and pass the above extracted datatable as input
—now we can use assign activity to get the values
—use Add datarow activity
(once this is done for all rows in the current extracted datatable it will go to the next row to be searched in the outer for each row loop)
Like wise it goes on
I am using UI Automation Activities like type into, Get Text etc and i am storing data in different variables so there is no data table. how do we proceed den.
Anil_G
Srivennila_Anandan
mudkipZ
Umut_Veysel_DURKEN
Venkat4