How to copy hyperlinks using xlrd, xlwt and xlutils?

2013-10-17 Thread Sameer Gupta
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.kisel...@gmail.com?subject=pyExcelerator-feedback&Body=Hello,%

Re: Delete rows using xlrd?

2008-04-18 Thread John Machin
Krishna wrote: > I want to delete some rows (by creating a loop may be) using xlrd. Is > this possible, No. The "rd" in "xlrd" is an abbreviation for "read". It is possible to read the more basic info from an Excel spreadsheet, manipulate it in memory, and

Delete rows using xlrd?

2008-04-18 Thread Krishna
I want to delete some rows (by creating a loop may be) using xlrd. Is this possible, if not how do I do that with python? Please help Thanks Krishna -- http://mail.python.org/mailman/listinfo/python-list

Re: having problem using xlrd

2007-11-21 Thread Kelie
FYI, this question has been answered in python-excel group. Thanks. -- http://mail.python.org/mailman/listinfo/python-list

having problem using xlrd

2007-11-21 Thread Kelie
Hello, I tried using xlrd to read an Excel file and kept getting this error: AttributeError: 'Book' object has no attribute 'mem' >>> import xlrd >>> p = r'C:\2.xls' >>> wb = xlrd.open_workbook(p) >>> wb.get_sheets() AttributeEr

using xlrd

2007-09-18 Thread hassen62
ot;Row2". I have a silly question: What I can write to read this file from The Shell? sorry for this basic question but I can't find a document in the net that helps me for using xlrd. Thank you very much, Hassen.-- http://mail.python.org/mailman/listinfo/python-list

reading xls file using xlrd

2007-09-17 Thread hassen62
Hi, I have installed Xlrd 0.6.1 Win 32. I have a file xls say "file.xls" located as follows:c:/file.xls. This file is composed with two columns of 5 lines. These columns are headed with "Col1" and "Col2", also the 5 rows are named with "Row1",...,"Row2". I have a silly question: What I can do to

Reading Excel using xlrd package in python

2007-02-26 Thread Ananthashayana V
Hi John, With reference to your reply to kath http://mail.python.org/pipermail/python-list/2006-October/407157.html I have a small query, my code is as follows #--- Reading excel-- import xlrd book = xlrd.open_workbook("E:/test.xls") print "The number of wo