[Tutor] How to Create Webpage with Python

[John Cast]

Hey everyone,

I really appreciate all of the help you given me.
I am making progress, however I have reached a problem I'm not sure how
best to tackle and would like someone with more experience with excel and
python to lend their knowledge/opinion before I dive in further.

I have two questions:
1) I'd like to be able to do a 'save-as web page' in python for my excel
workbook.  I tried this by hand and everything looks good EXCEPT that the
header cells sometimes were too narrow (because the person who created the
workbook didn't expand out each column enough sometimes) and thus blocked
some of the text in them occasionally.
Is it possible to do a 'save-as web page' for the workbook in python?

2)  So (assuming I can do this 'save-as webpage' in code) I need to go
through each sheet in the workbook and change each column's width so that
it can hold all of its text.  I realize that xlrd is for reading and xlwt
is for writing and there is xutils for particular combinations of both
reading and writing.  However, nothing to do quite what I've stated as far
as I can tell (so far).  I currently open the workbook I want to modify
using the open_workbook functionality in the xlrd module.  As I understand
it I need the xlwt module to write to this workbook, but since it's opened
in xlrd do I just open the same workbook in xlwt again?  If so does each
module simply have a handle to the same file?

NOTE: I'm basically just trying to present my excel workbook on the web as
it's shown in excel (retaining as much formatting as possible).

Thanks again,
John


On Sat, Jul 12, 2014 at 4:32 PM, Danny Yoo <dyoo at hashcollision.org> wrote:

> Hi Chris,
>
> Yikes.  I need to say that as, for disclosure: I work at Google.  I do
> not work on the App Engine team, but I need to acknowledge my
> potential conflict-of-interest, and I apologize for not stating this
> in my reply.
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> https://mail.python.org/mailman/listinfo/tutor
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20140714/a3856e67/attachment-0001.html>