This example uses the Shape properties to modify a picture inserted in a worksheet.
C#:ShapeActions.cs |
workbook.Unit = DevExpress.Office.DocumentUnit.Millimeter;
workbook.BeginUpdate();
try
{
Worksheet worksheet = workbook.Worksheets[0];
Picture pic = worksheet.Pictures.AddPicture("Pictures\\chart.png", worksheet.Cells["A1"]);
worksheet.Pictures.AddPicture("Pictures\\candles.png", worksheet.Cells["D5"]);
pic.Name = "Candles";
pic.AlternativeText = "Candles snapshot";
pic.BorderWidth = 1;
pic.BorderColor = DevExpress.Utils.DXColor.Black;
pic.Move(20, 30);
pic.Placement = Placement.MoveAndSize;
worksheet.Rows[5].Height += 10;
worksheet.Columns["D"].Width += 10;
pic.Rotation = 30;
pic.IncrementRotation(-30);
pic.InsertHyperlink("http://www.devexpress.com/", true);
worksheet.Shapes[1].InsertHyperlink("http://www.devexpress.com/Products/NET/Controls/WPF/", true);
}
finally
{
workbook.EndUpdate();
}
|
VB:ShapeActions.vb |
workbook.Unit = DevExpress.Office.DocumentUnit.Millimeter
workbook.BeginUpdate()
Try
Dim worksheet As Worksheet = workbook.Worksheets(0)
Dim pic As Picture = worksheet.Pictures.AddPicture("Pictures\chart.png", worksheet.Cells("A1"))
worksheet.Pictures.AddPicture("Pictures\candles.png", worksheet.Cells("D5"))
pic.Name = "Candles"
pic.AlternativeText = "Candles snapshot"
pic.BorderWidth = 1
pic.BorderColor = DevExpress.Utils.DXColor.Black
pic.Move(20, 30)
pic.Placement = Placement.MoveAndSize
worksheet.Rows(5).Height += 10
worksheet.Columns("D").Width += 10
pic.Rotation = 30
pic.IncrementRotation(-30)
pic.InsertHyperlink("http://www.devexpress.com/", True)
worksheet.Shapes(1).InsertHyperlink("http://www.devexpress.com/Products/NET/Controls/WPF/", True)
Finally
workbook.EndUpdate()
End Try
|