display data in Excel Sheet from a table in sql server (c#.net in win app)

There are many ways to do it. You can use ADO .Net. Anotehr way would be to set up Excel to do it and thenexecute it from C# is you need to.