DataGridView剪切板的操作（国外英文资料）.docVIP

DataGridView剪切板的操作（国外英文资料） The operation of the DataGridView clipboard The datagridview.clipboardcopymode property is set to the DataGridViewClipboardCopyMode.disable, when Ctrl + C is pressed, the content of the selected cell is copied to the system clipboard. Format: Text, UnicodeText, Html, CommaSeparatedValue. You can paste it directly into Excel. ClipboardCopyMode can also set the Header section to be copied: EnableAlwaysIncludeHeaderText copies the Header section, EnableWithoutHeaderText does not copy. The default is EnableWithAutoHeaderText, and the Header will be copied if you select it. 1) programmatically implement a copy of the clipboard The clipboard.setdataobject (datagridview1.getclipboardcontent ()) 2) DataGridView data paste It is easier to make a copy of the clipboard, but it is harder to implement the direct pasting of the DataGridView. When Ctrl + V is pressed and pasted, the DataGridView does not provide a method and can only be implemented by itself. The following is a simple example code that will paste the copy data into the area where the cell begins. [VB.NET] The current cells choice of the judgment If DataGridView1. CurrentCell Is Nothing Then The Return End the If The Dim insertRowIndex As Integer = datagridview1.currentcell.rowindex get the content of the clipboard and split it by line Dim pasteText As String = clipboard.gettext () If the String. IsNullOrEmpty (pasteText) Then The Return End the If PasteText = pasteText. Replace (vbCrLf, vbLf) PasteText = pasteText. Replace (vbCr, vbLf) Pastetext.trimend () {vbLf}) Dim lines As String () = pasteText. Split (vbLf) Dim isHeader As Boolean = True For Each line As String In lines is it the column head If isHeader Then IsHeader = False The Else Tab split the data Dim vals As String () = line. Split (controlchars.tab) determine whether the number of columns is uniform If vals. Length -1 datagridview1.columncount Then Throw New ApplicationException ( paste the number of columns is incorrect. )