C# (CSharp) Utils.A1ToRowIndex Exemples

Exemple #1

        public void Delete()
        {
            var uri = string.Format("https://sheets.googleapis.com/v4/spreadsheets/{0}:batchUpdate", this._spreadsheetId);

            var request = this._connector.CreateRequest(uri);

            var index = Utils.A1ToRowIndex(this._range);

            var payload = JsonConvert.SerializeObject(new
            {
                requests = new
                {
                    deleteDimension = new
                    {
                        range = new
                        {
                            sheetId    = this._worksheetId,
                            dimension  = "ROWS",
                            startIndex = index - 1,
                            endIndex   = index,
                        }
                    }
                }
            });

            var response = new ResponseValidator(this._connector.Send(request, HttpMethod.Post, payload));

            response
            .Status(HttpStatusCode.OK);
        }