WRT creating the Excel file... The previously mentioned techniques work great. But, if you want to start off even simpler, just create a .csv (comma separated value) file with python's file i/o (there is even a python module to help you with this if you want). It is just a simple text file that looks something like this:
Name, Age, Hair Adam, 23, brown Don, 19, gray Biff, 42, blond Cathy, 35, red Gary, 99, none Excel handles these files just fine. You don't get all the fancy formatting, but this is a good first step. Good luck -Scott -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kent Johnson Sent: Monday, May 01, 2006 10:38 AM Cc: Tutor@python.org Subject: Re: [Tutor] Pyton and Webpages Jon Whitehouse wrote: > Greetings All, > > I'm a newbie to python and am curious if I can do the following in python. I'm > not asking HOW to do this, just if it is possible before I spend the time to > learn python and do it myself. > > I want to write a program to go to a webpage, pull the data, and then place it > into an excel spreadsheet and then write it to an html file and allow me to > also click on the link to the excel spreadsheet. > > Is this possible to do with python? Yes. Some of the pieces you might use are urllib2 and BeautifulSoup to get the data from the web page win32com or pyexcelerator to write the Excel file http://docs.python.org/lib/module-urllib2.html http://www.crummy.com/software/BeautifulSoup/index.html http://starship.python.net/crew/mhammond/win32/ http://sourceforge.net/projects/pyexcelerator Kent _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
