Get worksheet information

OpenXML Excel

 string FilePath = @"..\..\..\..\Sample Files\";

string FileName = FilePath + "Get worksheet information.xlsx";

GetSheetInfo(FileName);

Console.ReadKey();

}

public static void GetSheetInfo(string fileName)

{

// Open file as read-only.

using (SpreadsheetDocument mySpreadsheet = SpreadsheetDocument.Open(fileName, false))

{

    S sheets = mySpreadsheet.WorkbookPart.Workbook.Sheets;

    // For each sheet, display the sheet information.

    foreach (E sheet in sheets)

    {

        foreach (A attr in sheet.GetAttributes())

        {

            Console.WriteLine("{0}: {1}", attr.LocalName, attr.Value);

        }

    }

}

Aspose.Cells

 string FilePath = @"..\..\..\..\Sample Files\";

string FileName = FilePath + "Get worksheet information.xlsx";

GetSheetInfo(FileName);

Console.ReadKey();

}

private static void GetSheetInfo(string fileName)

{

//Instantiating a Workbook object

Workbook workbook = new Workbook(fileName);

//Loop through all Sheets in the workbook

foreach (Worksheet Sheet in workbook.Worksheets)

{

    //Get Name and Index of Sheet

    Console.WriteLine("Sheet Name: {0}", Sheet.Name);

    Console.WriteLine("Sheet Index: {0}", Sheet.Index);

    //Loop through all custom properties

    foreach (CustomProperty Property in Sheet.CustomProperties)

    {

        Console.WriteLine("{0}: {1}", Property.Name, Property.Value);

    }

}

Download Sample Code