Hi Shiva,
If someone has written a similar code can help sharing it with you, but in the interim you can make use of the existing MS Excel VBO.
You can open the MS Excel VBO and take a look at the 'Get Worksheet as Collection' tab which is in Visual Basic and use it as a basis to start developing your own code in C#.