private void Preview() { using (new OverrideCursor(Cursors.Wait)) { ExcelImporter.WithWorksheetDataTable(Filename, String.Format("SELECT TOP 50 * FROM [{0}]", Worksheet), dt => { previewGrid.ItemsSource = dt.DefaultView; }); } }
private void ListSheetNames(string filename, bool suppressErrorMessages) { if (!string.IsNullOrEmpty(filename)) { using (new OverrideCursor(Cursors.Wait)) { List <String> sheetNames = null; sheetNames = ExcelImporter.GetExcelSheetNames(filename, true); cmbSheet.InvokeIfRequired(() => { cmbSheet.ItemsSource = sheetNames; if (sheetNames != null && sheetNames.Count > 0) { cmbSheet.Text = sheetNames[0]; } }); } } else { cmbSheet.ItemsSource = null; } }