WPF SpreadSheetGear电子表单

private void ColumnsAndRowsTransformButton_OnClick(object sender, RoutedEventArgs e)
        {
            try
            {
                var workbook = viewModel.Workbook;
                var sheet = workbook.ActiveWorksheet;
                var ranges = sheet.ViewState.SelectionState.SelectedRanges;
                int insertRowsCount = 0;
                foreach (var range in ranges)
                {
                    if (range.IsSingleCell)
                    {
                        continue;
                    }
                    var firstRange=range.FromIndex;
                    //Foreach Rows
                    for (int i = 0; i < range.RowCount; i++)
                    {
                        int rowIndex = firstRange.RowIndex+i+ insertRowsCount;
                        int columnIndex = firstRange.ColumnIndex;

                        int currentRowAddRows = 0;
                        //赋值
                        for (int j = 1; j < range.ColumnCount; j++)
                        {
                            var cellValue =sheet.Cells[rowIndex, columnIndex + j].GetValue().Value;
                            if (string.IsNullOrEmpty(cellValue.RawValue))
                            {
                                continue;
                            }
                            sheet.Rows.Insert(rowIndex + 1+currentRowAddRows, 1);
                            
                            currentRowAddRows++;

                            sheet.Cells[rowIndex + j, columnIndex].SetValue(cellValue.RawValue);
                            sheet.Cells[rowIndex, columnIndex + j].SetValue("");
                        }
                        //本行单元格复制上行内容

                        int index = 0;
                        do
                        {
                            var upValue = sheet.Cells[rowIndex, index].GetValue().Value;
                            if (string.IsNullOrEmpty(upValue.RawValue) && index > 50)
                            {
                                break;
                            }

                            if (index != columnIndex)
                            {
                                for (int j = 0; j < currentRowAddRows; j++)
                                {
                                    sheet.Cells[rowIndex +1 + j, index].SetValue(upValue);
                                }
                            }
                            index++;
                        } while (true);

                        insertRowsCount += currentRowAddRows;
                    }
                        
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }