Method Run

internal/cmd/sheets_format.go:22–122

(ctx context.Context, flags *RootFlags)

}

func (c *SheetsFormatCmd) 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")
	}
	if strings.TrimSpace(c.FormatJSON) == "" {
		return usage("provide format JSON via --format-json")
	}

	var format sheets.CellFormat
	b, err := resolveInlineOrFileBytes(c.FormatJSON, stdinReader(ctx))
	if err != nil {
		return usagef("read --format-json: %v", err)
	}
	if err = sheetsformat.Decode(b, &format); err != nil {
		return usagef("invalid format JSON: %v", err)
	}

	formatFields := strings.TrimSpace(c.FormatFields)
	var formatJSONPaths []string
	if formatFields == "" {
		var inferErr error
		formatFields, formatJSONPaths, inferErr = sheetsformat.InferMask(b)
		if inferErr != nil {
			return sheetsFormatInputError(inferErr)
		}
	} else {
		if sheetsformat.HasBordersTypo(formatFields) {
			return usage(`invalid --format-fields: found "boarders"; use "borders"`)
		}
		normalizedFields, paths := sheetsformat.NormalizeMask(formatFields)
		if normalizedFields != "" {
			formatFields = normalizedFields
		}
		formatJSONPaths = paths
	}
	if err = sheetsformat.ApplyForceSendFields(&format, formatJSONPaths); err != nil {
		return usage(err.Error())
	}

	if dryRunErr := dryRunExit(ctx, flags, "sheets.format", map[string]any{
		"spreadsheet_id": spreadsheetID,
		"range":          rangeSpec,
		"fields":         formatFields,
		"format":         format,
	}); dryRunErr != nil {
		return dryRunErr
	}

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