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 »
|
|
|
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 »
|
|
|
Newbie: extracting only certain cells in a column (xlrd)
|
| |
Hi, I would like to print out only certain cells in an Excel table. The extraction criteria is in a third column and if this criteria is met, I would like to print the information in ninth column. ...for i in range(len(sh.col_values(8))): if sh.col_values(2).value[i] == "temp": print sh.col_values(8)[i]... more »
|
|
|
Newbie: Reading and printing cells from excel
|
| |
Hi,
I'm python newbie but I'm trying to read data from Excel file (from
one column) and print it into the output. Here's my code:
------------- python code -----------
...
import xlrd
wb = xlrd.open_workbook('testiexcel .xls')
...sh = wb.sheet_by_name(u'data')
sposti = sh.col_values(8)... more »
|
|
|
stripping lines from an excel file
|
| |
I am trying to find a string and copy the lines that have that string
in it to another excel file.
My issue now I can only copy the cells that come after the cell with
the string I flag. Ive tried to store out each line into a temporary
list (not good for speed or memory) but I cant, I think because each... more »
|
|
|
Problem while reading date in date format from excel sheet.
|
| |
Hi All,
I have stored date of birth in the below format in excel file.
DateOfBirth
10/15/1980
While reading this value from excel into the application the value is
read as 29509.0
I need a string to be return in the format mm/dd/yyyy.
following is the snippet of my code
def read_from_excel(self,filepath, sheetname,columnname,rowno):... more »
|
|
|
Protect sheet and allow formatting of cells, columns, rows
|
| |
Hi,
Using xlwt I can't see how to protect a worksheet, yet allow
formatting of cells, columns, rows, as you can do when applying
worksheet protection in the Excel 2003 UI. I would have guessed that
you would set:
sheet.protect = True
and
sheet.wnd_protect = False
but that seems to have no effect, at least on this score.... more »
|
|
|
Outline collapse
|
| |
Hi guys,
I have a 3 level outline and I'd like to have all 2nd level groupings
collapsed by default. The private 'collapse' variable gave me hope
initially but after trying various things to set it, I haven't had
much luck. Is there any way to get around this?
Thanks
|
|
|
Dumb question about updating xlrd version
|
| |
Sorry for the question. I have just started using xlrd and it seems to
be the perfect solution for what I need (read an excel file into
python!! :-). I noticed that version 0.71 is out. Now, what is the
best way for updating the package without messing things up? I am on
Windows XP. I assume the new version is backward compatible.... more »
|
|
|
|
