Excel组文本框和图片

我找到了一些代码，可以使用SDK 2.0将图像添加到Excel工作表中。这部分工作正常。现在，我想在“图像”下放置一个“文本框”，但是我通常不知道如何获取一个“文本框”。

我需要哪些类，什么是属性或什么属性？

此外，如果它是groupt，那就太好了。这样，当您拖动一个时，另一个就会跟随。

代码看起来像这样（我知道很多，但是我不能再削减了）：

private void addImage(Offset offset, Extents extents, string sImagePath, string description)
    {
        WorksheetPart worksheetPart = this.arbeitsBlatt.WorksheetPart;
        DrawingsPart drawingsPart;
        ImagePart imagePart;
        XDrSp.WorksheetDrawing worksheetDrawing;

        ImagePartType imagePartType = getImageType(sImagePath);

        {
            // --- use the existing DrawingPart
            drawingsPart = worksheetPart.DrawingsPart;
            imagePart = drawingsPart.AddImagePart(imagePartType);
            drawingsPart.CreateRelationshipToPart(imagePart);
            worksheetDrawing = drawingsPart.WorksheetDrawing;
        }

        using (FileStream fileStream = new FileStream(sImagePath, FileMode.Open))
        {
            imagePart.FeedData(fileStream);
        }

        int imageNumber = drawingsPart.ImageParts.Count<ImagePart>();
        if (imageNumber == 1)
        {
            Drawing drawing = new Drawing();
            drawing.Id = drawingsPart.GetIdOfPart(imagePart);
            this.arbeitsBlatt.Append(drawing);
        }

        XDrSp.NonVisualDrawingProperties noVisualDrawingProps = new XDrSp.NonVisualDrawingProperties();
        XDrSp.NonVisualPictureDrawingProperties noVisualPictureDrawingProps = new XDrSp.NonVisualPictureDrawingProperties();

        noVisualDrawingProps.Id = new UInt32Value((uint)(1024 + imageNumber));
        noVisualDrawingProps.Name = "Picture " + imageNumber.ToString();
        noVisualDrawingProps.Description = beschreibung;

        PictureLocks picLocks = new PictureLocks();
        picLocks.NoChangeAspect = true;
        picLocks.NoChangeArrowheads = true;
        noVisualPictureDrawingProps.PictureLocks = picLocks;

        XDrSp.NonVisualPictureProperties noVisualPictureProps = new XDrSp.NonVisualPictureProperties();
        noVisualPictureProps.NonVisualDrawingProperties = noVisualDrawingProps;
        noVisualPictureProps.NonVisualPictureDrawingProperties = noVisualPictureDrawingProps;

        Stretch stretch = new Stretch();
        stretch.FillRectangle = new FillRectangle();

        XDrSp.BlipFill blipFill = new XDrSp.BlipFill();
        Blip blip = new Blip();
        blip.Embed = drawingsPart.GetIdOfPart(imagePart);
        blip.CompressionState = BlipCompressionValues.Print;
        blipFill.Blip = blip;
        blipFill.SourceRectangle = new SourceRectangle();
        blipFill.Append(stretch);

        Transform2D t2d = new Transform2D();
        t2d.Offset = offset;
        t2d.Extents = extents;
        XDrSp.ShapeProperties sp = new XDrSp.ShapeProperties();
        sp.BlackWhiteMode = BlackWhiteModeValues.Auto;
        sp.Transform2D = t2d;
        PresetGeometry prstGeom = new PresetGeometry();
        prstGeom.Preset = ShapeTypeValues.Rectangle;
        prstGeom.AdjustValueList = new AdjustValueList();
        sp.Append(prstGeom);
        sp.Append(new NoFill());

        XDrSp.Picture picture = new XDrSp.Picture();
        picture.NonVisualPictureProperties = noVisualPictureProps;
        picture.BlipFill = blipFill;
        picture.ShapeProperties = sp;

        XDrSp.OneCellAnchor anchor = this.getCellAnchor();

        XDrSp.Extent extent = new XDrSp.Extent();
        extent.Cx = extents.Cx;
        extent.Cy = extents.Cy;
        anchor.Extent = extent;

        anchor.Append(picture);
        anchor.Append(new XDrSp.ClientData());

        worksheetDrawing.Append(anchor);
        worksheetDrawing.Save(drawingsPart);

        #endregion
    }