Install-Package Google.Apis.Sheets.v4
Install-Package Google.Apis.Auth

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

// 从JSON文件加载凭证
var credential = GoogleCredential.FromFile("credentials.json")
    .CreateScoped(SheetsService.Scope.Spreadsheets);

// 创建Sheets服务
var service = new SheetsService(new BaseClientService.Initializer()
{
    HttpClientInitializer = credential,
    ApplicationName = "Google Sheets API Demo"
});

// 电子表格ID和范围
string spreadsheetId = "your-spreadsheet-id";
string range = "Sheet1!A1:D10";

// 获取数据
var request = service.Spreadsheets.Values.Get(spreadsheetId, range);
var response = request.Execute();

// 处理数据
IList<IList<object>> values = response.Values;
if (values != null && values.Count > 0)
{
    foreach (var row in values)
    {
        Console.WriteLine(string.Join(", ", row));
    }
}
else
    Console.WriteLine("No data found.");

// 准备要写入的数据
var valueRange = new ValueRange();
valueRange.Values = new List<IList<object>> { new List<object> { "Hello", "World" } };

// 指定写入范围
string writeRange = "Sheet1!A1";

// 执行写入
var writeRequest = service.Spreadsheets.Values.Update(valueRange, spreadsheetId, writeRange);
writeRequest.ValueInputOption = SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum.USERENTERED;
var writeResponse = writeRequest.Execute();

Console.WriteLine($"Updated {writeResponse.UpdatedCells} cells.");

// 创建批量请求
var batchRequest = new BatchUpdateSpreadsheetRequest
{
    Requests = new List<Request>
    {
        new Request
        {
            UpdateCells = new UpdateCellsRequest
            {
                Start = new GridCoordinate
                {
                    SheetId = 0,
                    RowIndex = 0,
                    ColumnIndex = 0
                },
                Rows = new List<RowData>
                {
                    new RowData
                    {
                        Values = new List<CellData>
                        {
                            new CellData { UserEnteredValue = new ExtendedValue { StringValue = "Name" } },
                            new CellData { UserEnteredValue = new ExtendedValue { StringValue = "Age" } }
                        }
                    }
                },
                Fields = "userEnteredValue"
            }
        }
    }
};

// 执行批量请求
var batchResponse = service.Spreadsheets.BatchUpdate(batchRequest, spreadsheetId).Execute();