Paste from Excel to WPF DataGrid [duplicate]

Question

I have a DataGrid (called TheGrid) that I would like to implement copy and paste functionality on. The copy functionality works great but I don't know how to implement paste. Do I just need to get the data from the clipboard and parse myself?

The command bindings:

<Window.CommandBindings>
    <CommandBinding Command="Copy" Executed="CommandBinding_Executed" CanExecute="CommandBinding_CanExecute" />
    <CommandBinding Command="Paste" Executed="CommandBinding_Executed" CanExecute="CommandBinding_CanExecute" />
</Window.CommandBindings>

The menu items:

<MenuItem Header="{x:Static culture:TextResource.CopyMenuItem}" Command="Copy"/>
<MenuItem Header="{x:Static culture:TextResource.PasteMenuItem}" Command="Paste"/>

The code behind for CommandBinding_Executed:

private void CommandBinding_Executed(object sender, ExecutedRoutedEventArgs e)
{
    if(e.Command.Equals(ApplicationCommands.Copy))
    {
        // This works great, wow that was easy!
        ApplicationCommands.Copy.Execute(null, TheGrid);
    }
    else if (e.Command.Equals(ApplicationCommands.Paste))
    {
        //What do I do here? Is there an easy way to paste like there was for copy?
        // Or do I need to grab data using Clipboard.GetData and parse it myself?
    }
}

Community · Accepted Answer · 2017-05-23 12:19:16Z

8

It's not easy to do
You should parse clipboard data with ClipboardHelper
take a look at this question

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Jun 15, 2011 at 20:22

Navid Rahmani

8,0089 gold badges41 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

KrisTrip Over a year ago

Maybe I'm missing something but what namespace is ClipboardHelper in? I can't compile and am getting the perty red squiggle :-/

Navid Rahmani Over a year ago

look at the link in my answer

theMayer Over a year ago

Ahh, the days when a link-only answer was good enough. Thanks though!

Collectives™ on Stack Overflow

Paste from Excel to WPF DataGrid [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related