Here Mudassar Ahmed Khan has explained with an example, how to get list of Sheet (WorkSheet) names of Excel file in ASP.Net using C# and VB.Net.
The Excel file will be first uploaded and copied to a Folder (Directory) on Server and then it will be read and opened using OLEDB and the Sheet (WorkSheet) Names of the Excel file will be fetched.