getRawRows method

Future<List<List<Object?>>> getRawRows({
  1. bool forceRefresh = false,
})

Busca os dados puros (com cabeçalho) da planilha usando cache se configurado

Implementation

Future<List<List<Object?>>> getRawRows({bool forceRefresh = false}) async {
  bool isCacheValid =
      _cachedRawRows != null &&
      _lastFetch != null &&
      (cacheTime.inMilliseconds > 0
          ? DateTime.now().difference(_lastFetch!) < cacheTime
          : true);

  if (!forceRefresh && isCacheValid) {
    return _cachedRawRows!;
  }

  final response = await api.spreadsheets.values.get(
    spreadsheetId,
    '$sheetName!A:Z',
  );
  final rows = response.values ?? [];

  _cachedRawRows = rows;
  _lastFetch = DateTime.now();
  return rows;
}