Code for deleting row in google sheet not working
Jim Kardach
GTLRRuntimeCommon: jsonFromAPIObject expected class 'GTLRSheets_Request' instead got 'GTLRSheets_DeleteDimensionRequest'
- (
void
)
deleteRow
:(
int
) row {
GTLRSheets_DeleteDimensionRequest *delDimReq = [[
GTLRSheets_DeleteDimensionRequest alloc
]
init
];
GTLRSheets_Request *sheetsRequest = [[
GTLRSheets_Request alloc
]
init
];
sheetsRequest. deleteDimension
= delDimReq;
GTLRSheets_DimensionRange *range = [[
GTLRSheets_DimensionRange alloc
]
init
];
range. dimension
= @"ROWS"
;
range. sheetId
= 0
;
range.
startIndex
=
@(
row
)
;
// row to delete inclusive
range.
endIndex
=
@(
row +
1)
;
// row to delete exclusive
delDimReq. range
= range;
GTLRSheets_BatchUpdateSpreadsheetRequest *request = [[
GTLRSheets_BatchUpdateSpreadsheetRequest alloc
]
init
];
request.
includeSpreadsheetInResponse =
0
;
request.
responseIncludeGridData =
0
;
request. requests
= @[
delDimReq ]
;
//(GTLRSheets_BatchUpdateValuesRequest *)
GTLRSheetsQuery_SpreadsheetsBatchUpdate *query = [
GTLRSheetsQuery_SpreadsheetsBatchUpdate
queryWithObject
:( GTLRSheets_BatchUpdateSpreadsheetRequest
*) request
spreadsheetId
: ACT_SHEET_ID
];
[ self
. sheetService
executeQuery
:query
completionHandler
:^( GTLRServiceTicket
*ticket,
GTLRSheets_ValueRange
*result,
NSError
*error) {
if
(error == nil
) {
[ self
readLog
];
} else
{
NSString
*message = [ NSString
stringWithFormat
: @"Error getting update sheet data: %@\n"
, error. localizedDescription
];
[ self
showAlert
: @"Error"
message
:message];
}
}];
}
..
Jim Kardach
