Get List of Type-Specific Drawing Objects

GET /api/spreadsheet/getpictures?id&filename&extension&sheetindex&sheetname&startrowindex&startcolumnindex&endrowindex&endcolumnindex&objectindex&scale&picturetype

Description: Gets a list of type-specific drawing objects belonging to the specified worksheet.

Parameters

  • 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 document's file name without the extension.

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

  • sheetindex - a zero-based index of the worksheet.

  • sheetname - a name of the worksheet.

  • startrowindex - a zero-based index of the first row that binds an area from which drawing objects are returned.

  • startcolumnindex - a zero-based index of the first column that binds the area from which drawing objects are returned.

  • endrowindex - a zero-based index of the last row that binds an area from which drawing objects are returned.

  • endcolumnindex - a zero-based index of the last column that binds the area from which drawing objects are returned.

  • objectindex - a zero-based index of the drawing object. Default value is 0. You use this parameter if there are several drawing objects in a cell and you don't need to get all of them.

  • scale - a nullable float value that specifies the scale of returned drawing objects. Default value is 1 (objects are not scaled). Note that the scale of each object is saved between sessions.

  • picturetype - a string value that specifies the type of required objects. Available types are:

    1. Picture

    2. Chart

    3. Shape

    4. ConnectionShape

    5. GroupShape