添加图像超链接

超链接对于访问其他工作表或网站上的信息非常有用。Microsoft Excel允许用户在单元格文本和图片上添加超链接。图片超链接可以使导航工作表更方便，例如，作为下一页和上一页按钮，或链接到特定网站的徽标。本文说明如何使用Aspose.Cells for Node.js via C++在工作表中插入图片超链接。

Aspose.Cells for Node.js via C++允许您在运行时为电子表格中的图片添加超链接。可以设置和修改超链接的屏幕提示和地址。以下示例代码演示了如何向工作表中添加图片超链接。

const AsposeCells = require("aspose.cells.node");
const path = require("path");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");

// Create directory if it is not already present.
const fs = require("fs");
if (!fs.existsSync(dataDir)) {
    fs.mkdirSync(dataDir);
}

// Instantiate a new workbook
let workbook = new AsposeCells.Workbook();

// Get the first worksheet
let worksheet = workbook.getWorksheets().get(0);

// Insert a string value to a cell
worksheet.getCells().get("C2").putValue("Image Hyperlink");

// Set the 4th row height
worksheet.getCells().setRowHeight(3, 100);

// Set the C column width
worksheet.getCells().setColumnWidth(2, 21);

// Add a picture to the C4 cell
let index = worksheet.getPictures().add(3, 2, 4, 3, path.join(dataDir, "aspose-logo.jpg"));

// Get the picture object
let pic = worksheet.getPictures().get(index);

// Set the placement type
pic.setPlacement(AsposeCells.Drawing.PlacementType.FreeFloating);

// Add an image hyperlink
let hlink = pic.addHyperlink("http://www.aspose.com/");

// Specify the screen tip
hlink.setScreenTip("Click to go to Aspose site");
let outputFilePath = path.join(dataDir, "ImageHyperlink.out.xls");
// Save the Excel file
workbook.save(outputFilePath);