// load a single sheet from a book void _btnLoadSheet_Click(object sender, System.EventArgs e) { // choose file OpenFileDialog dlg = new OpenFileDialog(); dlg.DefaultExt = "xls"; dlg.FileName = "*.xls"; if (dlg.ShowDialog() != DialogResult.OK) { return; } // clear data source, if any _flex.DataSource = null; string[] sheets = _flex.LoadExcelSheetNames(dlg.FileName); Console.WriteLine("Found {0} sheets in this book.", sheets.Length); foreach (string sheet in sheets) { Console.WriteLine(" - {0}", sheet); } // load the first sheet in the book FileFlags flags = (_chkFixed.Checked)? FileFlags.IncludeFixedCells: FileFlags.None; _flex.LoadGrid(dlg.FileName, FileFormatEnum.Excel, flags); }