コード例 #1
0
ファイル: ExcelBaseDet.cs プロジェクト: OSRS/Oncor_Base
        public void OpenWorkbook(string filename, LoadRow loadRow, CheckSheetCount checkSheetCount, CheckHeaders checkHeaders)
        {
            XlWorkbook book = new XlWorkbook();

            book.Load(filename);
            Load(book, AddSheet, loadRow);
            checkSheetCount();
            if (checkHeaders != null)
            {
                foreach (XlWorksheet worksheet in book.Worksheets)
                {
                    checkHeaders(worksheet);
                }
            }
        }
コード例 #2
0
ファイル: Program.cs プロジェクト: OSRS/Oncor_Base
        private static void ReadWorkbook(string fName)
        {
            Console.WriteLine("Reading workbook named [{0}]", fName);
            XlWorkbook book = new XlWorkbook();

            book.Load(fName);
            foreach (XlWorksheet worksheet in book.Worksheets)
            {
                PrintWorksheet(worksheet);
            }
            foreach (XlCustomProperty property in book.Properties)
            {
                PrintCustomProperty(property);
            }
            Console.WriteLine("Closing workbook named [{0}]", fName);
        }