通过Java API V4查找和替换google sheet中的值

import com.google.api.client.auth.oauth2.Credential;
import com.google.api.client.googleapis.auth.oauth2.GoogleCredential;
import com.google.api.client.googleapis.javanet.GoogleNetHttpTransport;
import com.google.api.client.http.HttpTransport;
import com.google.api.client.json.JsonFactory;
import com.google.api.client.json.jackson2.JacksonFactory;
import com.google.api.services.sheets.v4.Sheets;
import com.google.api.services.sheets.v4.SheetsScopes;
import com.google.api.services.sheets.v4.model.*;

import java.io.IOException;
import java.security.GeneralSecurityException;
import java.util.Arrays;
import java.util.List;

public class GoogleSheetUtils {
    private static final String APPLICATION_NAME = "Your Application Name";
    private static final JsonFactory JSON_FACTORY = JacksonFactory.getDefaultInstance();
    private static final List<String> SCOPES = Arrays.asList(SheetsScopes.SPREADSHEETS);

    public static Sheets getSheetsService() throws IOException, GeneralSecurityException {
        HttpTransport httpTransport = GoogleNetHttpTransport.newTrustedTransport();
        Credential credential = GoogleCredential.fromStream(GoogleSheetUtils.class.getResourceAsStream("/path/to/service-account-key.json"))
                .createScoped(SCOPES);
        return new Sheets.Builder(httpTransport, JSON_FACTORY, credential)
                .setApplicationName(APPLICATION_NAME)
                .build();
    }

    public static void findAndReplaceValue(String spreadsheetId, String sheetName, String searchValue, String replaceValue) throws IOException, GeneralSecurityException {
        Sheets sheetsService = getSheetsService();

        // Retrieve the sheet ID
        Spreadsheet spreadsheet = sheetsService.spreadsheets().get(spreadsheetId).execute();
        List<Sheet> sheets = spreadsheet.getSheets();
        String sheetId = null;
        for (Sheet sheet : sheets) {
            if (sheet.getProperties().getTitle().equals(sheetName)) {
                sheetId = sheet.getProperties().getSheetId().toString();
                break;
            }
        }

        // Find and replace the value
        FindReplaceRequest findReplaceRequest = new FindReplaceRequest()
                .setFind(searchValue)
                .setReplacement(replaceValue)
                .setMatchCase(true);
        Request request = new Request()
                .setFindReplace(findReplaceRequest);
        BatchUpdateSpreadsheetRequest batchUpdateRequest = new BatchUpdateSpreadsheetRequest()
                .setRequests(Arrays.asList(new Request[] { request }));
        sheetsService.spreadsheets().batchUpdate(spreadsheetId, batchUpdateRequest).execute();
    }

    public static void main(String[] args) {
        try {
            String spreadsheetId = "your-spreadsheet-id";
            String sheetName = "Sheet1";
            String searchValue = "search-value";
            String replaceValue = "replace-value";

            findAndReplaceValue(spreadsheetId, sheetName, searchValue, replaceValue);
        } catch (IOException | GeneralSecurityException e) {
            e.printStackTrace();
        }
    }
}