Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Date: Thu, 17 Oct 2013 08:15:41 -0700 (PDT)
From: Sameer Gupta <sameercool87@gmail.com>
To: python-list@python.org
Subject: How to copy hyperlinks using xlrd, xlwt and xlutils?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.1166.1382022974.18130.python-list@python.org>
Lines: 68
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:56968

Hello Everyone!

*Problem:*
I am trying a simple code for writting excel sheet. The program checks if
the Excel sheet already exists, If the file exists, then it append it with
the new data. The problem is I am unable to copy hyperlinks. I would be very
thankful if anyone can suggest me some way. 

*Note:* I had used here some default example for hyperlinks. I will be using
this information for my other program where I am suppose to edit excel sheet
with many sheets and every sheet containing hyperlinks at multiple places.

*Code: *
from xlwt import *
import xlrd as xr
import os
from xlutils.copy import copy

name=r"hyperlinks.xls"
if os.path.exists(name)==True:
    print "Excel sheet already exists!!!"
    cwb=xr.open_workbook(name,formatting_info=True)
    w=copy(cwb)
    temp=cwb.sheet_by_index(0)
    ws=w.get_sheet(0)
    row=len(temp.col_values(0))
    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 
    n = "HYPERLINK"
    ws.write_merge(row+1, row+1,1, 10, Formula(n +
'("http://www.irs.gov/pub/irs-pdf/f1000.pdf";"f1000.pdf")'), h_style)
    ws.write_merge(row+2, row+2, 2, 25, Formula(n +
'("mailto:roman.kiseliov@gmail.com?subject=pyExcelerator-feedback&Body=Hello,%20Roman!";"pyExcelerator-feedback")'),
h_style)
    w.save("hyperlinks.xls")  
else:
    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')
    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)

    w.save("hyperlinks.xls")



--
View this message in context: http://python.6.x6.nabble.com/How-to-copy-hyperlinks-using-xlrd-xlwt-and-xlutils-tp5036209.html
Sent from the Python - python-list mailing list archive at Nabble.com.