sheets_store 2.1.1

sheets_store: ^2.1.1 copied to clipboard

example/main.dart

import 'dart:convert';
import 'dart:io';

import 'package:sheets_store/sheets_store.dart';

Map<String, dynamic> readJsonFile(String filePath) {
  final input = File(filePath).readAsStringSync();
  final decoded = jsonDecode(input);
  return decoded;
}

void main() async {
  final client = await SheetsClient.fromServiceAccountCredentials(
    'ENTER YOUR SPREADSHEET ID HERE',
    readJsonFile('ENTER YOUR JSON CREDENTIALS FILE HERE'),
  );
  final testTable = SheetColumn<String>(
    column: 'A',
    sheetName: 'Sheet1',
    sheetsClient: client,
    decodeFunction: (rawValue) => jsonDecode(rawValue),
  );

  // Print an element in the column
  final firstRowElement = await testTable.at(0);
  print(firstRowElement);

  // Write to the column
  testTable.set(1, 'Hello World');
}