Python Packages for Excel - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: Data Science (https://python-forum.io/forum-44.html) +--- Thread: Python Packages for Excel (/thread-13159.html) |
Python Packages for Excel - ImranBhatti - Oct-01-2018 Hi, Which packages are by default included in Python 3.7 to interact with Excel? Imran Bhatti RE: Python Packages for Excel - buran - Oct-01-2018 Python standard library does not have modules that interact with Excel (xl*/xls*) files. You need to install third party packages. There are distributions like Anaconda that come with some third-party packages pre-installed. Actually you still need to install external packages yourself. RE: Python Packages for Excel - pcsailor - Oct-01-2018 Research these modules: * cvs * pyexcel * xlsxwriter * xlrd * xlwt * openpyxl phil RE: Python Packages for Excel - ImranBhatti - Oct-01-2018 thanks to all. Will research phil. little bit feeling I will find what I am after. RE: Python Packages for Excel - snippsat - Oct-01-2018 Also to add to list that @pcsailor posted. Pandas is good,and with Jupyter Notebook get a look that similar to Excel. Common Excel Tasks Demonstrated in Pandas Python Excel Tutorial: The Definitive Guide RE: Python Packages for Excel - buran - Oct-01-2018 also xlwings RE: Python Packages for Excel - ImranBhatti - Oct-02-2018 Thanks for the list. But one thing is still unanswered Which items of these list are shipped with Python 3.7. so that I have not to install them separately? RE: Python Packages for Excel - buran - Oct-02-2018 Did you read my first post: (Oct-01-2018, 09:20 AM)buran Wrote: Python standard library does not have modules that interact with Excel (xl*/xls*) files. You need to install third party packages. Only csv module is part of Standard library, but it's not for xl*/xls* RE: Python Packages for Excel - pcsailor - Oct-03-2018 Nothing from the standard library interacts with .xlsx/.xls with a Python 3.7 installation. You need to install 3rd-party modules, unless .csv is the only type of spreadsheet you need to interact with. If so, you can use the CSV module installed with Python. I can see which modules are installed on my Windows machine looking here: C:\Program Files\Python37\Lib. phil |