Method Run

internal/cmd/sheets.go:183–297

(ctx context.Context, flags *RootFlags)

}

func (c *SheetsUpdateCmd) Run(ctx context.Context, flags *RootFlags) error {
	u := ui.FromContext(ctx)

	spreadsheetID := normalizeGoogleID(strings.TrimSpace(c.SpreadsheetID))
	rangeSpec := cleanRange(c.Range)
	if spreadsheetID == "" {
		return usage("empty spreadsheetId")
	}
	if strings.TrimSpace(rangeSpec) == "" {
		return usage("empty range")
	}

	var values [][]interface{}
	switch {
	case strings.TrimSpace(c.ValuesJSON) != "":
		b, err := resolveInlineOrFileBytes(c.ValuesJSON, stdinReader(ctx))
		if err != nil {
			return usagef("read --values-json: %v", err)
		}

		values, err = sheetsvalues.DecodeStrict(b)
		if err != nil {
			return sheetsValuesPlannerError(err)
		}
	case len(c.Values) > 0:
		values = sheetsvalues.ParseArgs(c.Values)
	default:
		return usage("provide values as args or via --values-json")
	}

	valueInputOption := strings.TrimSpace(c.ValueInput)
	if valueInputOption == "" {
		valueInputOption = sheetsDefaultValueInputOption
	}

	if err := dryRunExit(ctx, flags, "sheets.update", map[string]any{
		"spreadsheet_id":          spreadsheetID,
		"range":                   rangeSpec,
		"values":                  values,
		"value_input_option":      valueInputOption,
		"copy_validation_from":    strings.TrimSpace(c.CopyValidationFrom),
		"copy_validation_to_hint": "updatedRange",
		"fail_on_formula_error":   c.FailOnFormulaError,
	}); err != nil {
		return err
	}

	account, err := requireAccount(flags)
	if err != nil {
		return err
	}

	svc, err := sheetsService(ctx, account)
	if err != nil {
		return err
	}

	vr := &sheets.ValueRange{