excel复制到datagridview

DataObject o = (DataObject) Clipboard.GetDataObject();
           if (o.GetDataPresent(DataFormats.Text))
           {
               int rowOfInterest = DataGridView.CurrentCell.RowIndex;
               string[] selectedRows = Regex.Split(o.GetData(DataFormats.Text).ToString(  ).TrimEnd( "\r\n".ToCharArray() ), "\r\n");

               if (selectedRows == null || selectedRows.Length == 0)
                   return;

               foreach (string row in selectedRows)
               {                   
                   if (rowOfInterest >= DataGridView.Rows.Count)
                       break;

                   try
                   {
                       string[] data = Regex.Split(row, "\t");
                       int col = DataGridView.CurrentCell.ColumnIndex;

                       foreach (string ob in data)
                       {
                           if (col >= DataGridView.Columns.Count)
                               break;
                           if (ob!=null)
                               DataGridView[col, rowOfInterest].Value = Convert.ChangeType( ob, DataGridView[col,rowOfInterest].ValueType );
                           col++;
                       }
                   }
                   catch (Exception enterException)
                   {
                         //do something here
                   }
                   rowOfInterest++;
               }
           }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值