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); } } }
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); }