Prev
Absolute |
ExcelExplorer Manual |
Next
TextMark |
 |
(ExcelExplorer 4.0)
Get hyperlink's URL or file path.
EEData Link( )
Parameters
- None
Description
Returns the link URL or file path.
Always returns valid EEData object.
For links with type EE_LINK_WORKBOOK returns empty string (see TextMark()).
Note that full link address can consists of the URL and text mark (cells B6 and B7 from the worksheet below).
Worksheet used in the example below:
 |
A |
B |
C |
| 1 |
|
|
|
| 2 |
|
http://www.google.com/ |
|
| 3 |
|
C:\AUTOEXEC.BAT |
|
| 4 |
|
..\..\file.txt |
|
| 5 |
|
mailto:example@example.com?subject=Subject |
|
| 6 |
|
Sheet1!A1 |
|
| 7 |
|
file.xls#Sheet1!A1 |
|
| 8 |
|
\\server\share\file.txt |
|
| 9 |
|
|
|
Print link URLs
<?php
$area = $ee->Worksheet(0)->UsedArea();
if( $area !== false ) {
for( $col = $area->FirstColumn(); $col <= $area->LastColumn(); $col++ ) {
for( $row = $area->FirstRow(); $row <= $area->LastRow(); $row++ ) {
$link = $ee->Cell(0,$col,$row)->Link();
if( $link !== false ) {
echo 'Link in column '.$col.', row '.$row.': ';
echo $link->Link()->UTF8();
echo "\n";
}
}
}
}
?>
Will output: Link in column 1, row 1: http://www.google.com/
Link in column 1, row 2: C:\AUTOEXEC.BAT
Link in column 1, row 3: ../../file.txt
Link in column 1, row 4: mailto:example@example.com?subject=Subject
Link in column 1, row 5:
Link in column 1, row 6: file.xls
Link in column 1, row 7: \\server\share\file.txt
| 
