Exemple #1
0
        /// <summary>
        /// Get information from a range in a spreadsheet
        /// </summary>
        /// <param name="spreadSheetId">Source spreadsheet ID</param>
        /// <param name="readRange">Range with information</param>
        /// <returns>Requested information</returns>
        /// <exception cref="AccessDeniedException">Thrown when had problem with there was an access problem with Google Drive</exception>
        private async Task <IList <IList <object> > > ReadInfoAsync(string spreadSheetId, string readRange)
        {
            try
            {
                var response = await _service.Spreadsheets.Values.
                               Get(spreadSheetId, readRange).ExecuteAsync();

                return(response?.Values);
            }
            catch (Exception e)
            {
                throw AccessDeniedException.CreateException(e);
            }
        }
Exemple #2
0
 /// <summary>
 /// Write information to a range in a spreadsheet
 /// </summary>
 /// <param name="info">Information to write</param>
 /// <param name="spreadSheetId">Source spreadsheet ID</param>
 /// <param name="writeRange">Range to write</param>
 /// <exception cref="AccessDeniedException">Thrown when had problem with there was an access problem with Google Drive</exception>
 private async Task WriteInfoAsync(IList <IList <object> > info, string spreadSheetId, string writeRange)
 {
     try
     {
         var valueRange = new ValueRange {
             Values = info
         };
         var update = _service.Spreadsheets.Values.Update(valueRange, spreadSheetId, writeRange);
         update.ValueInputOption = SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum.USERENTERED;
         await update.ExecuteAsync();
     }
     catch (Exception e)
     {
         throw AccessDeniedException.CreateException(e);
     }
 }