Pyvot connects familiar data-exploration and visualization tools in Excel with the powerful data analysis and transformation capabilities of Python, with an emphasis on tabular data. It provides a minimal and Pythonic interface to Excel, smoothing over the pain points in using the existing Excel object model as exposed via COM.
If a clean Python session can import the win32com module, Pyvot is ready to be installed:
PS C:\> python Python 2.7 (r27:82525, Jul 4 2010, 09:01:59) [MSC v.1500 32 bit (Intel)] on win32 Type "help", "copyright", "credits" or "license" for more information. >>> import win32com >>>
If you have setuptools installed, you can install a source or binary distribution of Pyvot with easy_install. easy_install is usually in <Python directory, ex. C:\Python27>\Scripts
To install the latest version from PyPI:
To install an already-downloaded source (.zip) or binary (.egg) distribution:
If you do not have setuptools or distribute installed (the default, if you used the official Python installer), Pyvot can also be installed manually.
To do so, extract the source .zip for Pyvot, and run the following in the extracted directory:
<Python directory, ex. C:\Python27>\python.exe setup.py install