[python-win32] PythonWin And Excel Problem

[Michael S]

First of all you should call the random.seed()
function. That was at least what I´ve always done.
seed([x])
    Initialize the basic random number generator. 
Second of all, calling random.random() will give you
this: 
random()
    Return the next random floating point number in
the range [0.0, 1.0).

In your loop try to call random.randit() and call the
random.seed() beforehand.

HTH,
Michael
--- Andrea Gavana <andrea.gavana at gmail.com> wrote:

> Hi All,
> 
>     I am having some problems in running a very
> simple python script,
> which prints some numbers in an Excel spreadsheet.
> The numbers are
> stored in a list. I know that the numbers are
> different (random
> generated), but when I open the Excel file I get a
> column of data with
> all the numbers equal to the first item in the
> python list.
> I attach a very simple script that reproduces the
> problem.
> 
> I am using Python 2.5, PythonWin build 210, Windows
> XP. Am I missing
> something? Thank you for every hint.
> 
> import os
> import random
> 
> from win32com.client import Dispatch
> 
> therand = []
> for ii in xrange(10):
>     therand.append(random.random())
> 
> xlsapp = Dispatch("Excel.Application")
> wb = xlsapp.Workbooks.Add()
> 
> xlsapp.Worksheets.Item(2).Delete()
> xlsapp.Worksheets.Item(1).Delete()
> sheet = wb.Sheets[0]
> sheet.Name = "Data"
> sheet.Range("A1:A10").Value = therand
> 
> excelfile = "C:/HelloWin32.xls"
> 
> wb.SaveAs(excelfile)
> wb.Close()
> xlsapp.Quit()
> 
> os.startfile(excelfile)
> 
> 
> Andrea.
> 
> "Imagination Is The Only Weapon In The War Against
> Reality."
> http://xoomer.virgilio.it/infinity77/
> -- 
> http://mail.python.org/mailman/listinfo/python-list
>