How to install Python's XlsxWriter module under windows

This article mainly introduces the XlsxWriter module method of installing Python under windows. It has certain reference value. Now I share it with you. Friends in need can refer to it.

Installing python under windows environment Although the XlsxWriter module is very simple, due to my carelessness, one character was missing, which resulted in many errors. . .

1. Install through the pip command.

C:\Users\Administrator>pip install XlsWriter 
Collecting XlsWriter 
 Could not find a version that satisfies the requirement XlsWriter (from versions: ) 
No matching distribution found for XlsWriter 
You are using pip version 7.1.2, however version 8.1.1 is available. 
You should consider upgrading via the 'python -m pip install --upgrade pip' command.

2. I mistakenly thought that the version of pip was too low, so I followed the prompts in the error message. , update pip

You can see that it will be downloaded first, and then the previous version will be detected, so it will be uninstalled first, and finally the new version of pip will be installed.

C:\Users\Administrator>python -m pip install --upgrade pip 
Collecting pip 
 Downloading pip-8.1.1-py2.py3-none-any.whl (1.2MB) 
 100% |████████████████████████████████| 1.2MB 61kB/s 
Installing collected packages: pip 
 Found existing installation: pip 7.1.2 
 Uninstalling pip-7.1.2: 
  Successfully uninstalled pip-7.1.2 
Successfully installed pip-8.1.1

3. Try the installation again, but still get an error. I feel very strange. What is wrong? After taking a closer look, I found that I had made a low-level mistake. It should be XlsxWriter instead of XlsWriter. It was missing a character x, which caused an error: The version of XlsWriter required to be installed could not be found.

C:\Users\Administrator>pip install XlsWriter 
Collecting XlsWriter 
 Could not find a version that satisfies the requirement XlsWriter (from versions: ) 
No matching distribution found for XlsWriter

#4. This time I finally downloaded it successfully and installed Laughing.

C:\Users\Administrator>pip install XlsxWriter 
Collecting XlsxWriter 
 Downloading XlsxWriter-0.8.6-py2.py3-none-any.whl (134kB) 
 100% |████████████████████████████████| 143kB 26kB/s 
Installing collected packages: XlsxWriter 
Successfully installed XlsxWriter-0.8.6

5. Another method is to install the XlsxWriter module through eays_install.

C:\Users\Administrator>easy_install XlsxWriter 
Searching for XlsxWriter 
Best match: XlsxWriter 0.8.6 
Adding XlsxWriter 0.8.6 to easy-install.pth file 
 
Using c:\python27\lib\site-packages 
Processing dependencies for XlsxWriter 
Finished processing dependencies for XlsxWriter

6. Next, verify whether the installation is successful.

Open cmd here and enter python to enter the python interactive environment.

The simplest way is to import this module. If no error is reported, it means the installation is successful.

What should be emphasized here is that although the module name above is XlsxWriter, when imported here, it is all lowercase xlsxwriter. As long as one character is different, an error will be reported.

C:\Users\Administrator>python 
Python 2.7.11 (v2.7.11:6d1b6a68f775, Dec 5 2015, 20:40:30) [MSC v.1500 64 bit (AMD64)] on win32 
Type "help", "copyright", "credits" or "license" for more information. 
>>> import xlsxwriter 
>>>

I have to say that it is very convenient to install various modules of python, which is great lol

Detailed reference about the XlsxWriter module Information can be found at: https://xlsxwriter.readthedocs.io/

Related recommendations:

Use python to implement XlsxWriter to create and edit Excel files

Simple analysis of the xlsxwriter library in python

The above is the detailed content of How to install Python's XlsxWriter module under windows. For more information, please follow other related articles on the PHP Chinese website!