此示例演示如何使用以下 API 将超链接与图片相关联。
成员
描述
PictureCollection.AddPicture
插入文件或SpreadsheetImage源对象以适合指定范围。
Shape.InsertHyperlink
创建一个新的形状超链接具有传递的超链接目标的对象。超链接可以引用网页、现有文件或目录、电子邮件地址或单元格区域。
HyperlinkBase.TooltipText
指定超链接的工具提示。当光标悬停在图片上时,将显示此文本。
下面的代码示例插入了一张图片,并附加了一个超链接。
Vb.Net |
'创建一个Workbook工作簿对象. Dim workbook As New DevExpress.Spreadsheet.Workbook() Dim picture As DevExpress.Spreadsheet.Picture = workbook.Worksheets(0).Pictures.AddPicture("D:\DevExpress.png", workbook.Worksheets(0).Cells("A1")) Dim shapeHyperlink As DevExpress.Spreadsheet.ShapeHyperlink = picture.InsertHyperlink("https://community.devexpress.com/blogs/", True) shapeHyperlink.TooltipText = "Check the recent DevExpress blogs" |
C# |
// 创建一个Workbook工作簿对象. DevExpress.Spreadsheet.Workbook workbook = new DevExpress.Spreadsheet.Workbook(); DevExpress.Spreadsheet.Picture picture = workbook.Worksheets[0].Pictures.AddPicture(@"D:\DevExpress.png", workbook.Worksheets[0].Cells["A1"]); DevExpress.Spreadsheet.ShapeHyperlink shapeHyperlink = picture.InsertHyperlink("https://community.devexpress.com/blogs/", true); shapeHyperlink.TooltipText = "Check the recent DevExpress blogs"; |