Re: How does one manipulate cell values with Python.

[Jim Tarvid <tarvid ls net>]

A few years ago, I needed "pivot" and resorted to short python
scripts. One example follows:

#!/usr/bin/python
#pyaay.py - prevalence by year and age to age and year, tail constant
from numpy import *
import xlrd
import csv
d=zeros ((7,41))
fn="prev.xls"
print fn;
book = xlrd.open_workbook(fn)
sh = book.sheet_by_index(1)
for a in range(1,8):
  for y in range(1,18):
    v=sh.cell_value(y,a)
    d[a-1][y-1]=v
    print "d[",a-1,",",y-1,"]=",v
  for y in range(18,42):
    d[a-1][y-1]=v
    print "d[",a-1,",",y-1,"]=",v

writer = csv.writer(open("prev.csv", "wb"))
for a in range(7):
  writer.writerow(d[a])

On Tue, May 8, 2012 at 6:07 AM, Jean Bréfort
<jean brefort normalesup org> wrote:
> You might find some hints at
> http://projects.gnome.org/gnumeric/doc/sect-extending-python-console.shtml
>
> Regards,
> Jean
>
> Le lundi 07 mai 2012 à 15:37 +0700, Dr. Edward Scott a écrit :
> > With Visual Basic one can manipulate the value in a cell using:
> > Activecell.value = 24 for example.  What statement in Python is used to
> > accomplish the same action?  The Python manuals are silent on the matter
> > so far as I can tell and the gnumeric help offers no information that I
> > can discern.
> > ers dallas gmail com
> > _______________________________________________
> > gnumeric-list mailing list
> > gnumeric-list gnome org
> > http://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list



-- 
Kindness Works!
Rev. Jim Tarvid, PCA
12897A Grays Pointe Road, Fairfax, Va 22033
703-657-0099 Condo
703-594-7297 Google Voice
877-465-7638 x4101
38.8778239, -77.392696
http://ls.net