unMerge method

void unMerge(String unmergeCells)

unMerge the merged cells.

   var sheet = 'DesiredSheet';
   List<String> spannedCells = excel.getMergedCells(sheet);
   var cellToUnMerge = "A1:A2";
   excel.unMerge(sheet, cellToUnMerge);

Implementation

void unMerge(String unmergeCells) {
  if (_spannedItems.isNotEmpty &&
      _spanList.isNotEmpty &&
      _spannedItems.contains(unmergeCells)) {
    List<String> lis = unmergeCells.split(RegExp(r":"));
    if (lis.length == 2) {
      bool remove = false;
      CellIndex start = CellIndex.indexByString(lis[0]),
          end = CellIndex.indexByString(lis[1]);
      for (int i = 0; i < _spanList.length; i++) {
        _Span? spanObject = _spanList[i];
        if (spanObject == null) {
          continue;
        }

        if (spanObject.columnSpanStart == start.columnIndex &&
            spanObject.rowSpanStart == start.rowIndex &&
            spanObject.columnSpanEnd == end.columnIndex &&
            spanObject.rowSpanEnd == end.rowIndex) {
          _spanList[i] = null;
          remove = true;
        }
      }
      if (remove) {
        _cleanUpSpanMap();
      }
    }
    _spannedItems.remove(unmergeCells);
    _excel._mergeChangeLookup = sheetName;
  }
}