Insert Rows and Columns

PUT /api/spreadsheet/insertrows

Input example (JSON)

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

Description: Inserts new rows to 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 inserted.

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

  • formatmode - specifies how to format new rows. Available format modes are:

    1. FormatAsPrevious - inserted rows are formated like the row above
    2. FormatAsNext - inserted rows are formated like the row below
    3. ClearFormat - inserted rows are not formated

PUT /api/spreadsheet/insertcolumns

Input example (JSON)

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

Description: Inserts new columns to 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 inserted column.

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

  • formatmode - specifies how to format new columns. Available format modes are:

    1. FormatAsPrevious - inserted columns are formated like the column on the left
    2. FormatAsNext - inserted columns are formated like the column on the right
    3. ClearFormat - inserted columns are not formated