After reading this excellent code snippet by djjeavons, and just trying to learn WPF, I decided: "Well, let's translate that to WPF!". It was a bit harder than I thought, but a great learning experience! Her's how my screen in action looks:
Things that changed compared to the Forms version:
--- OpenFileDialog works a bit different.
--- WPF has no DataGridView but another beast called DataGrid
--- Exiting an application has also changed.
The communication with Excel still worked seamlessly.
I managed to overcome the difficulties and learned alot in doing so.
Hope you enjoy to find out all the code differences. :)
My code is included, the XAML as well as the code behind.
Have fun!

EDIT: The colors on my window are not meant to "beautify" the whole thing, but helped very good to keep track of all my WPF panels.

Edited by ddanbe: addition

Nice snippet
cs file

using System;
using System.Collections.Generic;
using System.Data.OleDb;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using Microsoft.Win32;
using System.Data;

namespace ExcelCookbookReader
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
        public MainWindow()

        private void openFileButton_Click(object sender, RoutedEventArgs e)
            OpenFileDialog openDialog = new OpenFileDialog();
            openDialog.Filter = "Excel files(*.xlsm )|*.xlsm|(*.xlsx )|*.xlsx";
            if (openDialog.ShowDialog() == true)
                excelFileTextBox.Text = openDialog.FileName;
                //Get all worksheet names from the Excel file selected using GetSchema of an OleDbConnection
                string sourceConnectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0 Xml;HDR=YES'", excelFileTextBox.Text);
                OleDbConnection connection = new OleDbConnection(sourceConnectionString);
                DataTable tables = connection.GetSchema("Tables", new String[] { null, null, null, "TABLE" });
                //Add each table name to the combo box
                if (tables != null && tables.Rows.Count > 0)
                    foreach (DataRow row in tables.Rows)

        private void worksheetsComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
            //Display the data from the selected Worksheet 
            string sourceConnectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0 Xml;HDR=YES'", excelFileTextBox.Text);
            OleDbDataAdapter adapter = new OleDbDataAdapter(String.Format("SELECT * FROM [{0}]", worksheetsComboBox.SelectedItem.ToString()), sourceConnectionString);

            DataSet currentSheet = new DataSet();

            exceldataGrid.ItemsSource  = currentSheet.Tables[0].DefaultView;          

        private void closeAppBtn_Click(object sender, RoutedEventArgs e)
            Application App = Application.Current;

<Window x:Class="ExcelCookbookReader.MainWindow"
        Title="MainWindow" Height="380" Width="560">
    <StackPanel VerticalAlignment="Top">
        <WrapPanel Margin="5,5,5.4,5" Background="LightBlue" Height="35" >
            <Label Content="Excel File:" HorizontalAlignment="Left"/>
            <TextBox x:Name="excelFileTextBox" Margin="7,7,7,7" Width="411"/>
            <Button x:Name="openFileButton"  Click="openFileButton_Click" Margin="5,5,5,5" Width="35"  FontWeight="UltraBold" Content=" ... " RenderTransformOrigin="1.006,0.564"/>
        <WrapPanel Margin="5,5,5.4,5" Background="PaleGoldenrod" Height="35">
            <Label Content="Worksheets" HorizontalAlignment="Left"/>
            <ComboBox x:Name="worksheetsComboBox"  SelectionChanged="worksheetsComboBox_SelectionChanged" Margin="7,7,7,7" Width="446"/>
        <StackPanel Margin=" 10" Background="Red" Height="240" VerticalAlignment="Stretch">
            <DataGrid x:Name="exceldataGrid" Height="200" Margin="0,0,-0.4,0"/>
            <WrapPanel HorizontalAlignment="Right">
                <Button x:Name="closeAppBtn" Click="closeAppBtn_Click" Margin="7,10,20,7" Width="60" Content="Close" />
1 Year
Discussion Span
Last Post by ddanbe

Instead of line 48 to 54 in your codes you can use databinding to show your data. DataBinding is one of the beautiful part of WPF.


Thanks for the tip Shark_1! :) I'll have a look. I guess as the line lines now are this is "old" style programming?
As I'm practically a total noob with WPF, I was already happy to be able to translate to it and remove all the errors underway.


WPFs also can run on DirectX if I recall right. If you remember I was working on a program to transition images, I ended up using a WPF because of its storyboard objects.

The only thing I really hate about them, they are AWFUL when it comes to memory management. There are really no equivalents of dispose. I was loading in images (which you couldn't use the standard Images under the Drawing or Forms library), and had to write this converter to go between the two types. However, it was causing a horrible memory leak, I am talking gigs within mins. Had to write a try/finally at set the resource to null and call the Garbage Collector. Pretty tacky if you ask me.

(I've also got an annoying issue of them blowing a null error I STILL can find why, even though I thought I did)

I will admit though you can make forms look a lot nicer. I think it was built on a concept that a developer and designer could work in tandom and not step on each other's toes (or something along those lines).

Have you seen any issues with memory resources? Or annoying quarks


No weird things yet, I just started on a small scale. To get a little more grasp on WPF.

Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.