List All Worksheets in a Workbook

VSTO

 	Excel.Application excelApp = Application;

	// Specify the template Excel file path.
	string myPath = "List All Worksheets in a Workbook.xlsx";

	// Open the Excel file.
	Microsoft.Office.Interop.Excel.Workbook ThisWorkbook = excelApp.Workbooks.Open(myPath, Missing.Value, Missing.Value,
		  Missing.Value, Missing.Value,
		  Missing.Value, Missing.Value,
		  Missing.Value, Missing.Value,
		  Missing.Value, Missing.Value,
		  Missing.Value, Missing.Value,
		  Missing.Value, Missing.Value);

	ListSheets(ThisWorkbook);
}

private void ListSheets(Microsoft.Office.Interop.Excel.Workbook workbook)
{
	int index = 0;
	Excel.Range rng = this.Application.get_Range("A1", missing);

	foreach (Excel.Worksheet displayWorksheet in workbook.Worksheets)
	{
		rng.get_Offset(index, 0).Value2 = displayWorksheet.Name;
		index++;
	}
}

Aspose

 static void Main(string[] args)
{
	string myPath = "List All Worksheets in a Workbook.xlsx";
	Workbook workbook = new Workbook(myPath);
	ListSheets(workbook);
}

private static void ListSheets(Workbook workbook)
{
	int index = 0;
	Worksheet thisWorksheet = workbook.Worksheets[0];

	foreach (Worksheet worksheet in workbook.Worksheets)
	{
		thisWorksheet.Cells[index, 0].Value = worksheet.Name;
		index++;
	}
}

Download Sample Code

• Github
• Sourceforge
• Bitbucket