Excel Drag and Drop

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am programming Excel from C#. I want users to be able to drag and drop onto
Excel and to be able to capture the drag drop events. Spcifically, I need to
know the cell the data is being dragged to and be able to program the
givefeedback, drag over and drag drop events from the C# interface.
 
Peter,

I too have been looking for a way to do drag and drop from my .NET
application into Excel. Like you I haven't found a solution. However I did
discover this work around. I hope it helps.

1. First when you call DoDragDrop(), plant a unique value into the data.
For example... DoDragDrop("{DragFromMyApp}:ThedataIAmDragging", Copy);

2. In Excel, handle the Workbook SheetChanged event. Check the data for you
unique value and then invoke your code. For example:

private Void Workbook1_SheetChanged(Object sh, Range Target)
If (Target.Value.StartsWith("{DragFromMyApp}") ) //Not VBA code -- C#
string data = Target.Value;
Target.Value = null;
// Call your code here
}
}

This will be perceived by the user as though you are customizing the drag
and drop. The only drawback is that you will not be able to give feedback.
I'm still not sure how to do this.

Enjoy!
 
Back
Top