🌐 Mailman 3 December 2006 - Python-list - python.org

proof of concept python and tkinter gnugo interface
by Anton Vredegoor Dec. 1, 2006

Dec. 1, 2006

For the last few days I've been doodling with a script that provides a graphical interface to gnugo by using its GTP protocol. At the moment the script is *very* basic, in fact the only thing it does is to allow one to click on a coordinate and place a move there OR press the space bar in order to let gnugo generate a move. However, I feel that this idea has some potential, it could be made to undo or redo moves or load sgf-games. But most importantly: It could load the list of move suggestions from gnugo, do some computations itself in *Python* on that list and then generate a move. So I thought that it would be best to present this script while it is still small and modifications can be done easily. In the end there's possibly a lot of potential and I think I'm going to need some help from people that are enthousiastic about Python or gnugo. What I want to accomplish with this post is to get to know whether it would be a good idea to make it a sourceforge project (it would be even better if some more experienced sourceforger would do it for me :-) or whether I should just go on doodling on this script by myself, gradually adapting it to fit my personal interests and come back to you in a few years with a more complete script. Is there any need for such a beast for *more* people than just me to work on? Here's the proof of concept, just copy it to some dir and run the Python script: http://home.hccnet.nl/a.vredegoor/gnugo/ It needs Python 2.5 which you can get at: http://www.python.org/ Anton

2 2

More elegant to get a name: o.__class__.__name__
by alf Dec. 1, 2006

Dec. 1, 2006

Hi, is there a more elegant way to get o.__class__.__name__. For instance I would imagine name(o). -- alf

4 4

PythonWin And Excel Problem
by Andrea Gavana Dec. 1, 2006

Dec. 1, 2006

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/

2 2

Re: Win32 Excel Generation Slow
by Paul McGuire Dec. 1, 2006

Dec. 1, 2006

"Daniel Bowett" <daniel(a)bowettsolutions.com> wrote in message news:mailman.928.1164969844.32031.python-list@python.org... >I am trying to create an excel document that displays a table of data. It >does exactly what I want but takes a long time. I am writing around 1000 >rows and it takes around a second to do each row. > > Is there a quicker way to write this? The reason I want excel is this > needs to read and manipulated by management. > Are there many many formulas in your worksheet? Try setting calculate to manual, and turn off screenupdating while creating your rows. Then when done, do a manual calculate, and turn auto calc and screenupdating back on. (These are all open to the COM interface, although I don't recall the exact function names.) -- Paul

1 0

I/O Multiplexing and non blocking socket
by Salvatore Di Fazio Dec. 1, 2006

Dec. 1, 2006

Hi guys, I'm looking for a tutorial to make a client with a i/o multiplexing and non blocking socket. Anybody knows where is a tutorial? Tnx

3 2

Re: PythonWin And Excel Problem
by Roger Upole Dec. 1, 2006

Dec. 1, 2006

"Andrea Gavana" <andrea.gavana(a)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) > Each row you insert into the Range need to be a sequence: therand.append((random.random(),)) Roger ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =----

1 0

Re: Win32 Excel Generation Slow
by Roger Upole Dec. 1, 2006

Dec. 1, 2006

"Daniel Bowett" <daniel(a)bowettsolutions.com> wrote in message news:mailman.928.1164969844.32031.python-list@python.org... >I am trying to create an excel document that displays a table of data. It does exactly what I want but takes a long time. I am >writing around 1000 rows and it takes around a second to do each row. > > Is there a quicker way to write this? The reason I want excel is this needs to read and manipulated by management. > > The function I am using is: > > def createExcel(data): > xlApp = Dispatch("Excel.Application") > wb = xlApp.Workbooks.Add() > xlApp.Visible = 1 > ws = wb.Worksheets[0]; > > headers = ["Sales Rank", "UPC", "Description", "Stock", "Manifest Stock", "Total Stock", "Week Sales", "Price", "Total Price", > "Days Cover"] > > column = 1 > for each in headers: > xlApp.ActiveSheet.Cells(1, column).Value = each > column = column + 1 > > row = 1 > for eachline in data: > xlApp.ActiveSheet.Cells(row, 1).Value = row > xlApp.ActiveSheet.Cells(row, 2).Value = eachline[0] > xlApp.ActiveSheet.Cells(row, 3).Value = eachline[1] > xlApp.ActiveSheet.Cells(row, 4).Value = eachline[2] > xlApp.ActiveSheet.Cells(row, 5).Value = eachline[3] > xlApp.ActiveSheet.Cells(row, 6).Value = eachline[4] > xlApp.ActiveSheet.Cells(row, 7).Value = eachline[5] > xlApp.ActiveSheet.Cells(row, 8).Value = eachline[6] > xlApp.ActiveSheet.Cells(row, 9).Value = eachline[7] > xlApp.ActiveSheet.Cells(row, 10).Value = eachline[8] row = row + 1 > If you preformat the data including the row number, you can insert it en masse using a Range object. This runs in just a couple of seconds: from win32com.client import Dispatch data=[(x,'data1','data2','data3','data4','data5','data6','data7','data8','data9') for x in xrange(1000)] def createExcel(data): xlApp = Dispatch("Excel.Application") wb = xlApp.Workbooks.Add() xlApp.Visible = 1 ws = wb.Worksheets[0]; headers = ["Sales Rank", "UPC", "Description", "Stock", "Manifest Stock", "Total Stock", "Week Sales", "Price", "Total Price", "Days Cover"] column = 1 for each in headers: xlApp.ActiveSheet.Cells(1, column).Value = each column = column + 1 xlApp.ActiveSheet.Range("A2:J1001").Value=data createExcel(data) Roger ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =----

1 0

PythonWin And Excel Problem
by Andrea Gavana Dec. 1, 2006

Dec. 1, 2006

Hi Michael, > First of all you should call the random.seed() > function. That was at least what I´ve always done. > seed([x]) Thanks for your suggestion, but it doesn't matter whether you call seed() or not. The random number generator can *not* return 10 equal values if called 10 times, irrespective of the fact that it is initalized or not. You can try by simply doing: import random print random.random() print random.random() print random.random() And you'll see that the numbers are different. Moreover, I can populate that list by hand with 10 values like: therand = [ii for ii in xrange(1, 11)] And the result in Excel will be the same. All the cells will have the value 1. Andrea. "Imagination Is The Only Weapon In The War Against Reality." http://xoomer.virgilio.it/infinity77/

1 0

route planning
by Andre Meyer Dec. 1, 2006

Dec. 1, 2006

Hi all Just a very simple question: where can I find a module for route planning? I have looked around and found some implementations of graph theory, e.g. http://sourceforge.net/projects/pynetwork/. But, what I need is not an abstract graph, but one where nodes/vertices have locations (2D), are connected (to follow a path, respecting distance among nodes) and where I can easily find the closest edge and vertex from any point in space. your links are much appreciated thanks André

1 0

recover/extract content from html with help of cheetah templates
by manuel.reil＠googlemail.com Dec. 1, 2006

Dec. 1, 2006

Hello, currently i am developing a very small cms using python and cheetah. very early i have noticed that i was lacking the method to extract/recover the contents (html,text) from the html that is generated by cheetah and delivered to the site viewer. to explain it further: during the output processing by cheetah placeholders are replaced with my text/html input. to edit/alter the page i have to extract my personal input out of the delivered html again, like a diff of output html and the template. is there a method integrated in cheetah which i have not noticed so far to do this? or have i to write a own "diff" method? thanks in advance, manuel

1 0