On 09/07/14 19:26, John Cast wrote:
I have a bunch of excel spreadsheets (all in the same format) that I am
writing a python script to go through and pick out some information and
post to a wiki page. I'm new to python and have gone through some basic
tutorials. I feel confident that I can figure out how to read an excel
spreadsheet in python.
Its trickier than you might think.
But there are a couple of third party modules you can download.
Google is your friend.
figuring out how to do the web stuff in python.
Python has lots of web frameworks and to be honest there isn't
much to choose between them IMHO. They are all fairly easy to
use and offer the same kind of things.
The webpage doesn't exist yet and I have envisioned that the
> wiki webpage is created once and then simply
> update it every time the script is run.
Thats OK. whats not clear is where you intend to host this 'wiki'?
Is it a traditional hosting company? If so you need to create
the new html file and copy it to the hosting site (maybe using
ftp - Python has an ftp module). But if you are hosting the site
on your own server then you can create the HTML file directly
on the host server.
However, I don't know much about how persistence works with webpages.
I'm not sure what you mean by persistence?
You could do it in several ways but the easiest way is to just recreate
the page each time from a template but substituting the latest data.
But another way is to have a dynamic web page that reads the data from a
database either on the server or via JSON (requires some minimal
JavaScripting)
1) Considering the webpage doesn't exist yet, do I need to 'serve' or
'post' a webpage (as was brought up below)?
where below?
You need a web server somewhere. Either you provide it yourself or
you hire space on a web providers estate.
2) How do I create this wiki webpage? and does this happen in python
every time the script is run?
Lots of options. It depends on how you want it to run, how often it gets
updated, which web framework you choose etc.
3) How do I send my data to this webpage?
See my comments above, but again it depends a lot on where
the web site lives...
--
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.flickr.com/photos/alangauldphotos
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
