>Is there any way that I can transfer fetched data from a view into an excel file.What version are you using? You could run an instance of Excel through OLE Automation and write the data to it adding formatting and other presentation details just like you can from other languages like VB or VFP, using stored procedures and T-SQL.
Look up:
sp_OACreate
Something like:
DECLARE @object int
DECLARE @hr int
EXEC @hr = sp_OACreate 'Excel.Application', @object OUT