如何在.net中更改google sheets api v4中范围的颜色

using Google.Apis.Auth.OAuth2;
using Google.Apis.Services;
using Google.Apis.Sheets.v4;
using Google.Apis.Sheets.v4.Data;

// 认证和授权
GoogleCredential credential = GoogleCredential.FromFile("path/to/credentials.json")
    .CreateScoped(SheetsService.Scope.Spreadsheets);
    
// 创建Google Sheets服务对象
SheetsService service = new SheetsService(new BaseClientService.Initializer()
{
    HttpClientInitializer = credential
});

// 定义要更改颜色的范围
string spreadsheetId = "your-spreadsheet-id";
string range = "Sheet1!A1:B2";

// 创建BatchUpdate请求
BatchUpdateSpreadsheetRequest batchUpdateRequest = new BatchUpdateSpreadsheetRequest();

// 创建UpdateCells请求
UpdateCellsRequest updateCellsRequest = new UpdateCellsRequest();
updateCellsRequest.Range = new GridRange()
{
    SheetId = 0,
    StartRowIndex = 0,
    EndRowIndex = 2,
    StartColumnIndex = 0,
    EndColumnIndex = 2
};

// 创建CellFormat对象，并设置颜色
CellFormat cellFormat = new CellFormat();
cellFormat.BackgroundColor = new Color()
{
    Red = 1.0f,
    Green = 0.0f,
    Blue = 0.0f
};

// 将CellFormat对象添加到UpdateCells请求
updateCellsRequest.Fields = "userEnteredFormat.backgroundColor";
updateCellsRequest.Rows = new List<RowData>()
{
    new RowData()
    {
        Values = new List<CellData>()
        {
            new CellData()
            {
                UserEnteredFormat = cellFormat
            },
            new CellData()
            {
                UserEnteredFormat = cellFormat
            }
        }
    },
    new RowData()
    {
        Values = new List<CellData>()
        {
            new CellData()
            {
                UserEnteredFormat = cellFormat
            },
            new CellData()
            {
                UserEnteredFormat = cellFormat
            }
        }
    }
};

// 将UpdateCells请求添加到BatchUpdate请求
batchUpdateRequest.Requests = new List<Request>()
{
    new Request()
    {
        UpdateCells = updateCellsRequest
    }
};

// 执行BatchUpdate请求，更新文档
service.Spreadsheets.BatchUpdate(batchUpdateRequest, spreadsheetId).Execute();