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.
Somebody, please guide me.