Is it possible to paste Excel / CSV data from clipboard to DataGridView in C# ?

Question

I use DataGridView control to manage a simple dictionary (several columns and a few hundred rows). DataGridView functionality is almost sufficient. I can add new rows, modify values and copy data from it to Excel. One thing I cannot do is to copy data from Excel to my control. Is it possible with some properties? Or is some code required to do this?

Answer 1

Yes you can!

Take a look at some of the code here and see if that helps.

Answer 2

You can read the excel sheet to a dataset then bind the dataset to the grid. I think you should be able to make your amendments then write out to excel again when finished editing.