ODBC guide

Delete Sheet Rows

Deletes rows 5 and 6 (row index 4 to 5, zero-based) from the specified sheet tab using the delete_sheet_rows_columns endpoint.

Set Dimension='ROWS' and specify StartIndex and EndIndex for the range to delete.

SELECT * FROM delete_sheet_rows_columns
WITH(
  Dimension='ROWS',
  StartIndex='4',
  EndIndex='6',
  TabId='0',
  SpreadSheetId='1az2H8ZYk7BvjddVTqPR-LfDjX9IRpIpjCDpFPe9EzkU'
)