public static void PasteTable(GridView gridView)
        {
            gridView.ClearSorting();
            int originalFocusedVisibleColIndex = gridView.FocusedColumn.VisibleIndex;
            string[] clipboardTextLines = XtraGridHelper.ClipboardTextLines;

            // paste data from clipboard into row cells
            foreach (string line in clipboardTextLines)
            {
                if (line != string.Empty)
                {
                    string[] lineFragments = line.Split('\t');
                    foreach (string lineFragment in lineFragments)
                    {
                        // 'paste' in new value
                        gridView.ShowEditor();
                        if (gridView.ActiveEditor != null)
                        {
                            gridView.ActiveEditor.Text = lineFragment.Trim();
                            gridView.CloseEditor();
                        }

                        // move to next visible column if next visible column exists
                        if (gridView.FocusedColumn.VisibleIndex < gridView.VisibleColumns.Count - 1)
                        {
                            gridView.FocusedColumn = gridView.VisibleColumns[gridView.FocusedColumn.VisibleIndex + 1];
                        }
                        else
                        {
                            break; //stop 'pasting' in focused row
                        }

                        
                    }
                    // move to next row
                    if (gridView.FocusedRowHandle < gridView.RowCount - 1)
                    {
                        gridView.MoveNext();
                        gridView.FocusedColumn = gridView.VisibleColumns[originalFocusedVisibleColIndex];
                    }
                    else
                    {
                        break; //stop 'pasting' in the grid
                       
                    }

                   
                }
            }
        }

                XtraGridHelper.PasteTable(gridViewKomplekt);
                SendKeys.Send("{Esc}");