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 <d...@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@python.org > To unsubscribe or change subscription options: > https://mail.python.org/mailman/listinfo/tutor >
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor
