| 71 | } |
| 72 | |
| 73 | func DecodeRanges(data []byte) ([]*sheets.ValueRange, error) { |
| 74 | var ranges []*sheets.ValueRange |
| 75 | if err := json.Unmarshal(data, &ranges); err != nil { |
| 76 | return nil, invalidf("invalid JSON data: %v", err) |
| 77 | } |
| 78 | |
| 79 | if len(ranges) == 0 { |
| 80 | return nil, invalidf("--data-json must contain at least one value range") |
| 81 | } |
| 82 | |
| 83 | for i, valueRange := range ranges { |
| 84 | if valueRange == nil { |
| 85 | return nil, invalidf("--data-json range %d is null", i) |
| 86 | } |
| 87 | |
| 88 | valueRange.Range = strings.ReplaceAll(valueRange.Range, `\!`, "!") |
| 89 | if strings.TrimSpace(valueRange.Range) == "" { |
| 90 | return nil, invalidf("--data-json range %d has empty range", i) |
| 91 | } |
| 92 | |
| 93 | if len(valueRange.Values) == 0 { |
| 94 | return nil, invalidf("--data-json range %d has empty values", i) |
| 95 | } |
| 96 | } |
| 97 | |
| 98 | return ranges, nil |
| 99 | } |
| 100 | |
| 101 | func invalidf(format string, args ...any) error { |
| 102 | return ValidationError(fmt.Sprintf(format, args...)) |