[BangPypers] Excel and Python

Vishal vsapre80 at gmail.com
Fri Sep 4 21:37:43 CEST 2009


I would advice you to take hints from the existing tools and then devise a
module specific to your requirements. Working with excel depends a lot on
what you want to do with the data that you are working on and so a single
module is rarely all that you need.
If you are on a windows machine, win32com is your best friend, because it
will allow you to do almost everything with excel (charts, pivot tables etc
etc, apart from regular row/col data management)

tip: on some versions of excel, the excel specific constants (xlFirstRow,
xlFirstColumn etc) are not available readily after creation of the excel
object in Python. You would be better off maintaining these variables and
their values in your module separately. For more info on these constants,
try MSDN.

Take care,
Vishal

On Wed, Sep 2, 2009 at 8:22 PM, Noufal Ibrahim <noufal at gmail.com> wrote:

> and http://pypi.python.org/pypi/pyExcelerator/
>
> On Wed, Sep 2, 2009 at 6:39 PM, Baiju M<mbaiju at zeomega.com> wrote:
> > These tools looks very good to deal with Excel files:
> >
> > http://pypi.python.org/pypi/xlrd (read
> > http://pypi.python.org/pypi/xlwt
> > http://pypi.python.org/pypi/xlutils
> >
> > These are pure Python packages and it works in all platforms.
> >
> > Regards,
> > Baiju M
> > _______________________________________________
> > BangPypers mailing list
> > BangPypers at python.org
> > http://mail.python.org/mailman/listinfo/bangpypers
> >
>
>
>
> --
> ~noufal
> http://nibrahim.net.in
> _______________________________________________
> BangPypers mailing list
> BangPypers at python.org
> http://mail.python.org/mailman/listinfo/bangpypers
>



-- 
Thanks and best regards,
Vishal Sapre

---

"So say...Day by day, in every way, I am getting better, better and better
!!!"
"A Strong and Positive attitude creates more miracles than anything else.
Because...Life is 10% how you make it, and 90% how you take it"
"Diamond is another piece of coal that did well under pressure”
"Happiness keeps u Sweet, Trials keep u Strong,
Sorrow keeps u Human, Failure Keeps u Humble,
Success keeps u Glowing, But only God Keeps u Going.....Keep Going....."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/bangpypers/attachments/20090905/cf33a039/attachment.htm>


More information about the BangPypers mailing list