Skip to main content

ShapeCollection

Excel.ShapeCollection: the drawing objects of one worksheet, bottom first. Import from @reductoai/xlsx/officejs.

ShapeCollection properties

ShapeCollection.addGeometricShape()

A preset shape at the sheet’s top-left, 100 points square.

ShapeCollection.addGroup()

One group of two or more top-level shapes, standing where the topmost one stood.

ShapeCollection.addImage()

A PNG, JPEG or GIF at the sheet’s top-left, at its own size.

ShapeCollection.addLine()

A line from one point to another, in points from the sheet’s top-left.

ShapeCollection.addTextBox()

ShapeCollection.getCount()

ShapeCollection.getItem()

By name, ignoring case, or by id.

ShapeCollection.getItemAt()

ShapeCollection.getItemOrNullObject()

ExcelShape

Excel.Shape: a drawing object on a worksheet, by its cNvPr id. Edits apply at once. Import from @reductoai/xlsx/officejs.

ExcelShape properties

ExcelShape.copyTo()

A copy at the same place, on top; on this sheet unless another is given.

ExcelShape.delete()

ExcelShape.getAsImage()

Base64 of the shape as the view paints it, sized to its turned frame at 96 dpi; Png or Jpeg.

ExcelShape.incrementLeft()

ExcelShape.incrementRotation()

ExcelShape.incrementTop()

ExcelShape.scaleHeight()

ExcelShape.scaleWidth()

ExcelShape.set()

Sets several properties at once.

ExcelShape.setZOrder()

ExcelImage

Excel.Image. Import from @reductoai/xlsx/officejs.

ExcelImage properties

ExcelImage.incrementBrightness()

ExcelImage.incrementContrast()

ExcelImage.set()

TextFrame

Excel.TextFrame. Import from @reductoai/xlsx/officejs.

TextFrame properties

TextFrame.deleteText()

TextFrame.set()

ShapeFill

Excel.ShapeFill. Import from @reductoai/xlsx/officejs.

ShapeFill properties

ShapeFill.clear()

ShapeFill.set()

ShapeFill.setSolidColor()

ShapeLineFormat

Excel.ShapeLineFormat. Import from @reductoai/xlsx/officejs.

ShapeLineFormat properties

ShapeLineFormat.set()