Delete rows using xlrd?

John Machin sjmachin at lexicon.net
Fri Apr 18 17:57:09 EDT 2008


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 write out the results to a new file using another package 
e.g. pyExcelerator (or xlwt, a bug-fixed fork of pyEx.*).

If you can find in the xlrd README or documentation even the vaguest 
hint that xlrd can be used by itself for changing the contents of an XLS 
file, please let me know, and I'll reword it.

> if not how do I do that with python? Please help

Perhaps you could read the concurrent thread where somebody with a name 
very similar to yours is getting help on a script that uses the pywin32 
COM approach :-)




More information about the Python-list mailing list