You cannot post messages because only members can post, and you are not currently a member.
Description:
If you use Python to read, write or otherwise manipulate Excel files, then this is the place for you! This includes the pyExcelerator, xlrd and xlwt libraries along with using COM to manipulate files with Excel itself.
|
|
|
FAQs *** Please read before posting messages here ***
|
| |
=== Moderated group === Updated 2009-02-13
This group is moderated. That means that if you are a new member, your
messages are reviewed by a moderator before they are published. This
is necessary to prevent spam flooding the group. At the time of
writing, the group has 313 real members and 102 banned for attempting... more »
|
|
eliminating the xlrd1 fork
|
| |
I would like to eliminate my `xlrd1` fork, but three issues in `xlrd`
must
be addressed before I can do this:
(1) When I run `xlrd`, thousands of warnings messages spew out. I
need some
mechanism for suppressing these. It is true that I can currently
direct them
to a file, but I'd prefer that they not be generated in the first... more »
|
|
version number discrepancies
|
| |
The Python Package Index lists the current version of xlrd as 0.7.7.
When I
follow the documentation link and go to
[link],
however, that document lists a version number of 0.7.3. When I go to
[link], I see a version number of... more »
|
|
xlrd asserts on my .xls at open_workbook
|
| |
Hello people.
I have this one excel file full of macros provided for the company
which I work which is not being read by xlrd.
I want to automate the reading, processing and maybe also writing of
this excel file.
I can not edit the macros because it is password protected for the
developer in our company.... more »
|
|
Appending a Sheet
|
| |
I was able to copy a sheet and change the header data in it. Now I want to append another sheet to the bottom of it. Can someone give me an idea of how to script that? from xlrd import open_workbook,cellname from xlutils.copy import copy rb = open_workbook('D:\\PythonData\ \ ... in.xls') rs = rb.sheet_by_index(0)... more »
|
|
bug report: Freezing rows/cols does not work with sheets beyond #2
|
| |
bug report: Freezing rows/cols does not work with sheets beyond #2
Using the code below, I create an xls file with multiple sheets in
exactly the same way. The first two sheets have the first row and
column frozen. Sheets 3-5 do not. I expected all sheets to have the
same frozen rows and cols.... more »
|
|
AssertionError parsing an xls file
|
| |
Hi all and thanks for taking the time to read this.
I have an Excel workbook that if I try to open it with xlrd version
0.7.7, will always give me the following error:
...Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python2.7/dist -packages/xlrd/__init__.py", line... more »
|
|
XLWT , XLRD , and XLUTILS
|
| |
Hello,
I am currently trying to download the 3 modules so I can work on Excel
using python. I was excited until I had to install them. I am running
windows right now. And I am having problem installing the different
modules. I red different posts with and the links attached to the
answer etc but nothing seems to be working.... more »
|
|
Making header rows in xlwt
|
| |
I'm trying to create a file which repeats certain header rows when printed out. Excel does provide a way to do this, through the Page Setup options (Sheet -> Rows to repeat at top). Frozen rows don't accomplish this, unfortunately, as they don't work in the Page Layout View (in Excel 2007, anyways).... more »
|
|
Excel & XLRD - How to find extract cell based on text value...
|
| |
Hi,
I have been looking everywhere to figure out how I can (1) find a row
based on the first text value of the row and then (2) confirm that the
first row's cell contains the "text" by comparing to a text variable
and then take the entire row and store it into a list to be used later
in generating a new excel sheet in the format i want.... more »
|
|
Python message while I Run Excel 2007 Macro (win32)
|
| |
Hi Forum, I have started learning Python since last week. Today i tried to automate telnet logging and excel analysis of the log generated using macro and saving the final results to new file. Everything was working very fine.... I got the desired output and all.... but this message while the script was run, is bugging me up. Please tell... more »
|
|
|