When i open Edit in Datasheet view with IE 10 then i was not able to see the excel type output. To make this functionality work i clicked on F12 to open IE toolbar and went to Browsermode menu and selected IE8 compatibility view. Then i am able to open edit in datasheet view option.
