-2

I want to make a 1 column data grid in a windows form where I can copy paste data from an excel sheet.

I am able to create the data grid using visual studio but ctrl+c &V is not working while copying data from excel sheet.

-Sa

leppie
  • 115,091
  • 17
  • 196
  • 297
Sarik
  • 1
  • 1
  • 1
    Of course CTRL+C and CTRL+V is not going to work. You need to define event handlers for that. The DataGrid is not going to do this for you automagically. – Camilo Terevinto Jan 08 '16 at 19:07

1 Answers1

1

  1. See this to implement Ctrl+V shortcut.

  2. Use 

    string txt = Clipboard.GetText();

    to get the text from the Clipboard.

  3. Excel will provide tab-separated values for each cell in the row, while rows are separated by \r\n. Insert it into your grid as you like.

Community
  • 1
  • 1
Vlad Feinstein
  • 10,960
  • 1
  • 12
  • 27