Get worksheet information

OpenXML Excel

using DocumentFormat.OpenXml.Packaging;
using S = DocumentFormat.OpenXml.Spreadsheet.Sheets;
using E = DocumentFormat.OpenXml.OpenXmlElement;
using A = DocumentFormat.OpenXml.OpenXmlAttribute;

class Program
    {
        static void Main(string[] args)
        {
            GetSheetInfo("Get worksheet information.xlsx");
            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

  class Program
    {
        static void Main(string[] args)
        {
            GetSheetInfo("Get worksheet information.xlsx");
            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

Last edited Jan 8, 2014 at 10:45 AM by asposemarketplace, version 1