/// <summary>
/// Open Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ButtonOopenExcel_OnClick(object sender, RoutedEventArgs e)
{
// Open Excel and Read Data
OpenFileDialog m_dlg = new OpenFileDialog
{
Filter = "Excel Docs (*.xlsx)|*.xlsx",
Title = "Select an Excel Mail Merge Source",
Multiselect = false
};
if (m_dlg.ShowDialog() != true)
{
return;
}
if (!string.IsNullOrEmpty(m_dlg.FileName))
{
_excel = new ExcelApp(m_dlg.FileName);
}
// Worksheets
ComboBoxWorksheets.ItemsSource = _excel.WorkSheetTables;
ComboBoxWorksheets.DisplayMemberPath = "Key";
if (ComboBoxWorksheets.Items.Count > 0)
{
ComboBoxWorksheets.SelectedIndex = 0;
}
_excel.ExcelShutDown();
FormIsReady();
}
