获取范围内的超链接

获取范围内的超链接

这范围类提供了获取超链接()获取选定范围内所有超链接的属性获取器。您也可以通过调用[超链接.delete()](https://reference.aspose.com/cells/java/com.aspose.cells/hyperlink#delete()） 方法。

示例代码

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// Instantiate a Workbook object
// Open an Excel file
Workbook workbook = new Workbook(sourceDir + "HyperlinksSample.xlsx");

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

// Create a range A2:B3
Range range = worksheet.getCells().createRange("A2", "B3");

// Get Hyperlinks in range
Hyperlink[] hyperlinks = range.getHyperlinks();

for (Hyperlink link : hyperlinks){
    System.out.println(link.getArea() + " : " + link.getAddress());

    // To delete the link, use the Hyperlink.Delete() method.
    link.delete();
}

workbook.save(outputDir + "HyperlinksSample_out.xlsx");