ODBC guide

Delete Sheet Columns

Deletes columns D and E (column index 3 to 4, zero-based) from the specified sheet tab using the delete_sheet_rows_columns endpoint.

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

SELECT * FROM delete_sheet_rows_columns
WITH(
  Dimension='COLUMNS',
  StartIndex='3',
  EndIndex='5',
  TabId='0',
  SpreadSheetId='1az2H8ZYk7BvjddVTqPR-LfDjX9IRpIpjCDpFPe9EzkU'
)