/// <summary> /// Connect to google-spreadsheet with the specified account and password /// then query cells and call the given callback. /// </summary> private void DoCellQuery(OnEachCell onCell) { // first we need to connect to the google-spreadsheet to get all the first row of the cells // which are used for the properties of data class. var client = new DatabaseClient("", ""); if (string.IsNullOrEmpty(machine.SpreadSheetName)) { return; } if (string.IsNullOrEmpty(machine.WorkSheetName)) { return; } string error = string.Empty; var db = client.GetDatabase(machine.SpreadSheetName, ref error); if (db == null) { string message = string.Empty; if (string.IsNullOrEmpty(error)) { message = @"Unknown error."; } else { message = string.Format(@"{0}", error); } message += "\n\nOn the other hand, see 'GoogleDataSettings.asset' file and check the oAuth2 setting is correctly done."; EditorUtility.DisplayDialog("Error", message, "OK"); return; } // retrieves all cells var worksheet = ((Database)db).GetWorksheetEntry(machine.WorkSheetName); // Fetch the cell feed of the worksheet. CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink); var cellFeed = client.SpreadsheetService.Query(cellQuery); // Iterate through each cell, printing its value. foreach (CellEntry cell in cellFeed.Entries) { if (onCell != null) { onCell(cell); } } }
/// <summary> /// Connect to google-spreadsheet with the specified account and password /// then query cells and call the given callback. /// </summary> private void DoCellQuery(OnEachCell onCell) { // first we need to connect to the google-spreadsheet to get all the first row of the cells // which are used for the properties of data class. var client = new DatabaseClient("", ""); if (string.IsNullOrEmpty(machine.SpreadSheetName)) { return; } if (string.IsNullOrEmpty(machine.WorkSheetName)) { return; } var db = client.GetDatabase(machine.SpreadSheetName); if (db == null) { string message = string.Format(@"The given spreadsheet '{0}' or worksheet '{1}' does not exist. Note that the name is case sensitive.", machine.SpreadSheetName, machine.WorkSheetName); EditorUtility.DisplayDialog("Error", message, "OK"); return; } // retrieves all cells var worksheet = ((Database)db).GetWorksheetEntry(machine.WorkSheetName); // Fetch the cell feed of the worksheet. CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink); var cellFeed = client.SpreadsheetService.Query(cellQuery); // Iterate through each cell, printing its value. foreach (CellEntry cell in cellFeed.Entries) { if (onCell != null) { onCell(cell); } } }
/// <summary> /// Connect to google-spreadsheet with the specified account and password /// then query cells and call the given callback. /// </summary> private void DoCellQuery(OnEachCell onCell) { // first we need to connect to the google-spreadsheet to get all the first row of the cells // which are used for the properties of data class. var client = new DatabaseClient(GoogleDataSettings.Instance.Account, GoogleDataSettings.Instance.Password); if (string.IsNullOrEmpty(machine.SpreadSheetName)) { return; } if (string.IsNullOrEmpty(machine.WorkSheetName)) { return; } var db = client.GetDatabase(machine.SpreadSheetName); if (db == null) { Debug.LogError("The given spreadsheet does not exist."); return; } // retrieves all cells var worksheet = ((Database)db).GetWorksheetEntry(machine.WorkSheetName); // Fetch the cell feed of the worksheet. CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink); var cellFeed = client.SpreadsheetService.Query(cellQuery); // Iterate through each cell, printing its value. foreach (CellEntry cell in cellFeed.Entries) { if (onCell != null) { onCell(cell); } } }
/// <summary> /// Connect to google-spreadsheet with the specified account and password then query cells and /// call the given callback. /// </summary> private void DoCellQuery(OnEachCell onCell) { // first we need to connect to the google-spreadsheet to get all the first row of the cells // which are used for the properties of data class. var client = new DatabaseClient("", ""); if (string.IsNullOrEmpty(machine.SpreadSheetName)) return; if (string.IsNullOrEmpty(machine.WorkSheetName)) return; var db = client.GetDatabase(machine.SpreadSheetName); if (db == null) { Debug.LogError("The given spreadsheet does not exist."); return; } // retrieves all cells var worksheet = ((Database)db).GetWorksheetEntry(machine.WorkSheetName); // Fetch the cell feed of the worksheet. CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink); var cellFeed = client.SpreadsheetService.Query(cellQuery); // Iterate through each cell, printing its value. foreach (CellEntry cell in cellFeed.Entries) { if (onCell != null) onCell(cell); } }