Copy DataGridView contents to clipboard

Question

Hi

I want to copy the contents of a DataGridView and paste in in Excel. I tried

         myDataGrid.SelectAll();
         DataObject dataObj = myDataGrid.GetClipboardContent();
         Clipboard.SetDataObject(dataObj, true)

But this just pastes nothing

Any suggestions?

Thanks

Answer 1

Have you added this line?

myDataGrid.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;

Take a look at this MSDN article for a working sample.