We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Hyperlink type

Hello


Is there is exists some method for check type of hyperlink

For example:
1) In attached file first sheet contains hyperlink to another range in current workbook
2) Third sheet contains hyperlink to site.

How can i detect target of hyperlink?

Best regards. Alexey

Hi Alexey,

Thanks for your posting and using Aspose.Cells.

You can use Hyperlink.getAddress() property, it will return you address. After parsing it this address, you can know if it is URL or another range in a workbook.

Please see the following code and its console output for your reference.

Java


Workbook workbook = new Workbook(“hyperlink.xlsx”);


String address = workbook.getWorksheets().get(“Содержание”).getHyperlinks().get(0).getAddress();

System.out.println(address);


address = workbook.getWorksheets().get(“Лист1_1”).getHyperlinks().get(0).getAddress();

System.out.println(address);


Console Output:
‘Лист1’!A1
http://rbc.ru/