Avatar of craigdev
craigdev

asked on 

Setting the data object to the clipboard

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
Visual Basic.NET

Avatar of undefined
Last Comment
Bob Learned
ASKER CERTIFIED SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Sancler
Sancler

Have a look at this - "How to: Enable Users to Copy Multiple Cells to the Clipboard from the Windows Forms DataGridView Control".  It's in the Help Files.  Or on the net at

http://msdn2.microsoft.com/en-us/library/dec5efh1.aspx

Roger
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

I like Roger's idea, too, to let the DataGridView handle the clipboard operation.
Thanks, Roger dodger ;)

Bob
Visual Basic.NET
Visual Basic.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,

96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo