Kudos.......
Finally I am able to place an order into Nest Plus using Excel sheet.
Truly said, you can achieve anything if u ask for help and put in your efforts..
Here are few troubeshooting steps that i did to achieve this.
First of all thanks to Yusi for always posting reply for my silliest queries. I sent many PM to multiple users here, no one replied but yusi tried his best to reply.
so here it goes.
1. When i first attempted to place order in Nest using Excel sheet, i got error "Object Name not set".
Resolution : I actvated "Plus Trading Plugin" in my Nest Plus Dashboard". See screenshot below
2. Since i was misguided by Zerodha executive of heavy hectic price to activate Plus Trading Plugin, and i was busy with my other stuff, i kept silent for few days.
3. Few days back when i again tried to place order by installing latest version of Zerodha, i got error saying "cannot create object.... Error code : 429".
Resolution: After searching on internet i found it is mostly because of bad registry entries. So i did below steps, i really dont know which trick worked, but it worked.
a. Uninstall zerodha trader.
b. Run AVG PC Analyser which identifies all bad registry entries on your machine and deletes them
c. installed .Net Framework 4.0 (some where over internet this was also a solution)
4. I reinstalled Zerodha.
5. Restarted my machine and tried same code from excel. It worked.
Now i need to work and debug more in this api.
Thanks to all those who took effort to reply me.