程序包 com.grapecity.documents.excel.drawing

接口 IShapes

所有超级接口:
Iterable<IShape>
public interface IShapes extends Iterable<IShape>
A collection of all the IShape objects on the specified sheet.

  • 方法详细资料

    • getRange

      IShapeRange getRange(String[] index)
      Returns a ShapeRange object that represents a subset of the shapes in a Shapes collection.

    • getRange

      IShapeRange getRange(int[] index)
      Returns a ShapeRange object that represents a subset of the shapes in a Shapes collection.

    • get

      IShape get(int index)
      Returns a single object from a collection.
      参数:
      index - Required int. The index number for the object.

    • get

      IShape get(String name)
      Returns a single object from a collection.
      参数:
      name - Required string. The name for the object.

    • getCount

      int getCount()
      Returns the number of objects in the collection.

    • addChart

      IShape addChart(ChartType chartType, double left, double top, double width, double height)
      Creates a chart at the specified location on the active sheet.
      参数:
      chartType - The chart type
      left - The distance, in points, from the left edge of the object to theleft edge of column A (on a worksheet) or the left edge of the chart area (on a chart).
      top - The distance, in points, from the top edge of the top most shapein the shape range to the top edge of the worksheet.
      width - The width, in points, of the object
      height - The height, in points, of the object
      返回:
      The IShape object.

    • addChart

      IShape addChart(ChartType chartType, IRange range)
      Creates a chart at the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      参数:
      chartType - The chart type
      range - The target range of the current sheet.
      返回:
      The IShape object.

    • addChart

      IShape addChart(String name, ChartType chartType, double left, double top, double width, double height)
      Creates a chart at the specified location on the active sheet.
      参数:
      name - * The chart name
      chartType - The chart type
      left - The distance, in points, from the left edge of the object to theleft edge of column A (on a worksheet) or the left edge of the chart area (on a chart).
      top - The distance, in points, from the top edge of the top most shapein the shape range to the top edge of the worksheet.
      width - The width, in points, of the object
      height - The height, in points, of the object
      返回:
      The IShape object.

    • addChart

      IShape addChart(String name, ChartType chartType, IRange range)
      Creates a chart at the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      参数:
      name - * The chart name
      chartType - The chart type
      range - The target range of the current sheet.

    • addPicture

      IShape addPicture(String filename, double left, double top, double width, double height) throws IOException
      Creates a picture from an existing file. Returns the IShape objectthat represents the new picture.
      参数:
      filename - The file from which the object is to be created
      left - The position (in points) of the upper-left corner of the picturerelative to the upper-left corner of the document.
      top - The position (in points) of the upper-left corner of the picturerelative to the top of the document.
      width - The width of the picture, in points.
      height - The height of the picture, in points.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPicture

      IShape addPicture(String filename, IRange range) throws IOException
      Creates a picture from an existing file at the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      Returns the IShape object that represents the new picture.

      参数:
      filename - The file from which the object is to be created
      range - The target range of the current sheet.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPicture

      IShape addPicture(String name, String filename, double left, double top, double width, double height) throws IOException
      Creates a picture from an existing file. Returns the IShape objectthat represents the new picture.
      参数:
      name - The picture name
      filename - The file from which the object is to be created
      left - The position (in points) of the upper-left corner of the picturerelative to the upper-left corner of the document.
      top - The position (in points) of the upper-left corner of the picturerelative to the top of the document.
      width - The width of the picture, in points.
      height - The height of the picture, in points.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPicture

      IShape addPicture(String name, String filename, IRange range) throws IOException
      Creates a picture from an existing file at the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      Returns the IShape object that represents the new picture.

      参数:
      name - The picture name
      filename - The file from which the object is to be created
      range - The target range of the current sheet.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPicture

      IShape addPicture(InputStream stream, ImageType type, double left, double top, double width, double height) throws IOException
      Creates a picture from an existing stream. Returns the IShape objectthat represents the new picture.
      参数:
      stream - The stream from which the object is to be created.
      type - Specifies the type of picture to create.
      left - The position (in points) of the upper-left corner of the picturerelative to the upper-left corner of the document.
      top - The position (in points) of the upper-left corner of the picturerelative to the top of the document.
      width - The width of the picture, in points.
      height - The height of the picture, in points.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPicture

      IShape addPicture(InputStream stream, ImageType type, IRange range) throws IOException
      Creates a picture from an existing stream at the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      Returns the IShape object that represents the new picture.

      参数:
      stream - The stream from which the object is to be created.
      type - Specifies the type of picture to create.
      range - The target range of the current sheet.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPicture

      IShape addPicture(String name, InputStream stream, ImageType type, double left, double top, double width, double height) throws IOException
      Creates a picture from an existing stream. Returns the IShape objectthat represents the new picture.
      参数:
      name - The picture name
      stream - The stream from which the object is to be created.
      type - Specifies the type of picture to create.
      left - The position (in points) of the upper-left corner of the picturerelative to the upper-left corner of the document.
      top - The position (in points) of the upper-left corner of the picturerelative to the top of the document.
      width - The width of the picture, in points.
      height - The height of the picture, in points.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPicture

      IShape addPicture(String name, InputStream stream, ImageType type, IRange range) throws IOException
      Creates a picture from an existing stream at the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      Returns the IShape object that represents the new picture.

      参数:
      name - The picture name
      stream - The stream from which the object is to be created.
      type - Specifies the type of picture to create.
      range - The target range of the current sheet.
      返回:
      The IShape object.
      抛出:
      IOException

    • addShape

      IShape addShape(AutoShapeType type, double left, double top, double width, double height)
      Returns the IShape object that represents the new AutoShape in aworksheet.
      参数:
      type - Specifies the type of AutoShape to create.
      left - The position (in points) of the upper-left corner of theAutoShape's boundary box relative to the upper-left corner of the document.
      top - The position (in points) of the upper-left corner of theAutoShape's boundary box relative to the upper-left corner of the document.
      width - The width and height of the AutoShape's boundary box, in points.
      height - The width and height of the AutoShape's boundary box, in points.
      返回:
      The IShape object.

    • addShape

      IShape addShape(AutoShapeType type, IRange range)
      Returns the IShape object that represents the new AutoShapeat the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      参数:
      type - Specifies the type of AutoShape to create.
      range - The target range of the current sheet.
      返回:
      The IShape object.

    • addShape

      IShape addShape(String name, AutoShapeType type, double left, double top, double width, double height)
      Returns the IShape object that represents the new AutoShape in aworksheet.
      参数:
      name - The shape name
      type - Specifies the type of AutoShape to create.
      left - The position (in points) of the upper-left corner of theAutoShape's boundary box relative to the upper-left corner of the document.
      top - The position (in points) of the upper-left corner of theAutoShape's boundary box relative to the upper-left corner of the document.
      width - The width and height of the AutoShape's boundary box, in points.
      height - The width and height of the AutoShape's boundary box, in points.
      返回:
      The IShape object.

    • addShape

      IShape addShape(String name, AutoShapeType type, IRange range)
      Returns the IShape object that represents the new AutoShapeat the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      参数:
      name - The shape name
      type - Specifies the type of AutoShape to create.
      range - The target range of the current sheet.
      返回:
      The IShape object.

    • addConnector

      IShape addConnector(ConnectorType type, double beginX, double beginY, double endX, double endY)
      Creates a connector. Returns the IShape object that represents thenew connector.
      参数:
      type - The connector type to add.
      beginX - The horizontal position (in points) of the connector's startingpoint relative to the upper-left corner of the document.
      beginY - The vertical position (in points) of the connector's startingpoint relative to the upper-left corner of the document.
      endX - The horizontal position (in points) of the connector's end pointrelative to the upper-left corner of the document.
      endY - The veritcal position (in points) of the connector's end pointrelative to the upper-left corner of the document.
      返回:
      The IShape object.

    • addConnector

      IShape addConnector(ConnectorType type, IRange range)
      Creates a connector at the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      Returns the IShape object that represents the new connector.

      参数:
      type - The connector type to add.
      range - The target range of the current sheet.
      返回:
      The IShape object.

    • addConnector

      IShape addConnector(String name, ConnectorType type, double beginX, double beginY, double endX, double endY)
      Creates a connector. Returns the IShape object that represents thenew connector.
      参数:
      name - The connector name
      type - The connector type to add.
      beginX - The horizontal position (in points) of the connector's startingpoint relative to the upper-left corner of the document.
      beginY - The vertical position (in points) of the connector's startingpoint relative to the upper-left corner of the document.
      endX - The horizontal position (in points) of the connector's end pointrelative to the upper-left corner of the document.
      endY - The veritcal position (in points) of the connector's end pointrelative to the upper-left corner of the document.
      返回:
      The IShape object.

    • addConnector

      IShape addConnector(String name, ConnectorType type, IRange range)
      Creates a connector at the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      Returns the IShape object that represents the new connector.

      参数:
      name - The connector name
      type - The connector type to add.
      range - The target range of the current sheet.
      返回:
      The IShape object.

    • addChartInPixel

      IShape addChartInPixel(ChartType chartType, double left, double top, double width, double height)
      Creates a chart at the specified location on the active sheet.
      参数:
      chartType - The chart type
      left - The distance, in pixels, from the left edge of the object to theleft edge of column A (on a worksheet) or the left edge of the chart area (on a chart).
      top - The distance, in pixels, from the top edge of the top most shape inthe shape range to the top edge of the worksheet.
      width - The width, in pixels, of the object
      height - The height, in pixels, of the object
      返回:
      The IShape object.

    • addChartInPixel

      IShape addChartInPixel(String name, ChartType chartType, double left, double top, double width, double height)
      Creates a chart at the specified location on the active sheet.
      参数:
      name - The chart name
      chartType - The chart type
      left - The distance, in pixels, from the left edge of the object to theleft edge of column A (on a worksheet) or the left edge of the chart area (on a chart).
      top - The distance, in pixels, from the top edge of the top most shape inthe shape range to the top edge of the worksheet.
      width - The width, in pixels, of the object
      height - The height, in pixels, of the object
      返回:
      The IShape object.

    • addPictureInPixel

      IShape addPictureInPixel(String filename, double left, double top, double width, double height) throws IOException
      Creates a picture from an existing file. Returns the IShape objectthat represents the new picture.
      参数:
      filename - The file from which the object is to be created
      left - The position (in pixels) of the upper-left corner of the picturerelative to the upper-left corner of the document.
      top - The position (in pixels) of the upper-left corner of the picturerelative to the top of the document.
      width - The width of the picture, in pixels.
      height - The height of the picture, in pixels.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPictureInPixel

      IShape addPictureInPixel(String name, String filename, double left, double top, double width, double height) throws IOException
      Creates a picture from an existing file. Returns the IShape objectthat represents the new picture.
      参数:
      name - The picture name
      filename - The file from which the object is to be created
      left - The position (in pixels) of the upper-left corner of the picturerelative to the upper-left corner of the document.
      top - The position (in pixels) of the upper-left corner of the picturerelative to the top of the document.
      width - The width of the picture, in pixels.
      height - The height of the picture, in pixels.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPictureInPixel

      IShape addPictureInPixel(InputStream stream, ImageType type, double left, double top, double width, double height) throws IOException
      Creates a picture from an existing stream. Returns the IShape objectthat represents the new picture.
      参数:
      stream - The stream from which the object is to be created.
      type - Specifies the type of picture to create.
      left - The position (in pixels) of the upper-left corner of the picturerelative to the upper-left corner of the document.
      top - The position (in pixels) of the upper-left corner of the picturerelative to the top of the document.
      width - The width of the picture, in pixels.
      height - The height of the picture, in pixels.
      返回:
      The IShape object.
      抛出:
      IOException

    • addPictureInPixel

      IShape addPictureInPixel(String name, InputStream stream, ImageType type, double left, double top, double width, double height) throws IOException
      Creates a picture from an existing stream. Returns the IShape objectthat represents the new picture.
      参数:
      name - The picture name
      stream - The stream from which the object is to be created.
      type - Specifies the type of picture to create.
      left - The position (in pixels) of the upper-left corner of the picturerelative to the upper-left corner of the document.
      top - The position (in pixels) of the upper-left corner of the picturerelative to the top of the document.
      width - The width of the picture, in pixels.
      height - The height of the picture, in pixels.
      返回:
      The IShape object.
      抛出:
      IOException

    • addShapeInPixel

      IShape addShapeInPixel(AutoShapeType type, double left, double top, double width, double height)
      Returns the IShape object that represents the new AutoShape in aworksheet.
      参数:
      type - Specifies the type of AutoShape to create.
      left - The position (in pixels) of the upper-left corner of theAutoShape's boundary box relative to the upper-left corner of the document.
      top - The position (in pixels) of the upper-left corner of theAutoShape's boundary box relative to the upper-left corner of the document.
      width - The width and height of the AutoShape's boundary box, in pixels.
      height - The width and height of the AutoShape's boundary box, in pixels.
      返回:
      The IShape object.

    • addShapeInPixel

      IShape addShapeInPixel(String name, AutoShapeType type, double left, double top, double width, double height)
      Returns the IShape object that represents the new AutoShape in aworksheet.
      参数:
      name - The shape name
      type - Specifies the type of AutoShape to create.
      left - The position (in pixels) of the upper-left corner of theAutoShape's boundary box relative to the upper-left corner of the document.
      top - The position (in pixels) of the upper-left corner of theAutoShape's boundary box relative to the upper-left corner of the document.
      width - The width and height of the AutoShape's boundary box, in pixels.
      height - The width and height of the AutoShape's boundary box, in pixels.
      返回:
      The IShape object.

    • addConnectorInPixel

      IShape addConnectorInPixel(ConnectorType type, float beginX, float beginY, float endX, float endY)
      Creates a connector. Returns the IShape object that represents thenew connector.
      参数:
      type - The connector type to add.
      beginX - The horizontal position (in pixels) of the connector's startingpoint relative to the upper-left corner of the document.
      beginY - The vertical position (in pixels) of the connector's startingpoint relative to the upper-left corner of the document.
      endX - The horizontal position (in pixels) of the connector's end pointrelative to the upper-left corner of the document.
      endY - The veritcal position (in pixels) of the connector's end pointrelative to the upper-left corner of the document.
      返回:
      The IShape object.

    • addConnectorInPixel

      IShape addConnectorInPixel(String name, ConnectorType type, float beginX, float beginY, float endX, float endY)
      Creates a connector. Returns the IShape object that represents thenew connector.
      参数:
      name - The connector name
      type - The connector type to add.
      beginX - The horizontal position (in pixels) of the connector's startingpoint relative to the upper-left corner of the document.
      beginY - The vertical position (in pixels) of the connector's startingpoint relative to the upper-left corner of the document.
      endX - The horizontal position (in pixels) of the connector's end pointrelative to the upper-left corner of the document.
      endY - The veritcal position (in pixels) of the connector's end pointrelative to the upper-left corner of the document.
      返回:
      The IShape object.

    • addCameraPicture

      IShape addCameraPicture(String reference, double left, double top)
      Creates a picture from reference range. Returns the IShape object that represents the new picture.
      参数:
      reference - The range of the picture generated from
      left - The position (in points) of the upper-left cornerof the picture relative to the upper-left corner of the document.
      top - The position (in points) of the upper-left cornerof the picture relative to the top of the document.
      返回:
      The IShape object.

    • addCameraPicture

      IShape addCameraPicture(String reference, double left, double top, double width, double height)
      Creates a picture from reference range. Returns the IShape object that represents the new picture.
      参数:
      reference - The range of the picture generated from
      left - The position (in points) of the upper-left cornerof the picture relative to the upper-left corner of the document.
      top - The position (in points) of the upper-left cornerof the picture relative to the top of the document.
      width - The width and height of the AutoShape's boundary box, in points.
      height - The width and height of the AutoShape's boundary box, in points.
      返回:
      The IShape object.

    • addCameraPicture

      IShape addCameraPicture(String reference, IRange range)
      Creates a picture from reference range to the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      Returns the IShape object that represents the new picture.

      参数:
      reference - The range of the picture generated from
      range - The target range of the current sheet.
      返回:
      The IShape object.

    • addCameraPicture

      IShape addCameraPicture(String reference, String name, double left, double top)
      Creates a picture from reference range.Returns the IShape object that represents the new picture.
      参数:
      reference - The range of the picture generated from
      name - The picture name
      left - The position (in points) of the upper-left cornerof the picture relative to the upper-left corner of the document.
      top - The position (in points) of the upper-left cornerof the picture relative to the top of the document.
      返回:
      The IShape object.

    • addCameraPicture

      IShape addCameraPicture(String reference, String name, double left, double top, double width, double height)
      Creates a picture from reference range.Returns the IShape object that represents the new picture.
      参数:
      reference - The range of the picture generated from
      name - The picture name
      left - The position (in points) of the upper-left cornerof the picture relative to the upper-left corner of the document.
      top - The position (in points) of the upper-left cornerof the picture relative to the top of the document.
      width - The width and height of the AutoShape's boundary box, in points.
      height - The width and height of the AutoShape's boundary box, in points.
      返回:
      The IShape object.

    • addCameraPicture

      IShape addCameraPicture(String reference, String name, IRange range)
      Creates a picture from reference range to the specified range on the current sheet.

      The sheet of targetRange and the sheet of the shape being added must be the same sheet.

      Returns the IShape object that represents the new picture.

      参数:
      reference - The range of the picture generated from
      name - The picture name
      range - The target range of the current sheet.
      返回:
      The IShape object.