Delete Rows and Columns

DELETE /api/spreadsheet/deleterows

Input example (JSON)

{
"id": "some_id",
"filename": "test",
"extension": "xls",
"sheetindex": 0,
"sheetname": "Sheet1",
"startindex": 1,
"count": 2
}

Description: Deletes specified rows from a worksheet.

JSON fields

  • id - an identifier of a session to which the document has been loaded. This parameter's value is returned by the request used to create or load the document.

  • filename - a string value that specifies the file name of the document to which rows belong.

  • extension - a string value that specifies the file extension of the document to which rows belong. The supported file extensions are: OPENXML (XLSX), XLS and CSV.

  • sheetindex - a zero-based index of the worksheet to which rows belong.

  • sheetname - a string value that specifies the name of the worksheet to which rows belong.

  • startindex - a zero-based index of the first row to be deleted.

  • count - an integer value that specifies the number of rows to be deleted.


DELETE /api/spreadsheet/deletecolumns

Input example (JSON)

{
"id": "some_id",
"filename": "test",
"extension": "xls",
"sheetindex": 0,
"sheetname": "Sheet1",
"startindex": 1,
"count": 2
}

Description: Deletes specified columns from a worksheet.

JSON fields

  • id - an identifier of a session to which the document has been loaded. This parameter's value is returned by the request used to create or load the document.

  • filename - a string value that specifies the file name of the document to which columns belong.

  • extension - a string value that specifies the file extension of the document to which columns belong. The supported file extensions are: OPENXML (XLSX), XLS and CSV.

  • sheetindex - a zero-based index of the worksheet to which columns belong.

  • sheetname - a string value that specifies the name of the worksheet to which columns belong.

  • startindex - a zero-based index of the first deleted column.

  • count - an integer value that specifies the number of columns to be deleted.