Reviews by R Hawk

cpanratings
 

RSS

Spreadsheet-WriteExcel (2.25) ****

Very useful! I found I couldn't write the HYPERLINK function, however, since it was not defined in the hash in Formula.pm. But I figured out the code for HYPERLINK and added it. I didn't have a copy of the Excel Developer's Kit but was able to find the code from the following:

svn.apache.org/repos/asf/poi/tags/REL...

(code I added to line 1313 in Formula.pm:

'HYPERLINK' => [ 359, -1, 1, 0 ],
)
BTW, in case you're wondering, I used HYPERLINK instead of write_url because I wanted to write a URL that was based on a value contained in another cell, and write_url appears to not allow mixing of internal and web addresses.

R Hawk - 2008-12-05T12:01:13 (permalink)

3 out of 3 found this review helpful. Was this review helpful to you?  Yes No