hyperlinks Module

#!/usr/bin/env python
# -*- coding: windows-1251 -*-
# Copyright (C) 2005 Kiseliov Roman
__rev_id__ = """$Id: hyperlinks.py,v 1.1 2005/10/26 07:44:24 rvk Exp $"""

if __name__ == '__main__':
    from pyExcelerator import *

    f = Font()
    f.height = 20*72
    f.name = 'Verdana'
    f.bold = True
    f.underline = Font.UNDERLINE_DOUBLE
    f.colour_index = 4

    h_style = XFStyle()
    h_style.font = f

    w = Workbook()
    ws = w.add_sheet('F')
    ws_A = w.add_sheet('A')

    ##############
    ## NOTE: parameters are separated by semicolon!!!
    ##############

    n = "HYPERLINK"
    ws.write_merge(1, 1, 1, 10, Formula(n + '("http://www.irs.gov/pub/irs-pdf/f1000.pdf";"f1000.pdf")'), h_style)
    ws.write_merge(2, 2, 2, 25, Formula(n + '("mailto:roman.kiseliov@gmail.com?subject=pyExcelerator-feedback&Body=Hello,%20Roman!";"pyExcelerator-feedback")'), h_style)

    ws.write(3, 0, "Goto Google")
    ws.set_link(3, 0, "http://www.google.com", description="Google")
    ws.write(4, 0, "Goto Next Page")
    ws.set_link(4, 0, "#A!A2", description="page A")

    w.save("hyperlinks.xls")