troubleshooting Question

Setting the data object to the clipboard

Avatar of craigdev
craigdev asked on
Visual Basic.NET
3 Comments1 Solution411 ViewsLast Modified:
I want to copy the values from any selected cells in a DataGridView to the clipboard. First of all is there an easy way to do that?

If not what should I use as the Format string in order to set an object(,) to the My.Computer.Clipboard.SetData function?


    Public Sub CopySelectedCellsToClipboard(ByVal dgv As DataGridView)
        Dim selectedCells As DataGridViewSelectedCellCollection = dgv.SelectedCells

        Dim firstCellCoords() As Integer = GetFirstSelectedCellCoOrds(selectedCells)
        Dim lastCellCoords() As Integer = GetFirstSelectedCellCoOrds(selectedCells)

        Dim copyData(lastCellCoords(0) - firstCellCoords(0), lastCellCoords(1) - firstCellCoords(1)) As Object

        For Each cell As DataGridViewCell In selectedCells
            copyData(cell.RowIndex - firstCellCoords(0), cell.ColumnIndex - firstCellCoords(1)) = cell.Value
        Next

        My.Computer.Clipboard.SetData(???Format??? ,copyData)
    End Sub
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros