[Tutor] pyExcelerator and Graphs
Hey friendly users, I have been using pyExcelerator for a short period now, and I'm very satisfied with the results. There is one thing that I just can't do thought, and that is making graphs. I want to add a column (horizontal) type graph. Does anybody know how this can be achieved? Thanks in advance for reading this! Toon Pieton ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] pyExcelerator and Graphs
Toon Pieton wrote: Hey friendly users, I have been using pyExcelerator for a short period now, and I'm very satisfied with the results. There is one thing that I just can't do thought, and that is making graphs. I want to add a column (horizontal) type graph. Does anybody know how this can be achieved? In the readme this is listed as a future feature. Kent ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
[Tutor] pyexcelerator
Are their docs anywhere for pyexcelerator? the built in docs are a bit lacking.For instance I can't figure out how to set a column width.I am just reading the examples and they kind of help but I don't follow this ... ws.col(i).width = 0x0d00 + iwhere i is an incrementing integer.so to me it reads if i = 0.set col 0's width to hexnumber plus 0why the hex number? does it have to be written this way? ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] pyexcelerator
Paul D. Kraus wrote: Are their docs anywhere for pyexcelerator? the built in docs are a bit lacking. For instance I can't figure out how to set a column width. I am just reading the examples and they kind of help but I don't follow this ... ws.col(i).width = 0x0d00 + i where i is an incrementing integer. so to me it reads if i = 0. set col 0's width to hexnumber plus 0 why the hex number? does it have to be written this way? Maybe just try without the 0x0d00 and see what happens? or try the pyExcelerator mailing list on SourceForge... Kent ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] pyexcelerator
Maybe just try without the 0x0d00 and see what happens? or try thepyExcelerator mailing list on SourceForge... Mailing list looks dead only 2 messages.Man this is the exact module i need to finish converting about 20 scripts from perl and I have no idea how to use most of it. This is very frustrating. Is there another excel writer module that has documentation?Or on a broader topic is their a CPAN equivalent? Paul ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] pyexcelerator
Paul D. Kraus wrote: Maybe just try without the 0x0d00 and see what happens? or try the pyExcelerator mailing list on SourceForge... Mailing list looks dead only 2 messages. Man this is the exact module i need to finish converting about 20 scripts from perl and I have no idea how to use most of it. This is very frustrating. Is there another excel writer module that has documentation? If you are running on Windows and have Excel installed you can talk to Excel using COM. Take a look here: http://www.oreilly.com/catalog/pythonwin32/chapter/ch12.html If no one on tutor knows about this you can probably get help with COM on the python-win32 list or comp.lang.python. Kent ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] pyexcelerator
Paul D. Kraus wrote: Are their docs anywhere for pyexcelerator? the built in docs are a bit lacking. For instance I can't figure out how to set a column width. I am just reading the examples and they kind of help but I don't follow this ... ws.col(i).width = 0x0d00 + i where i is an incrementing integer. so to me it reads if i = 0. set col 0's width to hexnumber plus 0 why the hex number? does it have to be written this way? Nothing has to be written in hex. Judging from some of the modules the author used hex a lot. I just looked at my copy of PyExcelerator. It seems to be in poor shape. I tried running some of the modules that have if __name__ == '__main__': (i.e. self-testing) and they failed with errors! And I find no visible documentation or working examples. Sigh. The only thing I've used it for is parsing an existing Excel Workbook. -- Bob Gailer 510-978-4454 ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] pyexcelerator CORRECTION
Bob Gailer wrote: Paul D. Kraus wrote: Are their docs anywhere for pyexcelerator? the built in docs are a bit lacking. For instance I can't figure out how to set a column width. I am just reading the examples and they kind of help but I don't follow this ... ws.col(i).width = 0x0d00 + i where i is an incrementing integer. so to me it reads if i = 0. set col 0's width to hexnumber plus 0 why the hex number? does it have to be written this way? Nothing has to be written in hex. Judging from some of the modules the author used hex a lot. I just looked at my copy of PyExcelerator. It seems to be in poor shape. I tried running some of the modules that have if __name__ == '__main__': (i.e. self-testing) and they failed with errors! And I find no visible documentation or working examples. Sigh. I was looking in the wrong place. Now I see the examples folder. Double Sigh. I'll take a look at them. The only thing I've used it for is parsing an existing Excel Workbook. -- Bob Gailer 510-978-4454 ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] pyexcelerator
I just looked at my copy of PyExcelerator. It seems to be in poor shape.I tried running some of the modules that have if __name__ == '__main__': (i.e. self-testing) and they failed with errors! And I find no visibledocumentation or working examples. Sigh.You might want to check out the recent source from sourceforge its seems very functional and it has a bunch of examples. Not very useful for ones as far as I am concrened. I have not tried to run the modules by themselves.I hate the idea of having to pass or make a call to a perl script to handle the excel stuff its just seems wrong. I wish there was some kind of *open* format that i could write the spreadsheets to that both open office and excel 2000/2003 could read natively. Paul ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
[Tutor] pyExcelerator for Python 2.3
Does anyone know where I can get pyExcelerator for Python 2.3? I have not yet updated my development machine to 2.4. Thanks in advance. ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] pyExcelerator for Python 2.3
Justin Ezequiel wrote: Does anyone know where I can get pyExcelerator for Python 2.3? I have not yet updated my development machine to 2.4. - look through the past releases on sourceforge - ask on the pyExcelerator list - hack the current release to work on 2.3 - most of what is new in 2.4 can be done fairly easily in 2.3 Kent ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
Re: [Tutor] pyExcelerator for Python 2.3
there is a patch submitted there that you can apply to the current release to make it compatible with 2.4. Thanks lots Poor Yorick. ___ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor