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