selectRangeWithString method

List<List<Data?>?> selectRangeWithString(
  1. String range
)

returns 2-D dynamic List of the sheet cell data in that range.

Ex. selectRange('D8:H12'); or selectRange('D8');

Implementation

List<List<Data?>?> selectRangeWithString(String range) {
  List<List<Data?>?> _selectedRange = <List<Data?>?>[];
  if (!range.contains(':')) {
    var start = CellIndex.indexByString(range);
    _selectedRange = selectRange(start);
  } else {
    var rangeVars = range.split(':');
    var start = CellIndex.indexByString(rangeVars[0]);
    var end = CellIndex.indexByString(rangeVars[1]);
    _selectedRange = selectRange(start, end: end);
  }
  return _selectedRange;
}