Posted on 2005-10-15 21:19:26-07 by cilynx
How to Access Hyperlinks in Cells in Spreadsheets
I have a bunch of spreadsheets that include links to websites in some of the cells. I need access to this content.

$doc->getCellValue($cell)
Wraps the visible string in <<>> if it is a hyperlink, but gives no hint of the link content.

$doc->cellValueType($cell)
Returns 'string' even when the cell holds a hyperlink

getAttributes() didn't return any keys that looked useful either.

Is there some way that I haven't thought of to access the link content?

Thanks --
Direct Responses: 1189 | Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.