## ShapeCollection class Representerar all form i ett kalkylblad/diagram. ```csharp public class ShapeCollection : CollectionBase ``` ## Egenskaper | namn | Beskrivning | | --- | --- | | [Capacity](../../aspose.cells/collectionbase`1/capacity) { get; set; } | | | [Count](../../aspose.cells/collectionbase`1/count) { get; } | | | [Item](../../aspose.cells.drawing/shapecollection/item) { get; } | Hämtar formobjektet vid det specifika indexet. (2 indexers) | | [Item](../../aspose.cells/collectionbase`1/item) { get; set; } | | ## Metoder | namn | Beskrivning | | --- | --- | | [AddActiveXControl](../../aspose.cells.drawing/shapecollection/addactivexcontrol)(ControlType, int, int, int, int, int, int) | Skapar en Activex-kontroll. | | [AddArc](../../aspose.cells.drawing/shapecollection/addarc)(int, int, int, int, int, int) | Lägger till en ArcShape i kalkylbladet. | | [AddAutoShape](../../aspose.cells.drawing/shapecollection/addautoshape)(AutoShapeType, int, int, int, int, int, int) | Lägger till en AutoShape i kalkylbladet. | | [AddAutoShapeInChart](../../aspose.cells.drawing/shapecollection/addautoshapeinchart)(AutoShapeType, int, int, int, int) | Lägger till en AutoShape i diagrammet. | | [AddButton](../../aspose.cells.drawing/shapecollection/addbutton)(int, int, int, int, int, int) | Lägger till en knapp i kalkylbladet. | | [AddCheckBox](../../aspose.cells.drawing/shapecollection/addcheckbox)(int, int, int, int, int, int) | Lägger till en kryssruta i kalkylbladet. | | [AddComboBox](../../aspose.cells.drawing/shapecollection/addcombobox)(int, int, int, int, int, int) | Lägger till en ComboBox i kalkylbladet. | | [AddCopy](../../aspose.cells.drawing/shapecollection/addcopy)(Shape, int, int, int, int) | Lägger till och kopierar en form till kalkylbladet. | | [AddFreeFloatingShape](../../aspose.cells.drawing/shapecollection/addfreefloatingshape)(MsoDrawingType, int, int, int, int, byte[], bool) | Lägger till en fri flytande form till kalkylbladet. Gäller endast linje-/bildform. | | [AddGroupBox](../../aspose.cells.drawing/shapecollection/addgroupbox)(int, int, int, int, int, int) | Lägger till en GroupBox i kalkylbladet. | | [AddIcons](../../aspose.cells.drawing/shapecollection/addicons)(int, int, int, int, int, int, byte[], byte[]) | Lägger till svg-bild. | | [AddLabel](../../aspose.cells.drawing/shapecollection/addlabel)(int, int, int, int, int, int) | Lägger till en etikett till kalkylbladet. | | [AddLabelInChart](../../aspose.cells.drawing/shapecollection/addlabelinchart)(int, int, int, int) | Lägger till en etikett i diagrammet. | | [AddLine](../../aspose.cells.drawing/shapecollection/addline)(int, int, int, int, int, int) | Lägger till en LineShape i kalkylbladet. | | [AddLinkedPicture](../../aspose.cells.drawing/shapecollection/addlinkedpicture)(int, int, int, int, string) | Lägg till en länkad bild. | | [AddListBox](../../aspose.cells.drawing/shapecollection/addlistbox)(int, int, int, int, int, int) | Lägger till en ListBox i kalkylbladet. | | [AddOleObject](../../aspose.cells.drawing/shapecollection/addoleobject)(int, int, int, int, int, int, byte[]) | | | [AddOleObjectWithLinkedImage](../../aspose.cells.drawing/shapecollection/addoleobjectwithlinkedimage)(int, int, int, int, string) | Lägg till en länkad bild. | | [AddOval](../../aspose.cells.drawing/shapecollection/addoval)(int, int, int, int, int, int) | Lägger till en oval i kalkylbladet. | | [AddPicture](../../aspose.cells.drawing/shapecollection/addpicture#addpicture)(int, int, int, int, Stream) | Lägger till en bild i samlingen. | | [AddPicture](../../aspose.cells.drawing/shapecollection/addpicture#addpicture_1)(int, int, Stream, int, int) | Lägger till en bild i samlingen. | | [AddPictureInChart](../../aspose.cells.drawing/shapecollection/addpictureinchart)(int, int, Stream, int, int) | Lägger till en bild i diagrammet. | | [AddRadioButton](../../aspose.cells.drawing/shapecollection/addradiobutton)(int, int, int, int, int, int) | Lägger till en RadioButton i arbetsbladet. | | [AddRectangle](../../aspose.cells.drawing/shapecollection/addrectangle)(int, int, int, int, int, int) | Lägger till en RectangleShape till kalkylbladet. | | [AddScrollBar](../../aspose.cells.drawing/shapecollection/addscrollbar)(int, int, int, int, int, int) | Lägger till en rullningslist i arbetsbladet. | | [AddShape](../../aspose.cells.drawing/shapecollection/addshape)(MsoDrawingType, int, int, int, int, int, int) | Lägger till en form i kalkylbladet. | | [AddShapeInChart](../../aspose.cells.drawing/shapecollection/addshapeinchart#addshapeinchart)(MsoDrawingType, PlacementType, int, int, int, int) | Lägg till en form i diagrammet. Alla enheter är 1/4000 av kartytan. | | [AddShapeInChart](../../aspose.cells.drawing/shapecollection/addshapeinchart#addshapeinchart_1)(MsoDrawingType, PlacementType, int, int, int, int, byte[]) | Lägg till en form i diagrammet. Alla enheter är 1/4000 av kartytan. | | [AddShapeInChartByScale](../../aspose.cells.drawing/shapecollection/addshapeinchartbyscale#addshapeinchartbyscale)(MsoDrawingType, PlacementType, double, double, double, double) | Lägg till en form i diagrammet. Alla enheter är procentuell skala av diagramarean. | | [AddShapeInChartByScale](../../aspose.cells.drawing/shapecollection/addshapeinchartbyscale#addshapeinchartbyscale_1)(MsoDrawingType, PlacementType, double, double, double, double, byte[]) | Lägg till en form i diagrammet. Alla enheter är 1/4000 av kartytan. | | [AddSpinner](../../aspose.cells.drawing/shapecollection/addspinner)(int, int, int, int, int, int) | Lägger till en spinner i kalkylbladet. | | [AddSvg](../../aspose.cells.drawing/shapecollection/addsvg)(int, int, int, int, int, int, byte[], byte[]) | Lägger till svg-bild. | | [AddTextBox](../../aspose.cells.drawing/shapecollection/addtextbox)(int, int, int, int, int, int) | Lägger till en textruta i kalkylbladet. | | [AddTextBoxInChart](../../aspose.cells.drawing/shapecollection/addtextboxinchart)(int, int, int, int) | Lägger till en textruta i diagrammet. | | [AddTextEffect](../../aspose.cells.drawing/shapecollection/addtexteffect)(MsoPresetTextEffect, string, string, int, bool, bool, int, int, int, int, int, int) | Infogar ett WordArt-objekt. | | [AddTextEffectInChart](../../aspose.cells.drawing/shapecollection/addtexteffectinchart)(MsoPresetTextEffect, string, string, int, bool, bool, int, int, int, int) | Infogar ett WordArt-objekt i diagrammet | | [AddWordArt](../../aspose.cells.drawing/shapecollection/addwordart)(PresetWordArtStyle, string, int, int, int, int, int, int) | Lägger till förinställd WordArt sedan Excel 2007.s | | [BinarySearch](../../aspose.cells/collectionbase`1/binarysearch)(Shape) | | | [BinarySearch](../../aspose.cells/collectionbase`1/binarysearch)(Shape, IComparer<Shape>) | | | [BinarySearch](../../aspose.cells/collectionbase`1/binarysearch)(int, int, Shape, IComparer<Shape>) | | | [Clear](../../aspose.cells.drawing/shapecollection/clear#clear)() | Rensa alla former. (2 methods) | | [Contains](../../aspose.cells/collectionbase`1/contains)(Shape) | | | [CopyCommentsInRange](../../aspose.cells.drawing/shapecollection/copycommentsinrange)(ShapeCollection, CellArea, int, int) | Kopiera alla kommentarer i intervallet. | | [CopyInRange](../../aspose.cells.drawing/shapecollection/copyinrange)(ShapeCollection, CellArea, int, int, bool) | Kopiera former i intervallet till destinationsområdet. | | [CopyTo](../../aspose.cells/collectionbase`1/copyto)(Shape[]) | | | [CopyTo](../../aspose.cells/collectionbase`1/copyto)(Shape[], int) | | | [CopyTo](../../aspose.cells/collectionbase`1/copyto)(int, Shape[], int, int) | | | [DeleteInRange](../../aspose.cells.drawing/shapecollection/deleteinrange)(CellArea) | Ta bort former i intervallet. Kommentarsformer kommer inte att tas bort. | | [DeleteShape](../../aspose.cells.drawing/shapecollection/deleteshape)(Shape) | Ta bort en form. Om formen finns i gruppen eller är en kommentarsform kommer den inte att tas bort. | | [Exists](../../aspose.cells/collectionbase`1/exists)(Predicate<Shape>) | | | [Find](../../aspose.cells/collectionbase`1/find)(Predicate<Shape>) | | | [FindAll](../../aspose.cells/collectionbase`1/findall)(Predicate<Shape>) | | | [FindIndex](../../aspose.cells/collectionbase`1/findindex)(Predicate<Shape>) | | | [FindIndex](../../aspose.cells/collectionbase`1/findindex)(int, Predicate<Shape>) | | | [FindIndex](../../aspose.cells/collectionbase`1/findindex)(int, int, Predicate<Shape>) | | | [FindLast](../../aspose.cells/collectionbase`1/findlast)(Predicate<Shape>) | | | [FindLastIndex](../../aspose.cells/collectionbase`1/findlastindex)(Predicate<Shape>) | | | [FindLastIndex](../../aspose.cells/collectionbase`1/findlastindex)(int, Predicate<Shape>) | | | [FindLastIndex](../../aspose.cells/collectionbase`1/findlastindex)(int, int, Predicate<Shape>) | | | [GetEnumerator](../../aspose.cells/collectionbase`1/getenumerator)() | | | [Group](../../aspose.cells.drawing/shapecollection/group)(Shape[]) | Gruppera formerna. | | [IndexOf](../../aspose.cells/collectionbase`1/indexof)(Shape) | | | [IndexOf](../../aspose.cells/collectionbase`1/indexof)(Shape, int) | | | [IndexOf](../../aspose.cells/collectionbase`1/indexof)(Shape, int, int) | | | [LastIndexOf](../../aspose.cells/collectionbase`1/lastindexof)(Shape) | | | [LastIndexOf](../../aspose.cells/collectionbase`1/lastindexof)(Shape, int) | | | [LastIndexOf](../../aspose.cells/collectionbase`1/lastindexof)(Shape, int, int) | | | [Remove](../../aspose.cells.drawing/shapecollection/remove)(Shape) | Ta bort formen. | | [RemoveAt](../../aspose.cells.drawing/shapecollection/removeat#removeat)(int) | Ta bort formen. (2 methods) | | [Ungroup](../../aspose.cells.drawing/shapecollection/ungroup)(GroupShape) | Delar upp formobjekten. | | [UpdateSelectedValue](../../aspose.cells.drawing/shapecollection/updateselectedvalue)() | Uppdatera det valda värdet med värdet för den länkade cellen i formerna. | ### Exempel ```csharp [C#] //Instantiering av ett arbetsboksobjekt Workbook workbook = new Workbook(); //skaffa ShapeCollection ShapeCollection shapes = workbook.Worksheets[0].Shapes; //gör dina affärer //Spara excel-filen. workbook.Save("result.xlsx"); ``` ### Se även * class [CollectionBase<T>](../../aspose.cells/collectionbase-1) * class [Shape](../shape) * namnutrymme [Aspose.Cells.Drawing](../../aspose.cells.drawing) * hopsättning [Aspose.Cells](../../)