单列 DGV 接受剪贴板数据

我已经设置了一个窗口表单。目前，它有一个链接到SQL Server数据库中的单个表的DataGridView。我可以浏览表中的当前数据。

如何进行设置，以便用户可以将 Excel 工作表中的单列数据复制并粘贴到 DGV 中？

如果在 Excel 中我在 A1 中有"x"，在 A2 中有"y"，那么这在粘贴到 DGV 中时必须保留行数，即在本例中它仍然超过 2 行

我试图从代码项目中改编以下内容。如果在线失败 如果(oCell.Value.ToString() != sCells[i])带有NullReferenceException was unhandled 我做错了什么？

    private void uxChargeBackDataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
    {
        PasteClipboard();
       //uxChargeBackDataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = Clipboard.GetText();
    }

    private void PasteClipboard()
    {
        try
        {
            string s = Clipboard.GetText();
            string[] lines = s.Split(''n');
            int iFail = 0, iRow = uxChargeBackDataGridView.CurrentCell.RowIndex;
            int iCol = uxChargeBackDataGridView.CurrentCell.ColumnIndex;
            DataGridViewCell oCell;
            foreach (string line in lines)
            {
                if (iRow < uxChargeBackDataGridView.RowCount && line.Length > 0)
                {
                    string[] sCells = line.Split(''t');
                    for (int i = 0; i < sCells.GetLength(0); ++i)
                    {
                        if (iCol + i < this.uxChargeBackDataGridView.ColumnCount)
                        {
                            oCell = uxChargeBackDataGridView[iCol + i, iRow];
                            if (!oCell.ReadOnly)
                            {
                                if (oCell.Value.ToString() != sCells[i])
                                {
                                    oCell.Value = Convert.ChangeType(sCells[i],
                                                          oCell.ValueType);
                                    oCell.Style.BackColor = Color.Tomato;
                                }
                                else
                                    iFail++;
                                //only traps a fail if the data has changed 
                                //and you are pasting into a read only cell
                            }
                        }
                        else
                        { break; }
                    }
                    iRow++;
                }
                else
                { break; }
                if (iFail > 0)
                    MessageBox.Show(string.Format("{0} updates failed due" +
                                    " to read only column setting", iFail));
            }
        }
        catch (FormatException)
        {
            MessageBox.Show("The data you pasted is in the wrong format for the cell");
            return;
        }
    }  

private void gridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e) 
{
    gridView.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = Clipboard.GetText();
}

private void form1_KeyUp(object sender, KeyEventArgs e)
{
    //if user clicked Shift+Ins or Ctrl+V (paste from clipboard)
    if ((e.Shift && e.KeyCode == Keys.Insert) || (e.Control && e.KeyCode == Keys.V))
    {
       /// your paste copy/paste code here
    }
}