Java Sheets类代码示例

import com.google.api.services.sheets.v4.Sheets; //导入依赖的package包/类
private Sheets authorize() {
  try {
    InputStream in = new FileInputStream(new File(System.getenv("GOOGLE_OATH2_CREDENTIALS")));
    JsonFactory factory = new JacksonFactory();
    GoogleClientSecrets clientSecrets =
        GoogleClientSecrets.load(factory, new InputStreamReader(in, Charset.defaultCharset()));
    HttpTransport transport = GoogleNetHttpTransport.newTrustedTransport();
    FileDataStoreFactory dataStoreFactory =
        new FileDataStoreFactory(new File(dataStoreDirectory));
    List<String> scopes = Collections.singletonList(SheetsScopes.SPREADSHEETS);
    GoogleAuthorizationCodeFlow flow =
        new GoogleAuthorizationCodeFlow.Builder(transport, factory, clientSecrets, scopes)
            .setAccessType("offline")
            .setDataStoreFactory(dataStoreFactory)
            .build();
    Credential credential =
        new AuthorizationCodeInstalledApp(flow, new LocalServerReceiver()).authorize("user");
    return new Sheets.Builder(transport, factory, credential)
        .setApplicationName(APPLICATION_NAME)
        .build();
  } catch (Exception e) {
    return null;
  }
}
 

import com.google.api.services.sheets.v4.Sheets; //导入依赖的package包/类
@NotNull
public final Sheets getSheetsService() {
    @NotNull Sheets service = (Sheets) cacheClients.computeIfAbsent(Sheets.class,
            (clazz) ->
                    new Sheets.Builder(
                            secureHttpTransport(),
                            JacksonFactory.getDefaultInstance(),
                            getCredential())

                            .setApplicationName(EventManager.getInstance().getName())
                            .setSheetsRequestInitializer(new SheetsRequestInitializer(GoogleAPIToken.value()))
                            .setGoogleClientRequestInitializer(new SheetsRequestInitializer(GoogleAPIToken.value()))
                            .build());

    Timers.cacheCleanUpTimer().schedule(cacheClients, Sheets.class, service, 30, TimeUnit.MINUTES);
    return service;
}
 

import com.google.api.services.sheets.v4.Sheets; //导入依赖的package包/类
/**
 * Add new line in the GoogleSpreadSheet at a specific line
 * 	
 * @param id of the Google SpreadSheet
 * @param line to add
 * @param number of the line
 * @throws Exception 
 *  
 */
public static void AddLineSpreadSheet(String spreadsheetId, String[] line, Integer numberOfLine) throws Exception {   

	Sheets service = getSheetsService();

	List<Request> requests = new ArrayList<>();

	List<CellData> values = new ArrayList<>();

	for (int i=0;i<line.length;i++)
	{
		values.add(new CellData()
				.setUserEnteredValue(new ExtendedValue()
						.setStringValue(line[i].toString())
						));
	}

	requests.add(new Request()
			.setUpdateCells(new UpdateCellsRequest()
					.setStart(new GridCoordinate()
							.setSheetId(0)
							.setRowIndex(numberOfLine)
							.setColumnIndex(0))
					.setRows(Arrays.asList(
							new RowData().setValues(values)))
					.setFields("userEnteredValue,userEnteredFormat.backgroundColor")));

	BatchUpdateSpreadsheetRequest batchUpdateRequest = new BatchUpdateSpreadsheetRequest()
			.setRequests(requests);
	service.spreadsheets().batchUpdate(spreadsheetId, batchUpdateRequest)
	.execute();
}
 

import com.google.api.services.sheets.v4.Sheets; //导入依赖的package包/类
/**
 * Build and return an authorized Sheets API client service.
 * @return an authorized Sheets API client service
 * @throws Exception 
 */
public static Sheets getSheetsService() throws Exception {
	Credential credential = authorize();
	return new Sheets.Builder(HTTP_TRANSPORT, JSON_FACTORY, setHttpTimeout(credential))
			.setApplicationName(APPLICATION_NAME)
			.build();
}
 

import com.google.api.services.sheets.v4.Sheets; //导入依赖的package包/类
/**
 * Create Google Spreadsheet
 * 
 * @param filename
 * @throws Exception
 */
public static void createGoogleSpreadsheet(String filename) throws Exception{
	Sheets service = getSheetsService();

	SpreadsheetProperties properties = new SpreadsheetProperties()
			.setTitle(filename);
	Spreadsheet test = new Spreadsheet()
			.setProperties(properties)
			.setSpreadsheetId("jhipster");

	service.spreadsheets().create(test)
	.execute();
}
 

import com.google.api.services.sheets.v4.Sheets; //导入依赖的package包/类
@Provides
static Sheets provideSheets(
    HttpTransport transport,
    JsonFactory jsonFactory,
    @Config("projectId") String projectId,
    GoogleCredential credential) {
  return new Sheets.Builder(transport, jsonFactory, credential.createScoped(SCOPES))
      .setApplicationName(projectId)
      .build();
}
 

import com.google.api.services.sheets.v4.Sheets; //导入依赖的package包/类
private Sheets getSheetsService(GoogleConnection gc) throws IOException {
	if (this.sheetsService == null) {
		return new Sheets.Builder(Global.HTTP_TRANSPORT, Global.JSON_FACTORY, gc.getCredentials())
				.setApplicationName(appName).build();
	} else {
		return this.sheetsService;
	}
}
 

import com.google.api.services.sheets.v4.Sheets; //导入依赖的package包/类
@Override
public List<List<Object>> readTable(GoogleConnection connection)  throws IOException {
	Sheets service = getSheetsService(connection);
	return readTable(service, spreadsheetId, sheetName);
}