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 .
Read all excel one by one, fill the data corresponding to company names in excel.
I have fetched all the data from the website but I am not able to push it back to the respective excels.ReadCustomer_data.xaml (35.3 KB)
For write range we need to specify the input cell right?
I tried using ‘Write Cell’ activity and it works for the first excel. I have incremented the counter each time. First excel has 2 rows and it reads back the data correctly.