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 »
|
|
|
Excel 2007 and dates
|
| |
I've got a bunch of Excel 2007 spreadsheets that I need to parse. As
far as I can tell from searching around, there is no release of xlrd
that will do this yet. (Although I'd be quite willing to use a
development branch, if someone is working on it and willing to share.
I could not find a code repository either.)... more »
|
|
|
merging sheets
|
| |
...See xlutils.copy and/or xlutils.filter. Both are covered in the tutorial. ...As I've said several times now, for xlutils.filter to grow this ability would require a lot of work that would need funding. cheers, Chris
|
|
|
IRTDInterface differences in Excel 2003 and Excel 2007
|
| |
I am working with the RTD functions in excel using pythoncom and a
some great sample code from Chris Nilsson. In Excel 2003 and 2007, I
am able to create my python object via the IRTDServer com interface.
Excel then passes a callback interface, IRTDServerEvents to my
object. I hold on to that interface and callback using UpdateNotify... more »
|
|
|
how could I disable gridline display
|
| |
This option in Excel is at "Tools -> Options -> View -> Gridlines(as a
checkbox)".
How could I disable it in xlwt?
Thanks for sharing your experience with me!
Xinhui
|
|
|
Vote on PyPI comments
|
| |
Hi All, Apologies for the cross post, but I'm not sure this has received the publicity it deserves... PyPI grew a commenting and rating system a while back, apparently in response to requests from users. However, since it's been rolled out, there's been a backlash from package maintainers who already have... more »
|
|
|
Zoom in xlwt + auto-adjusting width for columns.
|
| |
Hey everyone,
I'm new here. I'm new in Python, and I'm new in xlwt.
I'm using Python 2.5 on a windows OS (XP) for work. I'm using xlwt
0.7.2.
I looked in the source code but found nothing related to my questions,
and also in the examples. So I'm asking here.
Q1:
I want to create a Excel file. I manage to do it, but I'd like to... more »
|
|
|
Unicode conversion in xlrd
|
| |
First of all, thanks for xlrd, it's saved the day for me, I would
never have believed that after a couple of days experimenting I would
find extracting data from an Excel spreadsheet could be so easy!!
While handling a spreadsheet that is sent to me that has emails pasted
into cells by some arcane process, I get problems with an error... more »
|
|
|
XFStyle from XF instance after xutils.copy
|
| |
Hi,
I'm using xlutils.copy method to copy template xls file, fill
placeholers and return new document to user.
rb = open_workbook('template.xls',f ormatting_info=True)
rs = rb.sheet_by_index(0)
wb = xlutils.copy(rb)
ws = wb.get_sheet(0)
for row in range(rs.nrows):
for col in range(rs.ncols):... more »
|
|
|
Preserve graphs
|
| |
Hi,
Using XLRD and XLUtils:
Is it possible to open an excel file that contains graphs in sheet 1
and data in sheet2, and then modify sheet 2 and save it, without
losing the graphs in sheet 1?
|
|
|
Newbie: How to check for multiple command line arguments
|
| |
Hi, I would like to use multiple command line arguments in my script. If one or all of them are found, the script will produce an output for them (from excel sheet). Please see the code below. Basically the problem is here: if sh.cell(i, 1).value == sys.argv[1]: and I would like to use if sh.cell(i, 1).value == sys.argv[1:]:... more »
|
|
|
|
