Shapes

// 创建工作簿。
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.Worksheets[0];

// 在特定位置添加一个带自定义名称的形状。
IShape shape = worksheet.Shapes.AddShape("Rectangle", AutoShapeType.Rectangle, 50, 50, 100, 150);

// 或者添加到指定范围。
// IShape rangeShape = worksheet.Shapes.AddShape(AutoShapeType.Rectangle, worksheet.Range["F5:I10"]);

// 分配新名称并通过名称获取形状。
shape.Name = "NewRectangleName";
IShape balloon = worksheet.Shapes["NewRectangleName"];
balloon.TextFrame.TextRange.Text = "Rectangle Shape";
balloon.TextFrame.TextRange.TextAlignment=TextAlignmentAnchor.Center;

// 保存Excel文件。
workbook.Save("RectangleShape.xlsx");

// 创建工作簿。
var workbook = new GrapeCity.Documents.Excel.Workbook();

// 导入工作簿。
var fileStream = this.GetResourceStream("xlsx\\ShapeType.xlsx");
workbook.Open(fileStream);
var sheet = workbook.Worksheets[0];

int row = 2;
int column = 4;
for (int i = 0; i < sheet.Shapes.Count; i++)
{
    var shape = sheet.Shapes[i];

    // 在形状右侧添加一段文字，用于显示该形状的类型。
    sheet.Range[row, column].Value = "This is a " + shape.Type.ToString() + ".";
    sheet.Range[row, column].Font.Bold = true;
    sheet.Range[row, column].Font.Size = 13;

    if ((i + 1) % 4 == 0)
    {
        row = 2;
        column += 6;
    }
    else
    {
        row += 10;
    }
}
        
// 保存 Excel 文件。
workbook.Save("GetShapeType.xlsx");

// 创建工作簿。
var workbook = new GrapeCity.Documents.Excel.Workbook();

// 导入工作簿。
var fileStream = this.GetResourceStream("xlsx\\AutoShapeType.xlsx");
workbook.Open(fileStream);
var sheet = workbook.Worksheets[0];

// 遍历工作表中的所有形状对象。
for (int i = 0; i < sheet.Shapes.Count; i++)
{
    var shape = sheet.Shapes[i];
    if (shape.Type == ShapeType.AutoShape && shape.AutoShapeType == AutoShapeType.Rectangle)
    {
        // 输出矩形的位置及尺寸信息。
        Console.WriteLine("Top: " + shape.Top + " , Left: " + shape.Left + " , Height: " + shape.Height + ", Width: " + shape.Width);

    }

}

public void AdjustmentPointForShape()
{

    // Initialize workbook
    Workbook workbook = new Workbook();
    // Fetch default worksheet 
    IWorksheet worksheet = workbook.Worksheets[0];
    // Add a right arrow callout
    IShape shape = worksheet.Shapes.AddShape(AutoShapeType.RightArrowCallout, 20, 20, 200, 100);

    IAdjustments adjustments = shape.Adjustments;

    // Get the count of adjustment values for shape
    int c = adjustments.Count;
    Console.WriteLine("Count of Adjustment Values: " + c.ToString());

    // Set adjustment values for shapes
    adjustments[0] = 0.5;// arrow neck width
    adjustments[1] = 0.4;// arrow head width
    adjustments[2] = 0.5;// arrow head height
    adjustments[3] = 0.6;// text box width

    // Saving workbook to Xlsx
    workbook.Save(@"AdjustmentPointForShape.xlsx", SaveFileFormat.Xlsx);

}

// Initialize workbook
Workbook workbook = new Workbook();
// Fetch default worksheet
IWorksheet worksheet = workbook.Worksheets[0];

IShapes shapes = worksheet.Shapes;

//add shapes
IShape rectangle = shapes.AddShape(AutoShapeType.Rectangle, 20, 20, 100, 100);
rectangle.Fill.Color.RGB = System.Drawing.Color.Blue;

IShape oval = shapes.AddShape(AutoShapeType.Oval, 50, 50, 100, 100);
oval.Fill.Color.RGB = System.Drawing.Color.Green;

IShape pentagon = shapes.AddShape(AutoShapeType.Pentagon, 80, 80, 100, 100);
pentagon.Fill.Color.RGB = System.Drawing.Color.Red;

IShape triangle = shapes.AddShape(AutoShapeType.IsoscelesTriangle, 100, 100, 100, 100);
triangle.Fill.Color.RGB = System.Drawing.Color.Orange;

//set rectangle above oval
rectangle.ZOrder(ZOrderType.BringForward);

//get position of rectangle in z-order
Console.WriteLine("Z-Order rectangle: " + rectangle.ZOrderPosition);

//set triangle to bottom
triangle.ZOrder(ZOrderType.SendToBack);

//get position of triangle in z-order
Console.WriteLine("Z-Order triangle: " + triangle.ZOrderPosition);

//save to an excel file
workbook.Save("setshapezorder.xlsx");