aspose.cells

Class ShapeCollection

Represents all the shape in a worksheet/chart.

Property Getters/Setters Summary
functiongetCount()
functionget(index)
Gets the shape object at the specific index.
functionget(name)
Gets the shape object by the shape image
 
Method Summary
functionaddArc(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a ArcShape to the worksheet.
functionaddAutoShape(type, upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a AutoShape to the worksheet.
functionaddAutoShapeInChart(type, top, left, height, width)
Adds a AutoShape to the chart.
functionaddButton(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a Button to the worksheet.
functionaddCheckBox(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a checkbox to the worksheet.
functionaddComboBox(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a ComboBox to the worksheet.
functionaddCopy(sourceShape, upperLeftRow, top, upperLeftColumn, left)
Adds and copy a shape to the worksheet.
functionaddFreeFloatingShape(type, top, left, height, width, imageData, isOriginalSize)
Adds a free floating shape to the worksheet.Only applies for line/image shape.
functionaddGroupBox(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a GroupBox to the worksheet.
functionaddIcons(upperLeftRow, top, upperLeftColumn, left, height, width, imageByteData, compatibleImageData)
Adds svg image.
functionaddLabel(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a Label to the worksheet.
functionaddLabelInChart(top, left, height, width)
Adds a label to the chart.
functionaddLine(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a LineShape to the worksheet.
functionaddLinkedPicture(upperLeftRow, upperLeftColumn, height, width, sourceFullName)
Add a linked picture.
functionaddListBox(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a ListBox to the worksheet.
functionaddOleObject(upperLeftRow, top, upperLeftColumn, left, height, width, imageData)
functionaddOleObjectWithLinkedImage(upperLeftRow, upperLeftColumn, height, width, sourceFullName)
Add a linked picture.
functionaddOval(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a Oval to the worksheet.
functionaddRadioButton(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a RadioButton to the worksheet.
functionaddRectangle(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a RectangleShape to the worksheet.
functionaddScrollBar(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a ScrollBar to the worksheet.
functionaddShape(type, upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a Shape to the worksheet.
functionaddShapeInChart(type, placement, left, top, right, bottom)
Add a shape to chart .All unit is 1/4000 of chart area.
functionaddShapeInChart(type, placement, left, top, right, bottom, imageData)
Add a shape to chart .All unit is 1/4000 of chart area.
functionaddShapeInChartByScale(type, placement, left, top, right, bottom)
Add a shape to chart. All unit is percent scale of chart area.
functionaddShapeInChartByScale(type, placement, left, top, right, bottom, imageData)
Add a shape to chart .All unit is 1/4000 of chart area.
functionaddSpinner(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a Spinner to the worksheet.
functionaddSvg(upperLeftRow, top, upperLeftColumn, left, height, width, svgData, compatibleImageData)
Adds svg image.
functionaddTextBox(upperLeftRow, top, upperLeftColumn, left, height, width)
Adds a text box to the worksheet.
functionaddTextBoxInChart(top, left, height, width)
Adds a textbox to the chart.
functionaddTextEffect(effect, text, fontName, size, fontBold, fontItalic, upperLeftRow, top, upperLeftColumn, left, height, width)
Inserts a WordArt object.
functionaddTextEffectInChart(effect, text, fontName, size, fontBold, fontItalic, top, left, height, width)
Inserts a WordArt object to the chart
functionaddWordArt(style, text, upperLeftRow, top, upperLeftColumn, left, height, width)
Adds preset WordArt since Excel 2007.s
functionclear()
Clear all shapes.
functioncontains(value)
Reserved for internal use.
functioncopyCommentsInRange(shapes, ca, destRow, destColumn)
Copy all comments in the range.
functioncopyInRange(sourceShapes, ca, destRow, destColumn, isContained)
Copy shapes in the range to destination range.
functiondeleteInRange(ca)
Delete shapes in the range.Comment shapes will not be deleted.
functiondeleteShape(shape)
Delete a shape. If the shape is in the group or is a comment shape, it will not be deleted.
functionget(index)
Reserved for internal use.
functiongroup(groupItems)
Group the shapes.
functionindexOf(value)
Reserved for internal use.
functioniterator()
functionremove(shape)
Remove the shape.
functionremoveAt(index)
Remove the shape.
functionungroup(group)
Ungroups the shape items.
functionupdateSelectedValue()
Update the selected value by the value of the linked cell of the shapes.
 

    • Property Getters/Setters Detail

      • getCount : Number 

        function getCount()
        
      • get : Shape 

        function get(index)
        
        Gets the shape object at the specific index.
        Parameters:
        index -
        Returns:
      • get : Shape 

        function get(name)
        
        Gets the shape object by the shape image
        Parameters:
        name -
        Returns:
    • Method Detail

      • addCopy

        function addCopy(sourceShape, upperLeftRow, top, upperLeftColumn, left)
        Adds and copy a shape to the worksheet.
        Parameters:
        sourceShape: Shape - Source shape.
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of checkbox from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of textbox from its left column, in unit of pixel.
        Returns:
        The new shape object index.
      • addCheckBox

        function addCheckBox(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a checkbox to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of checkbox from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of textbox from its left column, in unit of pixel.
        height: Number - Height of textbox, in unit of pixel.
        width: Number - Width of textbox, in unit of pixel.
        Returns:
        The new CheckBox object index.
      • addTextBox

        function addTextBox(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a text box to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of textbox from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of textbox from its left column, in unit of pixel.
        height: Number - Represents the height of textbox, in unit of pixel.
        width: Number - Represents the width of textbox, in unit of pixel.
        Returns:
        A TextBox object.
      • addSpinner

        function addSpinner(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a Spinner to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of Spinner from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of Spinner from its left column, in unit of pixel.
        height: Number - Represents the height of Spinner, in unit of pixel.
        width: Number - Represents the width of Spinner, in unit of pixel.
        Returns:
        A Spinner object.
      • addScrollBar

        function addScrollBar(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a ScrollBar to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of ScrollBar from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of ScrollBar from its left column, in unit of pixel.
        height: Number - Represents the height of ScrollBar, in unit of pixel.
        width: Number - Represents the width of ScrollBar, in unit of pixel.
        Returns:
        A ScrollBar object.
      • addRadioButton

        function addRadioButton(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a RadioButton to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of RadioButton from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of RadioButton from its left column, in unit of pixel.
        height: Number - Represents the height of RadioButton, in unit of pixel.
        width: Number - Represents the width of RadioButton, in unit of pixel.
        Returns:
        A RadioButton object.
      • addListBox

        function addListBox(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a ListBox to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of ListBox from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of ListBox from its left column, in unit of pixel.
        height: Number - Represents the height of ListBox, in unit of pixel.
        width: Number - Represents the width of ListBox, in unit of pixel.
        Returns:
        A ListBox object.
      • addComboBox

        function addComboBox(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a ComboBox to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of ComboBox from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of ComboBox from its left column, in unit of pixel.
        height: Number - Represents the height of ComboBox, in unit of pixel.
        width: Number - Represents the width of ComboBox, in unit of pixel.
        Returns:
        A ComboBox object.
      • addGroupBox

        function addGroupBox(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a GroupBox to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of GroupBox from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of GroupBox from its left column, in unit of pixel.
        height: Number - Represents the height of GroupBox, in unit of pixel.
        width: Number - Represents the width of GroupBox, in unit of pixel.
        Returns:
        A GroupBox object.
      • addButton

        function addButton(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a Button to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of Button from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of Button from its left column, in unit of pixel.
        height: Number - Represents the height of Button, in unit of pixel.
        width: Number - Represents the width of Button, in unit of pixel.
        Returns:
        A Button object.
      • addLabel

        function addLabel(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a Label to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of Label from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of Label from its left column, in unit of pixel.
        height: Number - Represents the height of Label, in unit of pixel.
        width: Number - Represents the width of Label, in unit of pixel.
        Returns:
        A Label object.
      • addLabelInChart

        function addLabelInChart(top, left, height, width)
        Adds a label to the chart.
        Parameters:
        top: Number - Represents the vertical offset of label from the upper left corner in units of 1/4000 of the chart area.
        left: Number - Represents the vertical offset of label from the upper left corner in units of 1/4000 of the chart area.
        height: Number - Represents the height of label, in units of 1/4000 of the chart area.
        width: Number - Represents the width of label, in units of 1/4000 of the chart area.
        Returns:
        A new Label object.
      • addTextBoxInChart

        function addTextBoxInChart(top, left, height, width)
        Adds a textbox to the chart.
        Parameters:
        top: Number - Represents the vertical offset of textbox from the upper left corner in units of 1/4000 of the chart area.
        left: Number - Represents the vertical offset of textbox from the upper left corner in units of 1/4000 of the chart area.
        height: Number - Represents the height of textbox, in units of 1/4000 of the chart area.
        width: Number - Represents the width of textbox, in units of 1/4000 of the chart area.
        Returns:
        A TextBox object.
      • addTextEffectInChart

        function addTextEffectInChart(effect, text, fontName, size, fontBold, fontItalic, top, left, height, width)
        Inserts a WordArt object to the chart
        Parameters:
        effect: Number - A MsoPresetTextEffect value. The mso preset text effect type.
        text: String - The WordArt text.
        fontName: String - The font name.
        size: Number - The font size
        fontBold: boolean - Indicates whether font is bold.
        fontItalic: boolean - Indicates whether font is italic.
        top: Number - Represents the vertical offset of shape from the upper left corner in units of 1/4000 of the chart area.
        left: Number - Represents the vertical offset of shape from the upper left corner in units of 1/4000 of the chart area.
        height: Number - Represents the height of shape, in units of 1/4000 of the chart area.
        width: Number - Represents the width of shape, in units of 1/4000 of the chart area.
        Returns:
        Returns a Shape object that represents the new WordArt object.
      • addTextEffect

        function addTextEffect(effect, text, fontName, size, fontBold, fontItalic, upperLeftRow, top, upperLeftColumn, left, height, width)
        Inserts a WordArt object.
        Parameters:
        effect: Number - A MsoPresetTextEffect value. The mso preset text effect type.
        text: String - The WordArt text.
        fontName: String - The font name.
        size: Number - The font size
        fontBold: boolean - Indicates whether font is bold.
        fontItalic: boolean - Indicates whether font is italic.
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of shape from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of shape from its left column, in unit of pixel.
        height: Number - Represents the height of shape, in unit of pixel.
        width: Number - Represents the width of shape, in unit of pixel.
        Returns:
        Returns a Shape object that represents the new WordArt object.
      • addWordArt

        function addWordArt(style, text, upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds preset WordArt since Excel 2007.s
        Parameters:
        style: Number - A PresetWordArtStyle value. The preset WordArt Style.
        text: String - The text.
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of shape from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of shape from its left column, in unit of pixel.
        height: Number - Represents the height of shape, in unit of pixel.
        width: Number - Represents the width of shape, in unit of pixel.
        Returns:
      • addRectangle

        function addRectangle(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a RectangleShape to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of RectangleShape from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of RectangleShape from its left column, in unit of pixel.
        height: Number - Represents the height of RectangleShape, in unit of pixel.
        width: Number - Represents the width of RectangleShape, in unit of pixel.
        Returns:
        A RectangleShape object.
      • addOval

        function addOval(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a Oval to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of Oval from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of Oval from its left column, in unit of pixel.
        height: Number - Represents the height of Oval, in unit of pixel.
        width: Number - Represents the width of Oval, in unit of pixel.
        Returns:
        A Oval object.
      • addLine

        function addLine(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a LineShape to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of LineShape from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of LineShape from its left column, in unit of pixel.
        height: Number - Represents the height of LineShape, in unit of pixel.
        width: Number - Represents the width of LineShape, in unit of pixel.
        Returns:
        A LineShape object.
      • addFreeFloatingShape

        function addFreeFloatingShape(type, top, left, height, width, imageData, isOriginalSize)
        Adds a free floating shape to the worksheet.Only applies for line/image shape.
        Parameters:
        type: Number - A MsoDrawingType value. The shape type.
        top: Number - Represents the vertical offset of shape from the worksheet's top row, in unit of pixel.
        left: Number - Represents the horizontal offset of shape from the worksheet's left column, in unit of pixel.
        height: Number - Represents the height of LineShape, in unit of pixel.
        width: Number - Represents the width of LineShape, in unit of pixel.
        imageData: byte[] - The image data,only applies for the picture.
        isOriginalSize: boolean - Whether the shape use original size if the shape is image.
        Returns:
      • addShapeInChart

        function addShapeInChart(type, placement, left, top, right, bottom, imageData)
        Add a shape to chart .All unit is 1/4000 of chart area.
        Parameters:
        type: Number - A MsoDrawingType value. The drawing type.
        placement: Number - A PlacementType value. the placement type.
        left: Number - In unit of 1/4000 chart area width.
        top: Number - In unit of 1/4000 chart area height.
        right: Number - In unit of 1/4000 chart area width.
        bottom: Number - In unit of 1/4000 chart area height.
        imageData: byte[] - If the shape is not a picture or ole object,imageData should be null.
      • addShapeInChart

        function addShapeInChart(type, placement, left, top, right, bottom)
        Add a shape to chart .All unit is 1/4000 of chart area.
        Parameters:
        type: Number - A MsoDrawingType value. The drawing type.
        placement: Number - A PlacementType value. the placement type.
        left: Number - In unit of 1/4000 chart area width.
        top: Number - In unit of 1/4000 chart area height.
        right: Number - In unit of 1/4000 chart area width.
        bottom: Number - In unit of 1/4000 chart area height.
      • addShapeInChartByScale

        function addShapeInChartByScale(type, placement, left, top, right, bottom)
        Add a shape to chart. All unit is percent scale of chart area.
        Parameters:
        type: Number - A MsoDrawingType value. The drawing type.
        placement: Number - A PlacementType value. the placement type.
        left: Number - Unit is percent scale of chart area width.
        top: Number - Unit is percent scale of chart area height.
        right: Number - Unit is percent scale of chart area width.
        bottom: Number - Unit is percent scale of chart area height.
      • addShapeInChartByScale

        function addShapeInChartByScale(type, placement, left, top, right, bottom, imageData)
        Add a shape to chart .All unit is 1/4000 of chart area.
        Parameters:
        type: Number - A MsoDrawingType value. The drawing type.
        placement: Number - A PlacementType value. the placement type.
        left: Number - Unit is percent scale of chart area width.
        top: Number - Unit is percent scale of chart area height.
        right: Number - Unit is percent scale of chart area width.
        bottom: Number - Unit is percent scale of chart area height.
        imageData: byte[] - If the shape is not a picture or ole object,imageData should be null.
      • addArc

        function addArc(upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a ArcShape to the worksheet.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of ArcShape from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of ArcShape from its left column, in unit of pixel.
        height: Number - Represents the height of ArcShape, in unit of pixel.
        width: Number - Represents the width of ArcShape, in unit of pixel.
        Returns:
        A ArcShape object.
      • addShape

        function addShape(type, upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a Shape to the worksheet. The type could not be Chart/Comment/Picture/OleObject/Polygon/DialogBox
        Parameters:
        type: Number - A MsoDrawingType value. Mso drawing type.
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of Shape from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of Shape from its left column, in unit of pixel.
        height: Number - Represents the height of Shape, in unit of pixel.
        width: Number - Represents the width of Shape, in unit of pixel.
        Returns:
        A Shape object.
      • addAutoShape

        function addAutoShape(type, upperLeftRow, top, upperLeftColumn, left, height, width)
        Adds a AutoShape to the worksheet. The type could not be Chart/Comment/Picture/OleObject/Polygon/DialogBox
        Parameters:
        type: Number - A AutoShapeType value. Auto shape type.
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of Shape from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - Represents the horizontal offset of Shape from its left column, in unit of pixel.
        height: Number - Represents the height of Shape, in unit of pixel.
        width: Number - Represents the width of Shape, in unit of pixel.
        Returns:
        A Shape object.
      • addAutoShapeInChart

        function addAutoShapeInChart(type, top, left, height, width)
        Adds a AutoShape to the chart. The type could not be Chart/Comment/Picture/OleObject/Polygon/DialogBox
        Parameters:
        type: Number - A AutoShapeType value. Auto shape type.
        top: Number - Represents the vertical offset of textbox from the upper left corner in units of 1/4000 of the chart area.
        left: Number - Represents the vertical offset of textbox from the upper left corner in units of 1/4000 of the chart area.
        height: Number - Represents the height of textbox, in units of 1/4000 of the chart area.
        width: Number - Represents the width of textbox, in units of 1/4000 of the chart area.
        Returns:
        Returns a shape object.
      • addSvg

        function addSvg(upperLeftRow, top, upperLeftColumn, left, height, width, svgData, compatibleImageData)
        Adds svg image.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of shape from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - The horizontal offset of shape from its left column, in unit of pixel.
        height: Number - The height of shape, in unit of pixel.
        width: Number - The width of shape, in unit of pixel.
        svgData: byte[] - The svg image data.
        compatibleImageData: byte[] - Converted image data from svg in order to be compatible with Excel 2016 or lower versions.
        Returns:
      • addIcons

        function addIcons(upperLeftRow, top, upperLeftColumn, left, height, width, imageByteData, compatibleImageData)
        Adds svg image.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        top: Number - Represents the vertical offset of shape from its left row, in unit of pixel.
        upperLeftColumn: Number - Upper left column index.
        left: Number - The horizontal offset of shape from its left column, in unit of pixel.
        height: Number - The height of shape, in unit of pixel.
        width: Number - The width of shape, in unit of pixel.
        imageByteData: byte[] - The image byte data.
        compatibleImageData: byte[] - Converted image data from svg in order to be compatible with Excel 2016 or lower versions.
        Returns:
      • addLinkedPicture

        function addLinkedPicture(upperLeftRow, upperLeftColumn, height, width, sourceFullName)
        Add a linked picture.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        upperLeftColumn: Number - Upper left column index.
        height: Number - The height of the shape. In unit of pixels
        width: Number - The width of the shape. In unit of pixels
        sourceFullName: String - The path and name of the source file for the linked image
        Returns:
        Picture Picture object.
      • addOleObjectWithLinkedImage

        function addOleObjectWithLinkedImage(upperLeftRow, upperLeftColumn, height, width, sourceFullName)
        Add a linked picture.
        Parameters:
        upperLeftRow: Number - Upper left row index.
        upperLeftColumn: Number - Upper left column index.
        height: Number - The height of the shape. In unit of pixels
        width: Number - The width of the shape. In unit of pixels
        sourceFullName: String - The path and name of the source file for the linked image
        Returns:
        Picture Picture object.
      • addOleObject

        function addOleObject(upperLeftRow, top, upperLeftColumn, left, height, width, imageData)
        Parameters:
        upperLeftRow: Number -
        top: Number -
        upperLeftColumn: Number -
        left: Number -
        height: Number -
        width: Number -
        imageData: byte[] -
        Returns:
      • copyCommentsInRange

        function copyCommentsInRange(shapes, ca, destRow, destColumn)
        Copy all comments in the range.
        Parameters:
        shapes: ShapeCollection - The source shapes.
        ca: CellArea - The source range.
        destRow: Number - The dest range start row.
        destColumn: Number - The dest range start column.
      • copyInRange

        function copyInRange(sourceShapes, ca, destRow, destColumn, isContained)
        Copy shapes in the range to destination range.
        Parameters:
        sourceShapes: ShapeCollection - Source shapes.
        ca: CellArea - The source range.
        destRow: Number - The dest row index of the dest range.
        destColumn: Number - The dest column of the dest range.
        isContained: boolean - Whether only copy the shapes which are contained in the range. If true,only copies the shapes in the range. Otherwise,it works as MS Office.
      • deleteInRange

        function deleteInRange(ca)
        Delete shapes in the range.Comment shapes will not be deleted.
        Parameters:
        ca: CellArea - The range.If the shapes are contained in the range, they will be removed.
      • deleteShape

        function deleteShape(shape)
        Delete a shape. If the shape is in the group or is a comment shape, it will not be deleted.
        Parameters:
        shape: Shape -
      • group

        function group(groupItems)
        Group the shapes. The shape in the groupItems should not be grouped. The shape must be in this Shapes collection.
        Parameters:
        groupItems: Shape[] - the group items.
        Returns:
        Return the group shape.
      • ungroup

        function ungroup(group)
        Ungroups the shape items. If the group shape is grouped by another group shape,nothing will be done.
        Parameters:
        group: GroupShape - The group shape.
      • removeAt

        function removeAt(index)
        Remove the shape.
        Parameters:
        index: Number - The index of the shape.
      • remove

        function remove(shape)
        Remove the shape.
        Parameters:
        shape: Shape -
      • clear

        function clear()
        Clear all shapes.
      • updateSelectedValue

        function updateSelectedValue()
        Update the selected value by the value of the linked cell of the shapes.
      • iterator

        function iterator()
      • get

        function get(index)
        Reserved for internal use.
      • contains

        function contains(value)
        Reserved for internal use.
      • indexOf

        function indexOf(value)
        Reserved for internal use.