Python read-write operations excel--install third-party libraries (XLRD, XLWT, Xlutils)

Source: Internet
Author: User

Data processing is a great application of Python, while Excel is the most popular data processing software. So when it comes to data-related work with Python, it's hard to deal with Excel.

If you just want to save your data as a form, you can work with it in CSV format (a comma-delimited tabular data format), which Excel supports. However, the standard Excel file (XLS/XLSX) has a more complex format and is not easy to read and write directly like a normal text file, and it needs to be implemented with a third-party library.

The common library is the Python-excel series:

XLRD, XLWT, xlutils

    • XLRD-Read Excel file

    • XLWT-writing to an Excel file

    • Xlutils-Utilities for working with Excel files, such as copying, splitting, filtering, etc.

Installation

1.:

https://pypi.python.org/pypi/xlrd/1.1.0

https://pypi.python.org/pypi/xlwt/1.3.0

https://pypi.python.org/pypi/xlutils/2.0.0

  

2. Installation

2.1, installation of XLRD,

Method One:

Switch to the source file, execute the command python setup.py install

    

After success will add XLRD folders and files under Site-packages

    

2.2, Installation XLWT

Method Two:

Switch to the source file, execute the command pip install XLWT-1.3.0-PY2.PY3-NONE-ANY.WHL

    

After successful installation, the XLWT folder and files will be added under Site-packages.

2.3, Installation Xlutils

Switch to the source file, execute the command pip install XLUTILS-2.0.0-PY2.PY3-NONE-ANY.WHL

     

After successful installation, the Xlutils folder and files will be added under Site-packages.

Python read-write operations excel--install third-party libraries (XLRD, XLWT, Xlutils)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.