Need yo get the URL from a cell with a hyperlink

This is a great class, and it has solved all of my problems except one.

The first column in the first sheet of a seven sheet xlsx file contains a HYPERLINK.

When I try and read it, I get something that displays as " URL Link". I need to get the full URL to store in my database.

Obviously, I am missing something. Can anyone help me?

$xlsx = new SimpleXLSX('book_with_hyperlinks.xlsx');

echo '<pre>';
foreach( $xlsx->rowsEx() as $r ) {
print_r( $r );
}
echo '</pre>';

Thanks Sergey, for the quick reply. I'm afraid I'm still confused. Using your code, here is what I see for the cell where the link is located:

Array
(
[0] => Array
(
[type] => s
[name] => A2
[value] => 161000175
[href] => URL Link
[f] =>
[format] => General
)

[1] => Array
(
[type] => s
[name] => B2
...

I would expect to see an actual link in the [href] element. Perhaps the folks who created the spreadsheet did something weird in their hyperlink.

In the spreadsheet, cell A2 displays '161000175', which is underlined as a link. When pressed, it loads a page into my open browser.

Am I missing something?

Sergey,

I'm just a so-so PHP programmer. I've been able to get everything out of an xlsx file except the URL from a HYPERLINK cell.

I propose paying you to write the explicit code for my application. I will send you a file, you return code that extracts URLs from one column of the sample spreadsheet.

I propose $200, half in advance.

Any interest?

Thanks,

Harold Spencer
[email protected]