Update Data

[rohit0700]

How to update existing sheet information. can u please help.

[Dikril01]

`import 'package:googleapis/sheets/v4.dart' as sheets;
import 'package:googleapis_auth/auth_io.dart';

void updateSheetData() async {
final credentials = ServiceAccountCredentials.fromJson({
// Load your credentials here
"private_key": "YOUR_PRIVATE_KEY",
"client_email": "YOUR_CLIENT_EMAIL",
"client_id": "YOUR_CLIENT_ID",
});

final client = await clientViaServiceAccount(credentials, [
// The Google Sheets API scope
sheets.SheetsApi.spreadsheetsScope,
]);

final spreadsheetId = 'YOUR_SPREADSHEET_ID';
final range = 'Sheet1!A1'; // Example: Updating cell A1
final value = 'Updated Value';

final valueRange = sheets.ValueRange()..values = [[value]];

final request = sheets.SpreadsheetsValuesResource.UpdateRequest(
valueRange,
spreadsheetId,
range,
valueInputOption: 'USER_ENTERED',
);

await client.sheets.values.update(request);
}`